Any tips for the Facebook manager technical interview?

I've been told I'll be writing sql queries. Did a bunch of HackerRank questions so I'm not feeling terrible on that front.

Anyone know the sql dialect they use? Presto?

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

Yeah it’s presto but the SQL interview will be on Coderpad so it’ll effectively just be an open text file, no run capabilities

Yeah it’s off

Finished up. SQL portion seemed fine besides me making up a function because I couldn't remember the actual syntax ;)

Well see how it goes.

Haha yeah sounds about right, the test is more how can you reason through a data question, vs how is your syntax and coding

like

Related Posts

I am currently working as a PayPal AWF/CW in contractor's payroll for the past 3 months. I heard many got converted from AWF to FTE. So what is the process for FTE conversion? Should I clear some Interviews? Also how much would the salary increment be? On par with regular hiring? Any minimum time limit of being in AWF before FTE conversion?

like

Hi can we give interview again in HCL Technologies
They gave me my employee id but as soon as interview started i got internet issue could not give the interview completely

Want to try again once for different profile HCL Technologies

like

I'm planning to transition to Data Science. What should be the key technologies that i need to learn and add to my resume to make this work?

Thanks for your suggestions.

like

Can someone please guide on the interview questions asked for SAP Ariba consultant role with 2-3 yrs relative experience.

like

Hi Fishesh
I have been selected for HCL Tech
as per recruiter’s confirmation I have uploaded required documents
But did not received offer letter yet
Trying to reach recruiter but they are not receiving my calls either from last week.
on Ionboard portal I can see the 50% process has beed completed.
Is this a normal process in HCL ?
what should i do? please suggest

like

Got offer and accepted but other firm that I applied ask for additional interview. Please advisd how to tell them "no" nicely ?

like

Is anyone willing to look over my resume to let me know if I’m qualified enough to be a consultant at Deloitte? TIA

like
likeuplifting

When you’re applying for customer service jobs, do you customize the resume objective for each?

like

Why has it been so dang hard to move from banking to a strategy role in my industry or expertise? Or a start up? 90% of my applications have passed on me before even giving me a first round interview! I’ve been on over 6 deals, and wanting out and it’s been extremely frustrating! Any insight or advice?

like

Please wish me luck on my final interview today. The salary would be life changing for me. 😬

likeuplifting

Can someone please take a look at my resume

Post Photo
like

Can we refer someone in Optum if they are unknown to us and reach out to us on linked in ?
Mostly are freshers who are reaching.
Also is there any limit for number of referrals which we can make

like

Love tossing out resumes that say "Founder/CEO", more every year

like

If I reject Accenture Technology offer, will I be able to appear for Accenture Strategy interview later on? I have an MBA.

like

Hi
I have received an offer from a company and I'm in the second stage of interviews with another company. I am very interested to see if I could make it through for the second company. So can I accept the offer from first company and then if second one also sends an offer then let the first company know I would like to reject? Also i am on H1B visa. Should I be concerned with that?

like

Is nagarro round 2 managerial or technical?

Has anyone successfully made the career move from an HR specialization to an HRBP role? If so, how? I have been working for 7 years in a very niche HR specialization and while I wear many hats on the HR team, I feel like this is hard to express to recruiters or even get an interview for an HRBP role. My niche area has really burnt me out, as it’s very political and I want to expand my horizons. I am already working on completing my GPHR certification. Any other tips?

like

Have an interview lined up for a Senior manager role - any advice on what I can expect from the first 2 rounds? - interview and then the case?

like

Hello. I have a job interview coming up. When asked the question by the interviewer, “Why do you want to leave your current employer for us?” What is the best answer?

like

More Posts

I've just 12 hrs to think about this -- Oracle or Freecharge ?? Work profile with Oracle is development of oracle jet framework and with Freecharge merchant app with freecharge Please help yaaro

like

If you have a child during your first year of employment at your firm, are you eligible for the firm’s full maternity leave benefit? Or only if you have a child after your first year anniversary? TIA.

likehelpful

Which machine learning conferences are FAANG companies recruiting at ?

helpful

Any MDs willing to talk to a MD with significant clinical experience who is interested in consulting?

Hi All,
Can any one please tell me if there is any shift allowance in Macquarie?
If Yes how much it is?

just got a full time graphic design job. is there any reason why using the work-provided adobe creative cloud account for personal use is a bad idea? like privacy or something? i’m thinking of canceling my personal subscription and saving some money.

like

i am fresher and got deployed into search technology
I just wanted to know what is scope of search technology in future and scope of Solr,Elasticsearch.

like

Anyone else experience of a lack of passion for the job in this Covid world? I just feel like I’m excited about what I’m teaching because so many techniques are not at my disposal. I also feel exhausted by the mask. I’m all for wearing them, but wearing it all day drains me. Any helpful ideas to reignite the passion?

like

Anyone in Austria?

like

Relocating to Chi. My wife has deep experience as creative recruiter, creative dept manager, digital producer and PM. Any leads for this fiercely talented pro and lovely human being?

like

Hey fam, I'm going to Banff in 2 weeks. How bad are the lines to get into parks for lake Louise and lake moraine. I'm staying at the kananaski resort for distance consideration

Bachelor party recommendations in Vegas ?
Group of 5 planning. TIA

like

Anyone stay at the W Costa Rica? Planning a trip to Costa Rica and trying to decide between that and the all inclusive Westin right next door.

like

Hi, what does the typical career path look like in Tax at EY UK? Thanks.

Tip for anyone taking the CAIA exam, get UpperMark. Was using willey and was abt 1/2 complete and borrowed a friends test bank … night and day much harder and honestly was more like what I expected

like

Kitne baje aega letter

like

What is the average salary for 9+ years experience at C1 at Capgemini?

like

I am looking for referral . I am around 10 years of experience and can join in 3 weeks

The nail on my second toe hasn’t been the same since I ran a half marathon a few years ago. It’s gross and totally messed up and it doesn’t seem to be getting any better. Do I see a podiatrist for toenails or a dermatologist?

like

Additional Posts in Consulting Exit Opportunities

What are people’s thoughts on Aon Inpoint for an analytics role? Recruiting highlights company culture and Inpoint’s innovations but it’s hard to find objective information on those things.

Sick of slogging in consulting and only making 42,000 a year. I feel like I’m getting robbed but don’t have enough experience to pivot to industry

likefunny

What do I get paid the most by doing the least? My wife and I are planning to have kids in the next year or so and I want to be readily available during and after her pregnancy

like

Feels like consulting haven’t grown my skills. With two years being an analyst and recently promoted to consultant, I cannot apply to any positions outside as I haven’t learnt anything.

like

Can anyone please recommend a resume writer?

like

I am not people person and having tough time as I am moving from 1 short project to other with no long term vision or goals . Every month new project new face and by the time I am settled , it’s time to move on . Have anyone had same experience and how do you deal with it

like

How is Advisor Business Analyst at DXC? What designation in D will that compare to?

Interested in eventually exiting into wellness tech.... what are the best consulting firms to start at?

like

Anyone have some good resources they can send me to learn more about exiting to corporate strategy?

like

I'm on season 2 of 'Breaking Bad' and I feel it's not as good as everyone hyped it up to be. Should I read spoilers and move on or does it get better?

like

What does Deloitte share when a background check is run by another employer. I am leaving, will Deloitte share my salary/performance?

like

For those of you who left the Midwest for a FAANG company like Apple… was the move to CA worth it? Have an opportunity and it’s just really difficult wrapping my head around the cost and standard of living, being far from friends and family, etc.

like

Has anybody done the Uber take home test? What do they define as “support model”?

like

On average, how long do tech companies give you to make a decision? (E.g. Uber,etc.)

like

Looking for full stack developer to join my early startup. We are a small team but hoping to grow a lot this year. Must love books and geeky stuff

like

Deloitte Fish - how much quant is there in your experienced hire cases?

like

Recruiters must be ripping my resume like Nancy Pelosi

likefunny

Anyone know anything about Samsara it is an IoT start up

like

If I accepted a new job which starts one month from now, when should I give notice? Is there any advantage or disadvantage to giving more than two weeks? Finishing my project tomorrow for context.

Currently C level (target promo next summer). Been mostly on finance transformation projects. Worked in strategic finance before that at a f500 healthcare company.
What roles/levels would I be a good candidate for at FAANG/Microsoft/other Big Tech?
No hard technical skills (outside of financial modeling).
I’m also studying for GMAT as t15 MBA is a consideration right now, so I could also try to make the switch after that.

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