Have a live SQL interview tomorrow... 2 questions, at least one of which will use window functions, and one of which will contain an operation I "likely do not know how to do". Any tips for this kind of interview?

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

Curious about your plan to deliver in this role (without SQL knowledge) should you manage to fake and secure an offer?

like

Good luck 🍀

I had SQL zoom interview, I had quieres I’d written on the side so I can refer to them during the interview but I also hardly use SQL, hope that helps.

Make some cheat sheets in advance and have them flat on your desk, open on your screen or on post-it notes on your monitor.

Hi

Fake it till you make it

How’d it go?

Related Posts

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

McKinsey & Company Any advice to help prepare for data science analyst role at top consulting firms (McKinsey & Company EY Boston Consulting Group etc)? Any materials, open source platform recommended to take on freelance data science project? When should I start actively looking and applying? I am a new grad who is working in tech as a marketing analyst I’m looking to pivot to marketing& sales data science consulting next year. Would like someone with similar backgrounds offer some practical tips.

like

Hi everyone Google ,

I am facing interview trouble.
1. First round of interview has done
2. 2nd was scheduled on 1 july but interviewer did not join. After a few mails to hr and recruitment team one hr replied that they will reschedule it, and asked me for possible dates.

Since then i am waiting for the interview schedule as all of my given dates have been passed. I don't know how to deal with it as I don't want to miss the opportunity.

like

Does Google do case interviews during the on site for Program Managers?

Has anyone been fired? How’d you bounce back? How did you approach it when applying for new jobs? I’m legitimately worried I’ll be fired and could use some advice.

like

After HR interview, I agreed on 10L fixed pay for a Sr Analyst role. But they increased upto 11.8 in offerletter. With variable pay, it amounts to 136% hike. Does this happen usually??? YOE: 3.9

Applied for a job at Apple but now the job listing is unavailable and I can’t even view my application on the site anymore.. its greyed out… is that a bad sign?

like

I just graduated from a nontarget in Dec 2020 & am currently interning at PwC before I go back to do my Masters. My initial plan was to accept my full time offer and slowly work my way into IB.

I see postings right now for FT IB analyst programs. Should I even try applying online?

Ik recruiters don’t really read cover letters, but I learned about banking rlly late into college. i’m the daughter of blue collar workers who don’t speak English so I never really knew what jobs were “prestigious”

like

I have a technical interview with Google Software Engineering team. Anyone know what kind of questions they will ask? What are the best Google offices in the US or Canafa? are they flexible with remote work?

like

Hi Everyone ,
I have passed the technical interview in Capgemini and HR has called for Salry negotiation , after that HR said that offer letter is in process.
Now HR called and was asking aren't you interested in the offer , HR said that client tried to contact you but you werent responding.
But I didnt receive any call from anyone ..
What is this client call ?
Is the process normal ?
Like I have heard the client calls would be after joining the organization .
Please enlighten me.
Thank you.

like

Can I use ey laptop to attend interview ?

like

LinkedIn always tells me to message the recruiter when I apply for a job. Is this ok/normal to do?

like

Any recs on how to land an in house gig? I’m applying to things online with no bite

like

Hi All,
It’s been a week since I last heard from pwc in regards to my interview. I gave them my availability for next week but I’m on holiday and few of the days won’t be at home. Shall I follow up with recruiter and make them aware that I’m still waiting for something to be scheduled. Really don’t want to keep waiting…

like

Hey can anyone guide me for Technical Round 2 of BDO Rise, it's 15 minute video meet, atleast if you can tell me what should I expect from it, it will be a relief.

likehelpful

Has anyone recently interviewing with Boeing or have joined recently? Please comment need to know about the interview process.

How long they take after project manager round?

(5 yrs Full stack)

like

Does anyone know anyone who was casted for the show/spin-off? Looking for casting @interview tips. Thanks.

Hey Amazon @ employees!
Just passed my phone screen for Escalation Engineer. Any tips for the technical interview?

like
like

Once I attend an interview in Infosys and got offer and rejected it ...when I can apply again? 6months or 9 months

like

More Posts

lol I just ran into my ex at an alumni event after a year of not seeing her. She’s on the board of the alumni association chapter. Do I just have to stop going to events, or what’s the move here?

Help pls.

like

Given that a lot of ZSers ate joining Novartis, do you think that we can have a whatsapp group for the same? Thoughts?

like

Hi, My current CTC in Accenture is 14.5LPA and Total years of experience is 9yrs. Thinking about job change. How much CTC I should ask for the next company for 9yrs of experience.

like

Anyone at MBB looking to make a referral?

funnylike

Any brand/model recommendations for stylish and functional thermos bottles?

like

Totally agree 😁

Post Photo
funnylike

Hi Guys
I will be joining IBM next week in Bangalore ( physical onboarding ) and my hometown is in West bengal , My father is having health problems , mother won't be able to handle everything and no such person we can rely on . Also I am getting married in January . Hence If i stay in Bangalore there will be no one to take responsibility for my marriage prep also . If i convey to my ibm manager will they consider for 4months of WFH?Any documents may have to show?
Need your suggestion please

like

What are you looking forward to during the holidays?

like

I have interest in product management. I am looking for an internship in PM.
1) What to look in a company to intern at?
2) Startup vs Big Companies?

Seems like hiring has slowed down but i feel we are in for another bout of great resignations due to companies calling it's employees back now and employees finding ways to continue WFH. The ones who get lucky continue WFH while not so lucky ones will start switching and startups and other mid level companies cashing in on the talent. Looks like it's the lull before the storm.

like

Working in Amazon as Process Lead (L4) - over all 5 YOE, looking for opportunities in other companies related to operations lead or Business Analysis(have okayish knowledge in SQL and Excel, won't mind learning other tools as well)

like
like

From reading a number of books and listening to a number of podcasts about starting a business, one underlying factor they all share is to have deep passion for what you do. How do you know what your passion is? I mean I think a lot about golf but i don’t think that’s a passion. It’s my hobby. I think most people just know.

like

What are the hours like for a program manager in the Bay Area?

like

Hey Mates,

There are talks of focusing on talent retention & offering competitive pay in meetings by Higher Leadership so
Is there any salary correction actually happening for current employees or some salary equity policy being made?

like

Anyone know much about G4 visas? Do they fall into a different pool for GC with potentially faster process than through employer sponsored GC? Indian Nationality

like

I recently started GC with EY law. I haven’t seen any case process since late august and there are a few items past due. The lawyers are not responding to my emails, does anyone know how to get a better sense of case progress and possibly to get the lawyers to speed up the process? Thanks! EY

like

Best place to find paid online focus groups/market research studies?

like

Hi fishes,

I received an offer from Amazon and wanted to know the average hike i can expect

like

I’m doing a cs degree rn & I want to be an appsec engineer but I’m not sure which is a better path for growth: Path A: SMART scholarship which involves a 4 year gov commitment after college grad. But they offer a stipend and full cost of college (I already covered cost of college)
Plan B: Or should I just go for a private sector job straight out of college and hope to get internships while in university.

like

Additional Posts in Consulting Exit Opportunities

What exits are available for IT Strategy & Planning? Is this a good career path?

like

What’s the best approach to negotiate a higher base salary? Should I mention competing offers, what my earning potential is in the next ~2 months in my current role - or both?

like

Ex-consultant now in marketing. Used to be an avid follower here and got great insights on companies when trying to exit consulting so thought I’d try here for advice. Outside of FAANG, what are good large CA-based tech companies that provide good pay, WLB, and culture? DD has great people and WLB, but pay is low and you’re not given the tools and resources to succeed + truly make an impact. Google and Apple are ideal but need backups. Like is Salesforce still good? A company along those lines.

like

What happens when you leave 1 month before the 3 year mark? Do you forfeit pension and partial 401k vesting?

like

Had an interview where they asked about salary. They asked what salary I was expecting and said that they pay 6 figure salary and I responded that I’d be happy with 6 figure salary. Would that mean they won’t offer me more than 100k?

like

Anyone have any experience of how technical an interview with Baringa Technology Transformation is? I have a delivery background, and specifically extensive experience in Testing and Agile Delivery but I would not say I am a deeply technical person so I'm a bit concerned about what to expect

like

Can't really share this with anyone else, so thank you fellow fish for indulging. 3 years in, finally at a point where I can comfortably work 40 hours a week the last quarter+, and still be a trusted team member and major contributor. Normal tasks and collaborations now take me a fraction of the time compared to my first couple years / others on the team. 6 YOE and my TC has also gone up a lot from low 200s last year to high 200s this year. Hope to keep this optimal mix of WLB & progression 🙏

like

Should you cite stats in an assessment or does that make it read too much like an academic paper?

like

Who are the top PE/VC headhunters in SG?
How common is it to move from MBB to PE/VC in SE Asia?

like

Are corporate finance or pricing dead end ops?

like

MBB AP about to exit to non-FAANG tech. Would you expect a signing bonus and/or pre-determined severance pay if things don't work out with the new company? Anything else that people have negotiated during their exit? I'd be leaving a large amount of bonus on the table to leave before the end of the year.

like

Having a baby and looking for consulting exit opps. I’ve been in strategy consulting for two years and recently promoted to manager. All projects were in tech or LS. Prior to consulting I have 10 yrs of Pharma experience with a MS in Engineering (non-CS) and data science. Fluent in Python, Ruby and Java but never coded professionally. Spent several years in process engineering and then project management. Interested in tech or digital health. Any advice on companies, roles and levels?

like

I exited to FAANG from big4 and part of me is seriously thinking about getting an mba to go to mbb. Does that make any sense?

like

Has anyone successfully landed a job in Europe as an American Citizen? I’m really looking into moving to London/Amsterdam or Berlin.

like

Which would you rather? Internal at MBB or client-facing at Big 4/ACN?

like

Thoughts on career changing and joining a headhunting/executive recruitment firm? I feel like it won't be super hard for me to start building a book of business with my current network. Anyone with experience?

like

Has anyone used Pathrise to help find exit opps? Would love to hear any experiences if folks have

like

Anyone know anything about Samsara it is an IoT start up

like

Do you negotiate before or after the offer letter?

like

Is “BizOps” an overly glorified exit opp?

I hear about it so much on this bowl and did some googling, pretty much can’t find anything negative. What am I missing?

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