SQL interview for FANNG? Anyone do that before?

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

Things to know
Left vs right join
Inner vs outer join
Cross join
Buffer pool
Indexing
Correlated queries
Having vs where
Never interviewed for a sql role in faang but I am a big data consultant

like

What’s the second N?

like

It is FAANG not FANNG. The N is for Netflix. It isnt like Netscape is making a comeback suddenly

like

Nvidia

Also have an answer for a flat hierarchy self join sort of thing.

Might also be useful to know about window functions and aggregate functions

Related Posts

PwC I have a HR interview in PWC Yoe 2, Frontend UI I have already a offer of 12 (fixed) + variable components coming around 13-14 Can anyone please tell me how much ahould i ask? I was thinking of saying 16 and going 15 min (fixed)

like

Hi fishes! Next week I have the last interview with partner at Deloitte. What would you recommend - some tips? Consulting, value creation unit.

like

I have interviews coming up with BCG. Any BCG Platinion folks willing to discuss example case interview questions?

like

Had an intro chat / interview with HH canceled bc of “scheduling conflict”. They said they’d reschedule asap. Haven’t heard from them for 3 days. Should I wait, follow-up or set up another call? Am I reading too much into it?

like

Hi guys,

I switched 20 days back to Optum. I have 7 years of experience working as a full stack Engineer, who is passionate working on both front end and back end on latest technologies. But my project is working only on back end with 10 years old tech stack. There is no front end work at all. What should I do?
I don't like working here at all, but I am not sure whether moving out again in a month will give bad Impression on my resume. Hence please give me advice on this situation

like

Workday I’m a QA Automation Analyst with 2 yoe. I gave my tech interview for Workday and cleared it on Tuesday. I’m currently holding an offer of 15.1 from a bank. How much can I ask from workday?
Tech stack. - Selenium,Java,Jenkins,Salesforce automation.

like

When doing profitability calculation or NPV, do interviewers usually ask candidates to come up with their own estimates/assumptions for costs, both one-time and recurring?

Can you use excel during the interviews to do calculations? Figured if it would be virtual it would be easier to do so.

like

Are there any AWS recruiters on this bowl?

How much time does Naviga global take to send offer letter. My HR round was done on 3rd of September.

Hi fishes, I have recently attended an interview with Accenture India Accenture couple of days back and can see the candidature status is on hold after my 1st round of interview. Does this mean that they are waiting for others to complete their interview or am I rejected? If not ,how many days they tak appxm to make a decision. I tried reaching out to recruiter and as usual they are not lifting or responding to my messages.Has any one faced this situation with Accenture? Thanks in Advance!!

like

Anyone care to share their biggest case interview mistakes? Anything you'd do differently knowing what you know now?

like

How much time did hsbc will take to release offer letter after 2 rounds of technical discussion?

like

Every job application rejection is one job application closer to finding a job.

likeupliftinghelpfulsmart

Had an interview for an associate position at Citi. Interviewee was based in London and I’m in NYC. The only interview time that worked was 6am. I was barely functioning and feel like I truly messed up in my answers because I couldn’t not think clearly. I have another with the head of the division next week again at 6am (pre determined before this interview). It was also hard because the division’s core work is private enough that there was not much prep I could do beforehand. Tips?

Hello. Anyone get accepted into a part-time program in D.C. with gpa & LSAT below the school's median? I've taken the LSAT twice & plan on taking it again in October. I have all other parts of the law school application close to being finalized but the LSAT is the only thing preventing me from applying. Any insight or advice?

like

Hi,
Anyone has an idea how Cloud Engineer AI job is different from Cloud Migration Consultant - AI/ML job at Google.
I have an interview for Cloud Migration Consultant job.
Thanks

like

I got a offer from HCL.

I have given joining date of my previous company with a difference of 1 week and submitted joining form.

Will there be any issue in BGV.

I am worried about it.

Can anyone please suggest what I can do at this point.

like

More Posts

Has anyone transitioned from bedside/patient facing healthcare to clinical research? I am looking at making the switch and would appreciate any insight!

Looking to join a running club for LGBTQ folk or other agency folk. Is that a thing? NYC by the way.

Have you ever taken a career slow down? I am feeling burnt out from COVID and the incremental responsibilities thrown my way over the last 5+ years. I feel like my health has deteriorated. I like my company, but I want to do less. I don’t need to be a HR Director, CHRO, etc. With a career slowdown, I am prepared for a lower compensation and would want decent benefits. Any lessons learned or success stories about career slowdowns?

likehelpful

What are the main factors folks are considering as they make a decision? Solely ranking, money, just curious! Got into two T20 that are very different but see myself at both.

like

Are there actually tax cuts switching from home office in NYC to Hoboken?

like

I doubt this will ever happen, but after seeing the Aston Martin launch. I’d love to see a day where the likes of Porsche, Audi, Maserati, Lamborghini entered F1.

like

Anyone read Quit Like a Women, by Holly Whitaker? Reading now and it’s making me consider extending dry January to 6 months, maybe a yr, or ever again...curious to hear if anyone else has read.

like

I've lost all motivation in my job and have done maybe 40 hours of real work since the beginning of August. I've built up a good track record the past couple years, and am good at bullshitting so people have been giving me the benefit of the doubt, but know the party can't keep going forever.

like

What are good brands for young business people. I don't like Gucci and LV cause they are so mainstream. I am in the market for a new wallet and want something that is unique and nice (thinking Tom Ford or Mulberry)

like

Casual sexting makes a normal day spicy 🥵 🔥

likefunny

Hi All,

Anyone who got retained recently in LTI, please let me know, need some help.

Eagerly awaiting my Stanford rejection

like

My boss is asking me to “reconsider” the way I approach a client… I am in charge of this annoying corporate maintenance thing that we do for a client (I.e., making board of directors meeting to comply with some regulatory reporting required. I always end up missing deadlines. How would you reply?

like

Hello Guys,
Any idea how is the role for Program Manager Data Intelligence.
Is it SQL coding intensive ?

like

What are some tips or recommendations on where to start to become a product manager? Much appreciated

like

I'll stick around for the bonus but want to make my side hustle my main career next year.
The side hustle is Scentsy...

funnylike

Hi fishes

I am new to this app
Can anyone refer me in product based company
Thanks in advance 😊

like

Hey guys! Can we leave a company within 2 weeks of joining?

Additional Posts in Consulting Exit Opportunities

Which company would you rather exit to, Microsoft or Paypal?

like

Consulting to sales-ops - is a pay cut needed? Want to move to tech but don't want to do internal strategy.

3 YOE, all in consulting

like

McDonald's I am looking for a referral for a PMO role at McDonald's. Anyone on here have a contact or an in?

like

MBB or FAANG (Ops role)? Similar comp structure

Had anyone gone from consulting in to diplomacy/International organization like the UN/EU or similar?

like

Professional summary for a resume with 2 YOE - yay or nay? Mine sounds a bit cookie cutter but I’m wondering if I should leave it.

like

What are your experiences regarding the case interviews at google vs. mgmt consulting? (Differences in style and difficulty, tips, etc.?)

like

Interested in McKinsey implementation practice. Possible to speak with somebody with insight and opportunities in that

like

Have an interview with a growth stage startup, what should I wear for a virtual interview ?

like

Is it common to receive feedback after multiple interviews?

Got a rejection late last night after probably 3 hours of interviews and a take home assignment & presentation. They told me they wanted to consider me for other positions, but would like to know if there is anything actionable I can improve on for other companies.

This was for a unicorn tech/healthcare startup.

like

Interviewed with a tech firm for 3rd round on Wednesday. What do I email the recruiter tomorrow afternoon? Have yet to hear anything

like

Is there a limit to how many FAANG positions you can apply for in a month?

like

What are the exit opportunities for digital consulting if product management recruiting doesnt go well?

like

For those of you who left the Midwest for a FAANG company like Apple… was the move to CA worth it? Have an opportunity and it’s just really difficult wrapping my head around the cost and standard of living, being far from friends and family, etc.

like

Need some thoughts fellow fish. What are the best resources to learn about ins and outs of a technology startup? Also, what are the best ways to find app development talent to hire/ give equity etc?

like

Have an opportunity to interview for a sales role at Paycom, cloud based human capital software. Anyone have insight on these kinds of roles? Don’t know much about it but a friend referred

I would love to work on cloud security product management at google, Amazon or Microsoft as they are the major cloud providers currently. I am on identity management consulting and have experience with Azure cloud. I am trying to get in touch with product owners in those companies and understand the culture and what they look for in a product owner and how best to get your resume and interview notice and referral if possible. Help please 😊

like

How is Advisor Business Analyst at DXC? What designation in D will that compare to?

How long as a senior associate at EYP till Consultant? Have a ex colleague who moved over with 3 yoe and is now a senior associate

like

4YOE @Amazon & trying to lateral to a similar role @FAANG. Have my undergrad GPA (3.8/4) on resume from top 15 school but colleague says to take it off (looks silly). If it’s a good school & high GPA, why ever take it off your resume? Even if 10 YOE...can’t hurt?

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