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

like
like

What is salary range for AVP in Credit Suisse for 10.5 yrs ? Whats the minimum exp to ask for VP designation?

Does ZS provide MBA sponsorship? If yes, what's the criteria.

like

Anyone working in Cloud in Hexaware? How is the work culture and WLB?
Do they have good projects in cloud?

like

Hii Guys, Could anyone give me some clarity on the below point. I have cleared 2nd round of technical interview at Deloitte, but my candidature is still showing as interview in progress at Deloitte careers page. I had a discussion with HR on this and she told me that next process is pending from management side. It's been almost 10 days since from 2 nd round of interview. How much more time does it gonna take, any idea? Or is it normal. Please help me with this 🙏🙏 .Deloitte

like

Hi folks,

May I know if Oracle India providing technology services as well?

( Is it both Product and service based organisation?)

like

When a recruiter asks you for salary expectations and you deflect by asking about the allotment range for the role.. they still give you a lowball answer - right?

Happened to me recently and I gave a higher number than they have budgeted, but I feel I’m worth that much.

like

Got an offer from Capgemini for 10LPA fixed and also I got an offer from HCL for 11LPA (includes variable pay but mentioned it will be paid monthly basis) , which one is good to join to develop my career growth. Having 4YOE in network security , vulnerability management and selected for the role of vulnerability management in both the firm's
Please suggest me.

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

Anyone here from on-boarding team knows about the on-boarding of freshers who have 9 july as percipio course end date
I am a sponser and the fresher alloted to me asked this question. anyone if he/she knows about it
TIA!

like

can anyone let me know about Hashmap. The company has been acquired by NTT data and they are offering ntt data offer.

YOE is 6. Profile is senior cloud engineer-ETL

like

I got an offer from Telstra, I have 7.5 yrs of exp., please guide me how's working at Telstra, in terms of wlb .

And job security, as there are lots of new about lay offs in the industry from product based organisations mainly, will Telstra be safe to join.

How many days need to come to office, and what are the work timings.

Is work from home option also possible.

Please guide.

TIA

I have an offer from EY GDS.
How is the job security at EY.
How is the WLB and management.
Tensed as TCS and EY are completely different yet EY offered nearly 150%hike.

like

Does anyone else just not even want to be a people manager anymore?! The amount of work this is taking, I’m just so over it. In addition to them piling on my work (which is a full time job) the people management stuff is just as much a full time job that no one in management seems to take into account. I have tried countless times to explain this but I end up burnt out, everyone suffers including me. I just left one role bc of it and now this new role, same thing. I’m over it.

like

Anyone working at a PE firm as a data scientist? Got a recruiter who reached out to me and looking to talk to others to get a lay of the land.

like
like

About to interview with Neuberger Berman, hadn’t heard of them before. Anyone have any thoughts on their culture and WLB?

like

Wondering what people think about my situation. I’ve been offered a role with a company. The job description didn’t mention college degree as a requirement. On my CV I have a section listed as “Education” and under it I have “Business Studies” with the university name and the 3 years that I attended the course (2.5 to be exact). It’s a 4 year degree and under this I have my High School equivalent with the years I attended there. The education wasn’t mentioned in the interviews. Continued below.

like

More Posts

Anyone here work in a family office role? What are the hours and salary like?

like

Recently joined cognizant. Current location is Pune, joining location is kolkata.
Recruitment HR has confirmed in the email that I can collect the asset from pune and work from pune for few days until I go to kolkata.
Onboarding HR is like you have to come down to kolkata for collecting the laptop. Has Anyone faced similar experience?

like

Hi Fishes,

What is the salary bracket and position like for grade 130 in IQVIA?

And are the HR open to negotiations in case of fresher hire?

like

Does Oracle provide free fusion certification course to their employees?

like

Is it common in Optum to ghost candidate again and again??

like

Ladies, anyone found an eye cream that actually works? Please share what that is along with your age and how long you’ve been using this product.

like

Hi

I have joined IBM and resigned within 50 days.
Reason: project I was allocated not good and I initially rejected project but they forcefully moved to the project.I have asked multiple times to replace the project after that I have resigned.
Now manager is threatening me that I will be placed under no hire to IBM.
Is it ethical?

like

Just started a new role at a global company and I'll be leading marketing efforts for my team.

The company is huge, but slow and isn't marketing savvy.

I'm making request for programs to make my life easier.

Monday -PM
Adobe
They're already integrating Salesforce.

What other software or ideas would you ask for?

like

Hi fishes ,

I received an offer for senior manager position in PWC .

Can you please let me know about the health insurance coverage amount ( senior manager position ) as it is not mentioned in offer letter.

Hi Fishes, I've 5.7 YOE in digital marketing and i have an offer from PS for Senior Media Analyst Role in Digital Marketing Domain. After seeing all the layoff post i'm getting scared. It would be helpful if you could please let me know if anyone if fired from Digital Marketing Domain.

DOJ is Oct 31st, i dont have more time. Please comment if you know anyone from Digital Marketing.

Is it possible to study for Bec & Audit together ? If so Can I have any tips ?

like

Hello Guys,
How much appraisal hike you all have got in this cycle?
In my case they provided very less hike of 3% and I have done so much work.

Displeased that we won’t let her eat the dogs’ food 😂

Post Photo
likefunny

Is going from Deloitte (tech strategy and not monitor) to Oliver Wyman or Roland Berger considered an upgrade or downgrade ? I don’t really feel the MBB, prefer the mid-size botique

like

Where do you go after B4 audit if you don’t want to go to industry that has true work life balance? I’ve been busy since September straight... this won’t end for a while. I enjoy accounting and enjoy being challenged, but my mental and physical health are also falling by the wayside. I’m only in my second year, but I’ve been working in full senior capacity for a while. I like the research/memo writing side of the job the most (when I get to do it). Just tired of the hours.

like
like

How do I get students to expand their sentences/give more details?

like

Review summaries out?

like

How to apply for onshore roles in ZS. not sure if transfers are being approved as of now. Pls suggest.

likefunny

any ideas on freelance rate for vp/svp strategy director in nyc?

like

Additional Posts in Consulting Exit Opportunities

About to start my first PM job! Any tips to be prepared and ramp up quickly? Books to read, courses to take, etc.. any tips are appreciated! Currently in ops consulting. No tech background.

like

Is it bad form to reach out to people on here for the company I’m targeting? I’m referring to the employees who have their networking turned on so you can see their name and position.

like

During these times, when joining a new company - are you folks negotiating any language of not being laid off or compensation if offer is rescinded?

like

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

If a company I got rejected from is posting an opening for the same role should I re-apply? Any chance of a better outcome?

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

Anyone here who made the exit from Big 4/MBB consulting to a VC? If so, I’d love to hear about how the experience is so far. (Not to mention the WLB and comp!) I’m considering a career change but have no one in my network I can go to for insights. Thx! 🙏🏾

like

Upcoming interview with large tech company for biz ops go-to-market role. Any book recommendations to learn about go-to-market / sales op strategies for tech?

funny

What books would you recommend for someone wanting to get better at sales?

like

Anyone witness slackers who got into companies you have no idea how? Had a coworker who does jack chit at work besides chatting on Facebook yet lands at a faang company? I guess if he brings the same work ethic he will be spit out for sure. Or maybe he just had no interest in doing project work.

like

Are corporate finance or pricing dead end ops?

like

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

like

Anyone from Amazon willing to refer me? ~3 years in tech implementation and product management

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

If you’re a software engineer at a tech company a half step below FANG, does it make sense to consider BCG Gamma? I was in Big4 before and am undecided whether I want to return to consulting long term. 2 YOE and recently exited but recruiters have been messaging me so thinking about 2-3 years down the road

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

thoughts on wayfair?

like

Two of my ex-colleagues work Facebook and Amazon respectively. they said they will give me a referral.

should I ask them to give me multiple referrals for different roles or just focus on one? 

like

Interested in tech in NYC—open to FAANG, but more interested in series C+ startups that know what they’re doing and can afford to pay. BD, gen mgmt, strategy/ops roles in that order. Any suggestions?

like

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

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