I have an incoming interview for a bizops role and they will test sql, what should I prepare?
I only know very basic sql and they will have a sql case study. Does anyone have an example or some material that I can study for a few days?

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

It’s going to be difficult if you’re just a novice in it and not something you can study up on in a rush. At Amazon my test involved everything from basic syntax to complex queries and sub queries (case and joins).

like

Will try

like

Cram sql questions on hackerrank / leetcode type sites

Related Posts

What CTC I can expect for Senior Test Engineer ( Automation ) role in BNP Paribas CIB
CCTC - 8
Experience - 5+ Years
Any suggestions would be helpful, also help with WLB , company policies and yearly hikes

like

Joined in Oct for SAP functional. Now one manager who interviewed me reached out that there is a training material developer project which will start on 20 nov for Oracle timeline is 2 months only and SAP projects are in pipeline there was one coming but no guarantee if its final and if it has to come it will be in this month because in dec new projects do not onboard. I have worked on oracle in the past but now am fully into SAP. Should I take this project or wait until Jan for SAP project?

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?

While I am in bench, can I apply for a role through success factor or do i need to check with my counsellor?

like

Hi fishes,
How's the interview process in Infosys for data analytics role? How I can prepare myself for that? And, how much I can ask considering my YOE is 2 years and current profile devops.

like

Did anyone gave an interview in Google for SAP ABAP profile, need some inputs?
TIA.

like

Would Middle East offices still hire many people this year or sort of at a hiring freeze? (Think post-mba level)

like

Hello, I’m currently looking for a non clinical position in the Charlotte area, more in the public health field. Does anyone have any referrals or info on any jobs?

I had the first round with a consulting firm and it takes them more than a month to arrange the final round and the recruiter is not being responsive. Is that normal?

like

Delta Air Lines - Does anyone have insight to applying for a job at Delta Airlines? It’s my dream to work there and I apply regularly. Any referral opportunities? I’m interested in Information Technology, Project Management, Analyst, etc.

like

I had a job interview for a role that I really want. The hiring manager scheduled me for an interview and did not show up. Emailed me an hour later stating that he got super busy and couldn’t attend, and would like to reschedule. This is a major red flag, but I can’t help but feel that I am missing out since this role pays 50% over what I currently make. Should I let the recruiter know? What’s your take on this?

like

Had a couple interviews today for a position - what is the etiquette on follow-up thank-you / emails? I kind of feel like they're outdated. Contd...

like

Currently a MC at Accenture UK. 4 YoE including BA work, data analysis, change management, process improvement, tech implementations. Looking for a new role. Either Sr Consultant or exit into industry. Please do DM if you know of anything that may be of interest :)

like
like

1st yr at a nyc v50 firm doing general transactional work. I know the lateral market for transactional lawyers is hot but not as hot for juniors. I just want a change of scenery because my current firm is bleeding good associates / not giving great training imo / and just seems small. Would lateralling this early feasible? Would it look bad on my resume?

like

Hey folks

How is the client interview process at
IBM ? What kind of questions are asked? Is it too much deep and conceptual based?

Anyone here who can refer my friend for HR Executive role?. She is an MBA Graduate In HR and having 2 years Recruitment experience. Any opportunities for her?

like

Any companies still hiring MBA interns this summer? My friend at Booth had a summer consulting internship that just got cancelled and is looking for other places to apply ASAP.

like

Hello sharks, which band and role will be offered in Wipro for 3.5 YOE in iT, relevant 2.7 in devops
Would they offer project engineer with b1 band or associate Project Engineer with A1 band

like

More Posts

If you join pwc with an approved I140, do they start the green card transfer (perm, i140) immediately ? I was told by recruiter it will start immediately after H1 transfer . I Wanted to know how true this is if anyone been through this

like
like

We are all about to have a full week off for July 4th. Are we still gonna stick to the routine or take the week off?

likefunny

How hard is it to get into an investment bank for risk? Doing market risk related work (FRM)? And what kind of salary would you be looking at from entry to associate (senior) level ?

like

WELL DONE BAKU

like

What are the pros and cons of switching from audit to advisory (any area of advisory)? Currently in the B4 and realizing I do not see myself staying in audit past my senior promo. Would much rather be creating value and ideas to improve and solve client issues

like

Hello fishes, what should be the right salary range for 9.5 yoe in development. Technology is Python and Java. Amazon Newco Larsen & Toubro Infotech IBM Tech Mahindra

like
like

What credit card to you recommend pairing well with chase sapphire preferred for maximizing redemption? Pretty new to points and def don’t know a lot! I’m considering one of the Marriott cards bc we love Marriott or an Amex one! Any ideas appreciated 🤗 TIA!!

like

Any advice on broaching the subject of working on Sundays as a committed Christian?

like

Looking to make a jump. SVP/EVP media agency/client side. 20+ years experience in planning, buying, partnerships, content. NYC or North Jersey
Know any client side recruiters or good agencies looking?

What’s so compelling about the sales side that makes agency people move?

I don't want to ask the Mck recruiter more questions. Can someone explain the differences in the Profit Sharing Retirement Plan and the Money Purchase Pension Plan? Does Mck contribute to both?

Hello Fishes,
I got an opportunity from NTT Data BPO.
I am currently being hired for nightshift. Are there any chances for getting day shift or mid shift?
Or are there any chances to get a change in shift after getting on boarded?
Will it be okay to discuss this with HR?
Because during interview I said yes to Night Shifts.

anyone who moved to UK without a last name on passport?

like

Hello all. LPN for approx 6 years and I really want to move out of state. Currently residing in Allentown Pa and working in Easton Pa. I really want to go where the air doesn't sting my face in the winter .lol. Any one from the Florida or south Carolina area that can tell me what the salary is like ?

like

I’ve seen a very large range of income for general dentists. What is your income or expected/average income for dentists working 35hrs a week as contractor or associate in the city/ suburbs?

like

I wish admin utilized Tier 1 supports with teachers. Smiles, appreciations and acknowledging ones efforts would do a great deal to boost morale and climate. I just don’t understand what that is so hard to do.

like

Hi Fishes, Can anyone throw a light about Genpact Pharma/lifesciences analytics practice in India-Bangalore. Considering for a potential opportunity, I have 9 years exp.
- How is the culture, wlb, and growth curve?
- About year on year hikes
- leadership team focus on mid tier's growth.
Genpact Genpact Headstrong

Accenture Deloitte Axtria IQVIA ZS Associates

Additional Posts in Consulting Exit Opportunities

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

like

Thoughts on Riveron consulting?

like

Is it possible to get a FAANG interview without a referral? Especially for east coast positions.

like

Anyone here from Google specifically Google Cloud. Need to discuss about life and culture. Additionally if you are willing to refer me for a role that I see and am interested in.

funnylike

Total compensation / compensation break down estimate for PE megafund ops role w/ 3+ years of experience? Sounds like base they’re looking at is ~$120k, not sure on bonus. I’ll be over that by a bit with my promotion this year. Not sure if I’m getting lowballed, does anybody know industry standard?

like

what kind of roles at FAANG have you all exited to from management consulting?

like

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

like

What are some of the best questions you’ve asked/been asked during an interview?

like

Does studying for top consulting firms’ case interviews help in any way for interviews with other firms (e.g., FAANG case interviews) ?

like

Senior Manager Retail at Apple anyone?
Wondering what a SM would do in retail, by exiting from consulting.
Got interview next week.

likehelpful

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

like

I’m rapidly coming to a crossroads and having a hard time evaluating what I want next. I’m leaving consulting no matter what but my opps are wildly different and perspectives are appreciated.

1: go client side - super known and safe and good, but continues status quo
2: go baby start up - been helping out a small group who has some traction on funding, could be ready to go legit
3: try a 3rd party - my industry is hot right now, I’m talking with Salesforce and a few other big players

Continued

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

Just got laid off. What are the top skills I should plan to learn on the side while recruiting? Senior Associate looking for strategy and ops roles, no industry preference

like

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

like

Interviewed for dreamy job in dream city last week. Got a ton of buy signs from everyone I met with, especially CEO & CTO. HR said they would reach out early this week but I haven’t heard back yet

Can someone please explain the hype about product management at FAANG?

like

33 year old with MBA thinking about a career change from financial services consultant to certified financial planner. Any advice?

likesmart

I’m interested in the fashion world (Tory Burch, Chanel, Coach etc) but I dont have contacts there. Does anyone have connections in the fashion world I could talk to? Coming from HIA/ big pharma exp.

How can I best leverage my Deloitte experience to secure an offer from another employer? What advantages does Deloitte experience provide a candidate that I can emphasize?

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