Hey y'all I have an initial call with Facebook within for the Business Planning & Operations Associate role. Does anybody have any insight into the process? Any SQL required?

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

The process is initial screening > first round > loop interviews (usually 3-4) > final round. The recruiter should be able to share the skills being assessed at each stage.

like

Depends on the BP&O teams. Some of the sales and enablement teams don’t require SQL. My team interview is pretty SQL heavy.

like

I'll just guess that there will be sql. Everything is in stone sort of database. I don't see how you could get by without it =]

like

I'm in biz ops and planning at another FAANG and no SQL. But I'm pretty sure to get to the next level up, I will need SQL.

like

How difficult is sql? How did you guys learn it? Any great resources you guys used to prep?

Super easy:

# pull some data
Select
Colname
From table

# sum some data
Select
Colname1,
Sum(colname2) as colname2_sum
From table
Group by colname1

# filter abd sum some data
Select
Colname1,
Sum(colname2) as colname2_sum
From table
Where colname3 = "active"
Group by colname1

That's probably 50% of what you need to know. Learn a few other things like joins, having, CTEs, etc and you are in ok shape as an analyst.

w3 schools have ok tutorials and probably most of what you need to know to get started. https://www.w3schools.com/sql/default.asp

like

What does the day to day of this role entail?

It'll depend what team the role supports.

Related Posts

do amazon HR reply to our email post interview?
mailed to enquire about the interview status after 6 days

like
like

Looking for lead network infrastructure and operations openings.
Yoe- 11
Cctc - 12.4lpa

like

Hi Fishes, Is anyone working as QA in Tech Mahindra for EY Client? Would like to know about project and wlb. Tech Mahindra

like

Anyone have advice for advancing in your current role? My co-worker was hired in at manager level but somehow “proved” he was actually doing director level work and got a title promotion and salary increase in less than a year. I also went above and beyond my job as well (covering for him for a month while he was away on paternity leave) while taking on other projects outside of my job title and got zip—no raise or recognition. Any advice would be appreciated!

like

Hi folks !
BCG is hiring for various consulting positions : SA1/SA2, Consultant, PL etc.
Please DM me if and only if you meet the following requirements :
1. You have an MBA degree from a top school (i.e. BCG comes to your campus for hiring SAs)
2. You have atleast 1 year of experience (in consulting preferably)

like

Hi
Can anyone help me how should i explain my project on which i worked in my current company to the interviewer.would be very helpful if someone can help with the basic format from start to end or else can give example of their own project.

Thanks in advance

like

Upcoming FAANG interview, what’s the best site for affordable fit interview coaches? Exponent? Only familiar with the ones for MBB coaches. TIA!

like

Need referral for one of my Friends for Salesforce developer profile..has done Salesforce certifications..and currently working as xamarin developer for 2 years.. immediate joiner ..Actively looking for job..

Post Photo
like

October Job Thread! 🍂

Drop any relevant openings or opportunities that you know of in the comments below!

Help another user 🤝

like

I’m currently at a FAANG and I’m kinda bored. I know most of you are going the other way around but I kinda miss being able to work on stuff that has an impact and the rush of consulting. Can anyone at MBB tell me how it is for technical work especially Quantum Black? I feel like MBB has cool clients I can do Data Analysis for.

like

Hi everyone,
Hope you are doing well.

I am looking for an entry level role ( Tier 1 MBA college graduate) for Investment banking or PE roles. Please let me know if there is any relevant opportunity.
Thank you

like

Hi All,

Need your guidance on this please.. I am working as a business analyst (functional) and Overall work ex of 8yrs.
What position and CTC can i expect in Accenture ?

Hello
Anyone hiring for Jr. Product designers?
I'm really motivated and excited to my design skills + UX skills I honed from OCAD university Toronto.
I have 7 years of exp. In design and 1.5 years in UX. Currently Freelancing for a bank.

Thank you in advance for reading this.

I have an IT M&A interview coming up next month. Would someone be kind enough to mock interview/prep?

like

Hi PPL, I have cleared 3technical rounds in Microsoft. Only one final round is there for sde role. Will it be hard? How to get prepared for this? They said it will be techno-managerial round. But some tips please. Microsoft

like

What’s the salary like for a valuation associate position at a PE fund like Apollo? If the TC is 120k+ I’ll quit pwc right now

likehelpful

What are the various research companies like ISG, Forrester and Everest which are hiring currently in India? Would be of great help if someone can give some direction to this!

More Posts

Any want want to move to the Bay Area for a Media Comms role? 2-4 yrs exp. $75k. Plus relo. Healthcare brand . (Not pharma). Lovely warm agency. Honest

like

What are different innovative ways to contribute in portfolio through strategic initiatives, generating business through new projects ? Any ideas and initiatives appreciated!

like

Hello Hexawarians,
Can you please help me getting 11 likes to activate DM feature?

like

How is life like at "The Many"?

like

Got my first job working retail! I'm so excited. I'm only 18 and I know it's not that much but I'm happy that I get to earn my very own money.

like

Anyone received any notification of joining whoever is joining in July ? Did u book tickets if u r relocating and will the accommodation be separate provided by the company or included in relocation expense and we have to book??

like

What if we don't work on notice period.I am going to put my resign within next 20days and madeup my mind that i won't work more than 8 hrs

like

KPMG management consulting or Accenture management consulting (ACN)??? KPMG Accenture

like

Is it a right time to move to Poland, when inflation is at all time high?

like

LinkedIn meme, but you’ll appreciate

Post Photo
funnylike

Appreciation post.

Just started at
Boston Consulting Group earlier this month. So I would like to thank the fishes here for the information, tips, and insights :)

like

PwC Toronto assurance: being offered a job as a transfer from the US. I’ll be transferring as a senior associate 1 (aka this is my promo year). I’ll be either tier 1 or 2 since I’m an easy promote here in New York. I was offered 61k CAD assuming I’m tier 3. They said they might adjust it if my rating comes in higher. What should I expect if I were either tier 1 or 2? Trying to minimize the salary reduction…

like

How does your agency handle promotions? Do they promote based on merit or time in role?

like

Need 11 likes to unlock dm

like

I am currently working as an ETL developer. It involves GUI and some SQL. I want to know how to switch to data engineering. I am planning to apply for the job next year where. So, I will be having 1 year of ETL experience at that time.
What should I learn now as per Indian market. Specific tools which will have good future growth? I am good in dsa, mysql, python, programming concepts, and theoretical CS.

like

In New Jersey, can you get half of the realtor fee back if you represent yourself when buying a house? That is the case in some states.

like

Consulting Baby Shower question - what was the best baby shower gift you ever received?

Is it difficult to switch jobs between different type of funds ? For example from Big4 to Hedge fund then to a Private equity fund ? Do people specialize in one type of fund when they become an Assistant controller or else ? Thanks

like

Additional Posts in Consulting Exit Opportunities

Best books about product management for a good exit to industry? I already have an MBA and PMP but looking for a refreshed perspective since it’s been years since my formal education.

Currently reading “Product Managements Sacred Seven” but it’s geared toward the startup world. I am in healthcare and not looking for a startup role. TIA!!!

like

Anyone here transition from consulting to software engineering? How much do companies and recruiters weigh work experience vs side projects/ technical skills in resume screenings?

like

When looking for a new job is salary your main driver in your decision process? What other factors do you take into consideration?

like

Exiting a small firm to pursue software development roles. I have full-stack experience and would appreciate any leads on entry-level positions in the tech space - front-end preferred.

like

Does anyone know of any contract roles in the New Jersey or nyc area?

KPMG fish how’s the firm doing specifically in Cyber? Got an offer for equivalent title to current (SC/SA) at 40% pay bump but worried the memes are true.

like

I am passionate about improving education, mainly by exploring the psychology/economic drivers that influence decision making in school budgeting, staffing, and performance evaluation.

Are there jobs for this or any other jobs that promote core foundational skills for this role?

funny

What would be your reaction if you got an offer from a startup but there was no equity involved in it?

like

Anyone have experience with Samsung NEXT? Looking at a strategy role but wanted to get take on culture, hours, pay etc

like

Planning to give 2 weeks notice. What should I expect? Could they ask for less?

like

Any crazy reaction from partners when you announced your resignation?
I got chewed on by one in a call 🥲 (it proves i made the right choice)

likehelpful

Is it possible to have two full-time consulting jobs eg be on leave for one job and work FT for another?

like

Has anyone here interviewed with or transitioned to Spotify? How is the culture?

like

Anyone willing to give a referral to Microsoft?

like

Do most people generally know how to solve take home cases? Or is it a research exercise? I have no experience with the q they are asking so feeling incompetent

like

Preparing for McKinsey round 1. Doing well on practice cases in general, but fumbling with some of the more difficult math concepts like probability trees, etc. Any tips in general? Getting nervous

Worth taking an offer for ~160k in sales strategy for a boring HR tech company? At ~120k now I’m tech consulting.

Sales strategy is interesting but the mission of HR Tech is meh.

Thoughts?

like

Have been over 100% utilized YTD until rolling off 3 weeks ago. My practice's leads in the pipeline keep evaporating and now the closest possible engagement is at least 2-3 weeks out. (Cont)

Got a verbal offer from Microsoft on Friday. Super excited but was curious the timeline from verbal to official offer is. Can anyone provide some insight please?

likehelpful

Anyone know of anyone who went to Carfax? Seems like their day to day cannot be stressful at all

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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