Hi! Interviewing for analytics manager at FB, sql coderpad round included. Any tips on prep? Leetcode ?

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

Know how to manipulate dates really well. Leetcode is the way to go. But honestly, the sql isn't as important as the metric questions. So unless you have never used sql dont spend too much time on it. Good luck

likehelpful

Windows, indexing, and self-joins

like

Do you mind sharing your background ?

OP please post some questions asked! :)

Related Posts

How’s working at Charles Schwab? How much can you make as financial advisor, not owning a practice but for an office

Finally made it to a PM final round and absolutely bombed it. F*ck me

likefunny

Hello guys where we can practice javascript coding questions which are asked in online coding round of Various MNC like Nagarro, Amdocs etc.

like

How much Cardekho (Girnarsoft) can offer for 4 yoe NodeJs Developer?

like

I cleared the interview KPMG and they rolled out my offer but i m not able to access the portal and accept the offer as it navigates to job search page.Did anyone face the same problem if yes then please share the solution.

I actually have a question: husband had 4th (final) interview with company last Tuesday, emailed them follow up Wednesday, heard back Thursday, them saying that they will be in touch with him “next week with next steps”. Still haven’t heard anything back. Not sure what is going on…?

like

Hi all-my idea pool has officially run dry. Trying to explore new ways to market per diem
nursing. Besides, clinician spotlights, social posts, and video interviews, any other thoughts?

Hi there!

Can I get a referral or a job opportunity from your end?

Can I DM you with my resume?

(Please!)

like

What is the salary I can ask to CGI HR?
YOE: 4y 8m
Tech stack: Java Spring Boot Microservice

like

Hello Fishes,
Currently I am in an interview process with LTI Pune. YOE 8.5 Years, tech stack ETL, Data warehousing, Teradata. I am holding an offer of 23 fixed, what could be the best figure to ask from LTI ?
Larsen & Toubro Infotech
Thank you for your response.

What would be the max salary offered in LTI for 11.6 years of experience...current salary 20lpa

like
like

Hello Fishes, Infosys Consulting Infosys Could you please guide me on Infosys variables. I got Infosys offer with 20% variable. How much % we get of variable average??

like

Any one from EY Poland can tell me about salary range for consultant and senior consultant ?

Hi fishes,
Experience in finance of about 8.5 , got shortlisted into State street for a manager, and awaiting salary discussion.

Can some tell me what would state street offer best .
Current CTC 15.5

like

Is innovaccer is good company for staff data engineer roll for 9 years of experience.
Got offer from Cognizant with 25+1.5 vapay and also about get offer from innovaccer 27+2.5joining bonus. Please suggest which one choose.

like

Do you know of any good reads or videos that’s aren’t lengthy to prep and get through a program manager interview with FAANG? Some good tips, basic principles, good stakeholdermanagement methods, etc?

like

Hi Fishes,

What's the salary bracket for Manager in technology consulting in EY India.

Also would of great help if someone can highlight the responsibilities and WLB. Thanks

like

Hello Fishes, I recently got an offer from EY with Senior Con - 3 designation (band 4). Yoe is 7 years. (BE Tier 2+MBA Tier 1)
My mba batchmates who had got placed at
Deloitte and PwC 5 years back, where made Sen Con two years ago and are now at Manager position.
My question- Am i offered the correct designation according to my profile? when would I be made manager at EY India? Please provide your insight.
KPMG PwC India Big 4

does anyone know anything about experiences working at “Stampli”? I have an interview for an Account Executive position there!

uplifting

More Posts

SPY or VOO? Which S&P 500 ETF do you guys recommend?

like

Would you rather live in an old apartment with access to great community events, amenities, etc (The Village) or in nicer apartment but 0 community events and ok amenities (The Avery)? Single, 28 yo

like

Any idea what type of case study you get during the PwC DDV recruitment process? E.g a profitability case study, a synergy case study? What is the ultimate objective / question of the DDV case question if anyone has done it previously?

like

Is it reasonable to ask for three weeks before joining a new company? I was thinking a two week notice and a week vacation to take a breath. What do you think ?

like

Need likes to unlock DM, please help

like

Please meet Jaded Cat

Post Photo
likefunny

Best summer experience so far @ your agencies?

Signing off now, but if anyone has any questions feel free to reach out on twitter, or IG @3rdgeers

See you all Monday. Promise it’s going to be some next level shit! Don’t miss it.

likeuplifting

Typically when someone brings a unique experience or skill to the table they’re compensated for it. surgeons/technicians.
Can we bring this structure to the industry in regard to ethnicity/experience

like

How do you handle employee / work burn-out ? (Work + Life balance)


Shout out Walter & 100 roses from concrete!

like

Any ideas of stocks affected by COVID19 that still have a large upside?

likefunny

Anyone here from Houlihan Lokey London? Please DM me.

like

Turns out that Ellen DeGeneres' new show has been canceled by Warner. I didn't even know she had a new show, huh.

like

Is Hollywood out of creativity nowadays? Every film seems to be similar to a pre-existing one and don't even get me started on all the remakes.

like

I can't find a really interesting bowl here.

Does anyone know or be interested in an open-source bowl, for example?

Please suggest me good bowls 🙏

like

Hi all, I have a final round of interview at Meta for a PM position and the HR told me that I would be assigned an existing PM to help me prep better and to ask any questions about the next rounds. Unfortunately she has not assigned anyone yet after multiple follow ups and I have my interview on Monday. Could anyone guide me on what I should do? Should I be raising this during my interview?

like

Hey fellow designers,

Is anyone else facing the brunt of working in a service based company and trying to move to a startup product company being dragged down by the 90 days notice period.

I have had a couple of interviews with good startup product companies where the main issue is my 90 days of notice period. Most startups simply run away at the mention of 90 days NP.

Even established product companies shy away at this. Has anyone recently switched despite this long a notice period?

like

Read some posts that wipro is delaying joining by more than a month.

Anyone has any insider info on what is going on.

Is it a technical issue or it is being done purposefully

like

How much does a Canadian Risk Management certificate adds value when looking for Ethics , Risk and Compliance roles in the Pharma sector in Canada? Please note that this individual doesn’t have any North American degree

like

Additional Posts in Data & Analytics Consultants

Reading through some possible interview questions for FAANG. One of the ones I've seen on Glassdoor are to design a basic architecture structure for something like Netflix or Twitter or Spotify. I've been researching online using AWS or GCP (still learning all the moving parts of architecture). Any advice on how the setup would be? I'm assuming you'd start with some Load Balancers. For Netflix maybe have different different APIs for signing up vs scrolling through possible movies?

like

I'm currently a property accountant with an MBA in finance. I desire to earn more income considering my credentials and experience. I currently earn 93k and striving to get to 150 or even 200 to be able to live the way I want to live, pay for good schooling for my children, eat organic, travel etc. Even to buy a nice house in a great neighborhood is at lease a million. I'm looking for salary comparisons and recommendations to reach my financial goals

like

Does BCG/Bain hire H-1B visa holders? If so, could anyone kindly provide a referral? Currently a data & analytics senior consultant at big 4.
Would be great if any BCG/Bain 🐠 share their experience

like

What's everyone's thoughts on CDMP? Seems like it's growing in popularity.

like

Code for IBM bowl? I'm new here, thanks.

Has anyone worked with or created any psychometric models? I would appreciate any resources where I can learn about psychometric models

What is the one time management tip that you would give to your younger self?

Is a job as a Financial Analyst (Excel, Tableau, SQL) able to be leveraged into a more hardcore data analyst/scientist position?

FP&A experience

like

Has anyone done any data engineering bootcamps they would recommend ? I’m in nyc if that helps

like

How good are PwC and EY around advanced analytics compared to K Lighthouse and Deloitte A&C? General feeling at the latter two is they only compete with themselves and PwC and EY are a few yrs behind.

like

Has anyone completed a Springboard career track? If so, what are your thoughts?

like

Any sites you specifically recommend for behavioural and situational interview questions and answers? I know I can Google examples but looking for recommendations for sites that you actually found helpful. Interviewing for a regulatory analytics position. Thanks!

like

What do you see as a good senior exit pathway from data science consulting other than FAANG? Chief data officer? Chief data scientist? Etc

like

Worth switching from Senior Associate Lighthouse to Consultant at Deloitte A&C? Is lateral move a good move or should I look at SC roles only?

Currently SM in Deloitte leading data engineering and ML teams for commercial clients. Looking for exit ops to Amazon/ FAANGS and other cloud compnies. What type of roles i should target. I am comfortable with Program Management or client focussed delivery roles. I have been in architect roles but not doing hands on tech work for last couple of years as i manage large teams doing that. Since these companies are product heavy what type of role that Big4 SM generally transition to ,in these orgs.

like

Any recommendations for ramping up my SQL skills (for free ideally but willing to pay for a course if worth it). No experience but looking to strengthen my analytics skillset

Anyone here from Deloitte Analytics and cognitive/Applied AI practice?

Have a few questions, anyone willing to connect?

likehelpful

Can someone with a business major undergrad (information systems) become a data scientist? Took courses in Python, SQL, Tableau and currently use the at work and put models in production w/ sklearn

like