Basics of data warehousing? Interviewing for a PM role with some data warehousing project experience required. In initial convo with recruiter she didn’t seem concerned about my lack of experience but I went to be prepared for my interview with the hiring manager. Sorry for the newb question!

like
Posting as :
works at
You are currently posting as works at

Just keep asking about where their data live.

“data? Where housing?”

likefunny

Forklifts everywhere. Tall about forklift non stop

likefunny

Pro tip it’s call a data pallet jack (DPJ) for short; some cos call it it a server jack as well.

Oh man... you is fucked!

Joking aside.... as a PM (I am assuming a traditional PM and not a technical PM).... you do not need to know the whole DW lifecycle bullshit (Kimball or the garbage Snowflake shit). The key things to keep in mind for DW or EDW are at a high level:1) sourcea and velocity (realtime or timed updates [batch]), 2) transformations (what doea the business need from the source to make decisions - this informs which source actually meets the bill), 3) how to make the data , at thw dw, sensible (are all elements available?, have the time lines been met [this is important for the different LOBs - finance needs realtime, CxO just montly and aggregated, line mgrs need exexution times ans so on). From a PM perspective you only need highlevel but still need a little nuance from the LOB level

like

Thank you! This is super helpful. I have a little experience implementing SAP BW and am trying to refresh my memory from that project, but this is great stuff as I prepare :)

Fact & Dimension modeling using Star/Snowflake Schema
Slowly Changing Dimensions
Data Marts
It might help to understand on a high level the product offering of the popular DW & ETL tools in the market

like

Kimble has great book!! But honestly, just talk about forklifts and you’ll be fine.

like

Related Posts

Hi folks,

I am looking for ReactJS developer role/ frontend developer role
Total experience 2.8 years
Relevant Experience 2.3 years
LWD 5 August
If vacancy available kindly refer me
Thanks

like

Exit to Amazon London L6 with £95k TC (68 base, 10 bonus, and 19 shares, vesting 0-3-8-8). Is this a fair offer?
I was hoping for £100k TC.

like

Looking for the right kind of corporate affairs/PA position in Edinburgh. Any referrals out there? My background is mostly global work with experience in leadership and management. I’m open to consultancy/agency and in-house equally. Thank you for sending any leads my way!!!!

Which recruiters do you all find have the best connections to in-house job opportunities? I am DONE with agency life. TIA!

like

Quick question.
I was a contractor for a big company and they just let me know that my last day is December 30th. I got this position thanks to a recruiting company that has been great and gives me benefits.
Should I:
- Continue working with the recruiting company, hoping that they will find another position for me? (as they told me they will, and when they applied me I started working with my current company within 2 weeks)
- Work with the recruiter + apply for jobs on my own?

like

I am in a dilemma choosing between Wolters Kluwer and S&P Global(IHS). Any suggestions? Salary and role are the same.

likehelpful

Hi Fishes,
It's over a month I had applied for a job post at career portal of accenture and still it is showing your application is under evaluation. My job CID no is C7183481. And now I am unable apply for other job openings too. Can anyone help me to apply for job post also and to know about the status of this applied position.

Have worked previously as business consultant, pm in banking domain (10 years) and now as Product manager for a Bank(1 yr) - what are the chances FAANG would be interested in my profile for product manager/ project manager profile?

like

Hi Sharks, Off topic question. How long does HSBC take to schedule psychometric test. I attended managerial round on 10th aug and person who referred me confirmed that I cleared managerial round. I recently joined IBM and waiting for the project. In April I applied for an position but no test or interview was scheduled and recruiter asked me to give other email id as my application was already present in HSBC portal. HSBC India IBM Tata Consultancy Deloitte Accenture Cognizant Infosys

like

Got the offer Amazon L5 Cloud Support Engineer, what is ideal salary for this position.

like

I have an interview coming up for internal audit manager. Currently in external audit. When asked about my experience in ERM - what would you say Is transferable skills that I can leverage in my answer?

like

Hello hive mind. I am currently interviewing with three agencies. Pretty far along with two of them. One of the positions is a Jr. copywriter position while the other two are just for a copywriter. How important would it be to not have the “Jr” before the title? Personally, I don’t care about the title, but wonder about future employer’s?

like

Hi Fishes, I joined LTI on 21st Nov as Specialist- Product Engineering. While HR discussion, hr told me that this for LTI product FOSFOR. After joining one person gave me assignment on java+react js, which I completed and shown to them. Now they said your RM will get you a project.. Is it that now they are not considering me for products? In iprofile it shows project name as ABAS but manager name as RM name. Can someone help me?

like

First Accenture interview tomorrow.

Can any current Accenture employer please share how they’d answer “Why Accenture?”

I want to incorporate any regularly used internal mantras, verbiage, or vernacular into my answer.

ie: “emphasis on creating value and shared success for clients”, innovators /innovative

Thank you in advance!

like

Has anyone here renegotiated their salary after a short time being in a role? I accepted a position and I like what I do but I realize that the workload requires a lot to see success and I feel a bit burned out already with my 40 hours/week and occasional extra 30 minutes to an hour a day.

I am stuck between putting in my time and showing my value and asking for an increase to validate doing so to avoid job hopping after a year or so.

like

Is investment accounting a good career path? Looking for any insight to the role, career progression, exit ops, etc. I got the opportunity to work at a very well known wealth asset management company as an investment accountant. I do enjoy finance as well. Pay is very good so I’m wondering if I should take the opportunity?

like

Has anyone ever asked to renegotiate their salary after starting a job? I’m 2 months into my new job and I have far more responsibilities than what I was told. It’s a lot different than what was relayed in the posting and during the interviews. Additionally, they hired my counter part in as a senior manager which is at least $30k more than what I make. My peer has more experience so I expect that but I feel that I should be paid more, however I don’t want to leave a bad impression… any advice?

like

Hi Fishes,
Please suggest a good project for java and spring boot developer in ibm ..Am looking for good tech stack and WLB

like

Question for agency PPC experts. Who is responsible for your client's monthly paid ads budget? The PPC expert employee or someone else in the company keeps track of the budgets to not overspend?

More Posts

Boston vs NYC?

like

What is the health insurance policy of atos India...
Can we add parents in dependents as well?
From which date health insurance starts after joining.

What's the best single site for business of healthcare news, now and in general?

like

I’m a simple guy. I see Mc🐝. I upvote.

like

That Friday feeling

Post Photo
like

I selected new tax regime in the company 'xyz' portal for April 2021-March 2022. I left this company in jan 2022 and tax of 16k got deducted from F&F settlement.

I have investment in EPF and submitted the rent receipts to the company for tax exception for HRA. But in F&F, based on new regime tax deducted.

During filing ITR for assessment year 2022-2023, can I file by selecting old regime and get this 16k return?

like

How are you able to do heavy exercises after work? My body heats up and my sleep suffers. How do you work the next day?

like

Do schools that you graduated from ( undergrad) still help ( maybe get that interview).

like

I feel like I'm at my wits end. I teach self-contained classes and according to the ISBE website my classes shouldn't be more than 8 students unless I have an aide - then it can be 10. I have no aide and most of my classes are around 14 kids. Some with behavior plans that are only out of our behavior room setting for my class... Is anybody else out there going through illegal class sizes for self-contained? How are you dealing? Maybe a vent session is in order.

like

Hello All, my joining date needs to be extended by 5 days in JPMC and HR said in call that no revised offer letter based on new joining date will be issued and new joining date confirmation will be somewhat communicated prior to 3 days of onboarding.
However he mentioned he will reply back with a confirmation email on top of the email which I have sent requesting for revised joining date.
Do you see any risk of offer cancellation/revocation here?

like

Thoughts on the corporate strategy team at Visa? Trying to learn more about the regional vs global teams, salary (US btw), career progression etc. Thanks!

like
like
likefunny

Hi Guys,

I have offers from Amadeus Labs, and Powerschool similar roles, same package. Any recommendations based on work culture, growth, salary hike?
Thanks in advance.

like

Public finance exit opps?

Anyone up for a virtual summer time meal this weekend?

like

Made it to the on-site round for a Sales S&O interview. However, both of the interviewers are Managing Directors of Sales. I thought they would be other S&O managers. How would this affect interview questions (e.g would GCA case studies be sales focused?) how can I best prepare for this given a lack of a sales background.

like

By when hcl will release the Compansation letters for hike 21-22year?

Additional Posts in Data & Analytics Consultants

Currently in consulting where I get to do data visualizations sometimes but not always, have an opportunity to shift to a data analytics focused role. Struggling to decide as I am not fully sure if I would be competent in/happy with daily data work. Advice, thoughts? 😣 I just never find what I like…

like

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

like

What is the best way to handle group financial consolidation in a multinational company?

like

Single book recommendation for user research?

Goal is interview prep. Ideally focused on applications in tech.

like

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

Hi! Does anyone know what kind of knowledge is needed to crack the Data Scientist interview at Google?

I'm currently working in Marketing Analytics (primarily using SQL and a bit of pyspark). Apart from mastering SQL, I wanted to know from people working at Google what does it take to get there as a Data Scientist? (I'm very interested in Strategy Ops)

I plan to another 6-8 months in preparation and upskilling myself before I even apply.
Any help and guidance is appreciated! Thanks :)

like

Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

Post Photo
like

Any cyber security folks here? or those interested in systems engineering? Potential role with TC 120-180, awesome team and wlb, at least compared to consulting.

like

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

like

When industries refer to business intelligence engineers, are they looking at a senior level or entry level? Some of these job descriptions seem rather outlandish in terms of years of experience required like 5+

like

Anybody interviewed for a data engineer role for Facebook? I have a SQL and Python coding interview next, any idea on what to expect?

like

Big 4 Data Scientists, how did you exit to big tech firms? I’ve been unlucky with online applications and even referrals. I think it might be my resume or how I present myself. Can any free birds please give guidance?

like

Has anyone else begun to resent data science?

like
like

Coming to the realization that consulting is not for me (tech person) feeling angry that salaries at D will never be on pair with FANG and that leadership is not tech focused. For example you could be a soul contributor at fang making 240k and people at Deloitte wait 10+ years to earn that as Senior Managers because they need to climb the corporate ladder. It seems super clear cut to me now, if you want to make money in tech don’t join consulting firms. Am I wrong?

like

Mεntal mαth in iηtervieωs. Thoughts, tips, rants, grievances?

like

1) Hypothetically if you were looking to sabotage a colleague, can you code an excel document to throw off their numbers or calculations, (if you send them that document and they download it for use)?

like

MBB data science expert role (i.e., mostly identical progression as generalists but less up or out pressure) or third (?) tier tech companies (DataRobot, C3, etc.)?

Assume starting TC is same at both or 10% more at the tech companies. That's the figure they're roughly giving me during interviews. Also coming from Deloitte.

like

I am currently working mostly in Data Analytics, but I want to transition into Data Engineering. I've applied to a couple Data engineer positions but it seems I don't have the qualifications for them. Should I maybe look for Jr. Data Engineer positions to get experience and try to move up from there? If so anybody know of any Jr. Data Engineer positions available?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal