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

Infosys gave 3rd hike in 6 months that too 15-30 %

like

Anyone know the salary bands for a Deloitte Consulting FS senior Manager in Phoenix?

like
like

Hi, I'm looking for a referral for Program Manager role at Atlassian.

like

Firms hiring in Texas, Iowa or remote? Junior associate with CIPP (US +E), CIPM, and a post-grad fellowship in cybersecurity.

like

How is PwC LA office culture/ atmosphere/ how often to the office?

like

I have 2 offers 1 from Cognizant And 1 from Volkswagen IT Services India Pvt. Ltd.
I am really confused regarding which to join.
I have 2 years experience as java developer and looking to work in latest technologies i.e. spring boot and Microservices as a developer .

Kindly suggest

like
like

Espire Infolabs is the worst company. Never work for them even for a Consultant role!!! Don't even think of joining them, it would be the worst decision of your life!

like

Hi sharks,
I am appearing for the interview process at Nagarro for the position of senior front-end developer (ReactJS). I have cleared the IQ & coding round as well as the first tech interview.

Could someone please help me with what I can expect and study for the second technical round for position of senior front-end developer (ReactJS?

Also, please help me get 11 likes so that I can DM some of you :(

Thanks in advance :)

like
like

Why is it so hard to find a remote HR position? I have my SHRM-SCP, my MBA and over 10 years of experience being an HR Manager.

likesmart

I recently had an interview with HCL and cleared 2 rounds of technical interview. I waited for a week for HR call but no such call was received. I then contacted the POC who scheduled the interview (he is an HCL employee) and he said that I have been shortlisted and will receive HR call shortly. This was 1 week ago and I have still not received any call. Has anyone else faced the same issue? And if yes, should I even expect a call fro HR?

Basic interview questions for 2 year experienced ui ux designer. Anyone please?

like

Hi fishes, can you please tell me why do ppl say join EY GDS and not EY India. I am into Java Fullstack, yoe-4, location -Pune recently cleared online test and given interview and later get to know it's EY India not GDS. Now m worried should I join or not. I have 2 other offers from WITCH companies. EY EY India

like

Hi Guys, I am notice period with 30 days remaining, having 12+ exp in java, spring boot, microservices. Need the reference for applying to major banks like Credit Suisse, Master card, Barclays, Citi, Deutsche, BOA, JP Morgan etc..
Kindly help...

like

I have worked in marketing for about 6-7 years. First few years were in social media management. My goal is to work at a big tech company.

I’ve heard mixed results about the ROI of earning an MBA. My near future goal is to move into a Marketing Director (or senior manager) role.

1) How much does Google, Amazon, Microsoft, etc. value MBAs in the hiring process?

2) Anyone currently working at the companies above with only a BBA?

Current situation: Marketing Manager, 90k, NYC.

like

I am an email marketing specialist. I am approaching my one year at my new job. I have been going above & beyond. I have been recognized by my boss that I have been doing great as well. I have been implementing new strategies, completing all assignments on time, and I do the most in all of our meetings, interviews and business events. How much can I ask for a raise?

like

Have worked in both banking and consulting, but still looking for a combination of things:
1. Something that’s less quantitative / producing and checking numbers constantly
2. Managerial and people-focused - not just an IC role
3. Ideally remote with some kind of international flavor

2 years post-MBA, 9 total YoE, incl. MBA

Any suggestions?

like

Out of these 4 Citi or Standard Chartered or Morgan Stanley or JPMorgan is better for overall Work Culture/ Onsite Opportunities + Salary?
Domain - Risk Management/ Compliance/ Internal control. Please suggest.
Morgan Stanley JPMorgan Chase Citi Standard Chartered Standard chartered gbs KPMG

like

More Posts

Got offer for aws program manager L5. 26 lpa base plus , 14 lpa signing amount and 12 rsu. Does that look good or further negotiation can be done. Base salary is not very high from the current base salary. Please suggest

like

Anyone been through the JP Morgan initial phone/recruiter interview? Any insights on questions asked?

like

Is there any industry recognition for poc creatives the way adage and others recognize creatives?

like

To the struggling healthcare student. It’s okay to struggle and not know stuff. Sincerely your friendly neighborhood physical therapist.

like

Anyone here familiar with the medical records field reviewer positions at Change Healthcare? Looking to get a little more info on schedule, workload, and pay specifically. TIA!

like

I know this seems small, but my team ignored my birthday this week while celebrating two others. It’s not like they didn’t know - it’s my 2nd birthday celebrated with this team. Feels horrible.

like

How to become program manager

like
like

Moving into a new role to support marketing efforts of two smaller divisions under our brand umbrella. When I asked my boss what the job description was to create year end goals they told me to write one. . . Where do I start?

like

Accenture tech consultant vs KPMG Management consulting for top MBA exit in a few years? Which one will look better?

like

https://play.google.com/store/apps/details?id=com.tgc.greatcoursesplus

The courses here would help with self-development.

like

Hi All,

What will be the In hand salary for this compensation in IBM Bangalore
YOE - 6.7 years
Technology - Salesforce Developer
Current CTC - 10

Thanks

Post Photo
like

Anyone willing to refer to a role at Flatiron Health?

like

What would you do?

Industry accountant with 5 YoE, can move into senior position with $100k base, or lateral move into big 4 as associate in assurance AWM.

Interested in capital markets, PE, investment...Senior role is unreleated to these industries while PA role could potentially open doors? Just would hate not getting that salary bump after I can finally start seeing some real money after 5 years.....

Also potential advisory role in regional firm but nothing concrete...

like

LTI is Hiring for below Oracle - BU positions

Need immediate to 30 days joiners only

Location: Bangalore/Mumbai/Pune/Hyderabad/Chennai

JDE CNC
YOE :4 - 10 Yrs
Skill : CNC

JDE Finance Functional
YOE: 4 - 10 Yrs
Skill : FUNCTIONAL-FINANCE

OCC (Oracle Commerce cloud)
YOE: 4 - 10 Yrs
Skill :OCC

Oracle Flexcube
YOE :4 - 10 Yrs
Skill: FLEXCUBE

Oracle CPQ CLoud
3-5 years of experience in Oracle CPQ Implementation & Support
location - Mumbai

Interested plz DM with job codes

Post Photo
like

Hello fishes,

I have 2.5+ years of exp in Firewall, Proxy, Endpoint Security and SOC operations environment.
Currently I am working in a Datacenter, and am looking for a switch in same domain.
Kindly help me with referrals.

My Notice period is 90 days.

like

Folks in atlanta, which is the quickest country embassy to get schengen?

Hey fish: what are some of your favorite business/self-help books?

like
like

People who have made it to the perceived “top/best” place in their career field/education (MBB, FAANG, top PE fund, HSW, etc): do you feel satisfied? Have you had to recalibrate your goals? If so, what are those goals?

like

Additional Posts in Consulting Exit Opportunities

FAANG seems to be the dream exit opportunity for many consultants. That said, do lots of people leave FAANG? If so, why?

like

Recruiter reached out to me for a PE opportunity in SoCal. Any ideas of WLB of PE (as compared to consulting)?

like

I have an interview with an MBB for an knowledge management/specialist role. I currently work as a technology consultant for the advisory arm of a sub big 4 accounting firm. Cont.

like

Shameless company plug, sorry y’all. But Morgan Stanley just rolled the FRM Experienced Professionals Program. This program is designed to recruit and develop diverse professionals regardless of whether they have a background in Finance or Risk Management. Lmk if you’re interested and I’ll make sure to forward you the information.

Post Photo
likehelpful

Hello All - looking for links, resources , samples on interview prep/practice for sales , account management, partner management, practice management at FAANG companies like amazon, google, microsoft

like

Switching from consulting to product managment role. Any recs for prep (books, online courses, etc.)? Thank you!!! 😊😊

like

I had a job interview lined up for Wednesday. A family member is very sick (yes, wuhan virus) and I want to cancel the interview. How do I say this without burning a bridge? (1, contd)

like

Doesn’t feel great when the job you are interviewing for (that wasn’t advertised at all) is posted on Linkedin a few days after you interviewed 😞 Gotta keep looking...

like

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

like

700 person tech startup in Boston is extending me an offer and want to have a call to discuss comp. How much should I ask for?

I'm 2 years out of undergrad and the role is Business Architect.

What factors go into the initial offer Google makes? Is it interview performance, YOE, etc? And how are they weighted?

like

What are the best consulting firms to have a clear path to exit into big tech?

likefunny

Looking forward to pursuing opportunities at Google Canada. It’d be really appreciated if someone could put in a referral for me. Thank you in advance!

likehelpful

What are some top exits for pre-mba/1-2 yrs post mba consultants into sales functions? For context - I worked as a quota-carrying AE at a tech startup before graduating undergrad and coming to consulting (current BA). Really enjoyed my experience and curious what ex-consultants have done in the sales space (industry agnostic). 🤟🏻

like

Has anybody tried to go out for the reserves as an officer? Most interested in Intelligence roles but would love to hear about experiences that people have had.

like

Why are so many people leaving Facebook?

likefunny

I work in ERP consulting on the technical side. Wanting to move into product. Would anybody be willing to give my resume a once-over?

like

Has anyone had luck pivoting from federal consulting to industry? Targeting data analyst/data science roles but not gaining much traction (aside from other fed opportunities). ~3.5 YOE

like

Is there anyone working in Marketing/Product Management for a health tech firm in Atlanta? I would love to chat.

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