Has anyone interviewed for a business analyst type role at Facebook? Semi technical (sql, Tableau, but not data science or full on engineering)? What kinds of questions were you asked? Looked on

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

Glassdoor and they were all questions geared towards data scientists. They told me there wouldn’t be a coding section but there would be a more technical interview. Not sure what kinds of questions to expect. 4 rounds, 30 min each.

What area?

HR

First interview will be with recruiter and if you pass that it would blue jeans interview similar to Skype with future colleague or hiring manager. Good luck if you make to final round

Please report back OP I'm very interested in your experience here.

I had questions like:
1) What’s the difference between a distinct and a group by? Which is more efficient?
2) What is a null join?
3) Tell me how to query a DB if you had these dimensions. (They’ll look at the efficiency of your syntax and the commands you use, group by/distinct/case when)
4) When would you use Having vs. Where clause?

Related Posts

What’s the best way to handle situational questions in behavioral interviews (e.g., what would you do if you are faced with XYZ situation at work?). What are the expectations from the answer?

likesmart

Hi Sharks,

Please let me know what is the current situation in cognizant related to the revise offer letter?

Already holding an offer from CTS and I am expecting one more offer from another organization, so CTS will match that offer or not?

CTS Offer :- 17 LPA
Offer from another organization :- 23 LPA

Please give your inputs.

like

Happy Wednesday everyone. I'm so excited, I have a recruiter call scheduled with @Meta for Administrative Partner position. I've been in my current employer role for 19 years and I'm nervous as heck. I haven't had to do an interview in so long. Can someone please tell me what to expect with the recruiter call? I'm assuming it will be mostly about the role, my skills and background? Do they ask salary expectations? I have no idea what to say for the salary question. Feedback appreciated. Thanks

likeuplifting

Asking for a friend. Is LEK as brutal as everyone makes it seem like?

I'm assuming the LS practice has more reasonable WLB than the rest of the firm, since LS folks aren't always chugging along on DDs.

like

Hi,
Accolite Digital is actively hiring for the following roles: 
Java – Across Levels
DotNet – Across Levels
React Native- 4-10 years
Architect – Candidates working as Java or DevOps or Big Data or Solution architect with more than 10yrs of Experience and others as well.

Please message me directly if you are interested or apply from the following referral link as per your skill set:https://social.eduthrill.com/e/z6GJmiItYrb?referralCode=FQS2FRKL

Sprinklr hiring for Senior devops engineers & devops engineers
3-5 years experience
Location: Bangalore
Let me know if anyone is interested

like

EY application has turned to “We'd like to progress you to the next step in our recruiting process”. How soon does communication begin and typically how long is the process?

like

Hi Fishes... Allstate India vs Fractal. Which is good to join ? Skill : ETL,Azure,SQL. Package : almost same fixed. Allstate : X fixed , fractal : X+1L fixed.

Why the resource team is wrongly mapping to higher level management role project proposals. Like 4 yr experienced people are being proposed for 10 year experience requirement.
Does anyone else faced this? LTI

likefunny

I'll be graduating soon in Fall'22 and preparing for Data Scientist role. Please recommend some online resources to prepare from.

Hi,

Have offer from kpmg kgs and EY Gds with same package in Data analytics and risk team. Which one to choose considering better wlb, learning, growth opportunities?

like

Hi Team, How's the TUI UK project in Harman Connected Services? Can someone please share insights.

Thanks....

Harman Connected Services

like

Anyone here knows resignation process of Axtria?

I recently interviewed for a small strat consulting company (energy industry). I have 3 YoE and would be moving from engineering. the HR person asked me what my salary expectations were I was caught offguard and said I would expect it to be at least what I make now (around 100k). Im now worried theyll lowball me because I really shouldve asked for 120+bonus (I think this is market rate?) But they have salary bands they follow right?So if they pay consultants 140 usually would they offer me 100k?

like

My husband just received a job offer on an opportunity he is really excited about. It would be great for his career and they are giving the 15% jump in base he asked for, however they won’t share what the target bonus amount would be. It’s an executive director position, so I would assume it’s a decent target bonus, but without that in writing it could honestly be a gift basket at the end of the year. Is it a red flag for them to not share this? His total comp could be less at this new job…

like

Anyone knows what salary range to expect from Raytheon / Collins Aerospace / Pratt & Whitney for a Project Eng P4 level in FL?

like

Anyone working as a 2 years + lawyer for Fragomen in Canada can share their salaries and working advantages? (holidays, billable hours etc). Got an interview coming up and want to make sure not to under-sale my profile!

like

Best one among Morgan Stanley and jio for 3.5 yoe offering same package. Morgan Stanley Jio

like

What are potential career options considering the Current market scenario for Business Analyst/Product Owner with 5yrs of exp(2.5 post MBA) ?

It will be helpful if you can mention what will be the primary skill for that role whichever you are suggesting
Working in Mindtree (CPG Domain)

Hey fishes, aside from the obvs candidates (fjord, Ideo, snook, deloitte digital, ey Parthenon, pwc consumer bit), who else is doing good work in the UX research/service design space? UK/Europe based.

like

More Posts

Can you still get promoted on time if you don't meet the utilization metric during promotion year?

My Uber driver has a Tesla. Stories of the Uber driver having a nicer life then you. Go!

like

I live in a condo w maybe 50 units currently half full. Our gym is still open. Rarely more than one person in it. My SO was pissed I went and said that’s breaking quarantine. Ridic or should not go?

like

Hey all, please give me some ❤️ so I can send a dm

like

I have earlier resigned from IBM GBS, Can we use our leaves to shorten our notice period for an early release? If yes then which leaves are applicable? IBM

like

Hello Sharks,

I had my first round of technical interview in
Barclays on 9th June. I have not yet heard from the HR and the status on the portal "Interview Process". How much time do they generally take to reply back? IBM Barclays Deloitte Tata Consultancy

like

Anybody working Wayfair under Foraysoft payroll, need some clarification required Wayfair Wipro Cognizant

like

Hello all, I'm in the tech industry (networking and networks security) currently in France and considering moving to Canada in a couple of months. I was wondering about how much time in general i might spend searching for a job there, and is the french/europeane experience is taken into consideration in canada?

like

Hi folks can any tell me today is the joining date till now didn't receive any on boarding mail

like
like
like

I have a friend interested in a Real estate Client Associate role at Chase. May I ask what the salary range is for this role in the SF Bay Area?

like

EY TCF all hands call … what do y’all expect to be announced?

likehelpful

Any ladies at DU this week?

Any insight on Proskauer’s NYC L&E practice group? Good place for associates?

like

Before and after a morning at the salon (groomers lol)

Post Photo
like

Layoffs at Walmart corporate 😬😬

likefunny

Anyone likes The Strokes? Friend got cold feet and I’m now stuck with an extra ticket to their NYE gig.

like

My current package is 15 LPA fixed 5 years of experience. How much should I ask in the next switch?

I recently receive offer letter from TCS.I have gaps so affidavit is required.But i submitted BGC documents without affidavit. is it an issue in BGC process?

like

Additional Posts in Consulting Exit Opportunities

Just went through a horrible week with an average 4-5 hours of sleep and now botched my dream exit interview. Life is tough🐟fam.

likehelpful

Trying to get out of consulting and into some sort of project management. Can I do this without taking a pay cut? If yes, anyone willing to review my resume?

like

I know this is an HR question, but curious about others’ experiences. Do companies that don’t have a grief time off policy ever allow sick leave for this?

like

Hi 🐬. Any Amazon /Aws fishes willing to chat. Need to get some info. Amazon Amazon Web Services . Thanks.

like
like

Anyone who interviewed with Chime / moved there , what’s your sense ? Good exit? How’s the WLB/ TC at a Program Manager level ?

like

Left McKinsey for a Fintech corporate last year. Really disappointed to see bonuses given out (cash is equivalent to half month salary, equity vested over 5 yes also not great) after getting the 5/5 rating and business doing well overall. Doubting my decision to come to industry. Is this the norm? Feels really low as historically variable has been a big enough component for me to pay down loans/invest.

like

Anyone have any insights into the case study for strategy roles at Intuit?

likefunny

I’ve been trying to exit consulting for almost a year now. I’ve gotten a couple of interviews but no offers. I’m hopeless at this point 😔

like

Does Pepsi not pay well? Just got quoted pretty low for an internal Strategy role.

like

How common are offer letters stating, after separation, you can’t work for X months for a company offering Y services? Is this typically enforced?

like

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

like

Which of these roles best prepares one to run an e-commerce brand? Product manager, brand manager, product marketing manager, growth marketing

like

Do Accenture have well being rewards like Deloitte?

Thoughts on Grant Thornton? Specifically tech advisory in AU? Any tips/insights would be helpful!!!

like

Any thoughts on the eLearning space?

like

I have an offer with a start date in November. It’s 2+ months away, but should I consistently reach out to the recruiter? I don’t know what to say though, since I have a start date, but want to keep them me on their radar.

like

How to practice for a case interview with a b2b SaaS company?

like

want to interview at MBB again. Last year i had started the process but had to stop the process due to severe family emergency. What followed was depression and im doing fairly better now. I am Leaving Big 4 to join a tech focused Bank. But i feel like I should reach out to recruiter and start the process again. Just not sure if it’s the right move since im joining a new company. Feel it’ll look bad trying to join MBB after starting at a new bank. What to do?

like

What’s the best way to format consulting experience on your resume? Project bullets with sub-bullets or one bullet per project? Trying to update and I’ve seen both, appreciate any help! (visual below)

Post Photo
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