Facebook DE (University Grad) Onsite Interview

Amazon
grandsome

Go to company page Amazon

grandsome
Sep 20, 2021 11 Comments

I have my interview coming up for facebook and was wondering if any data engineer from facebook can provide me with some assistance on the interview. I really want this position and it’ll be a dream working here. I’m comfortable with the ownership interview and python/sql, but nervous on the data modeling, and etl part of the interview.

If anyone also wants to mock interview feel free to shoot me a DM.

#dataengineer #facebook #fde #dataengineerinterview #datascience

comments

Want to comment? LOG IN or SIGN UP
TOP 11 Comments
  • I can help. Also worked at Amazon at some point. The interview is not so bad. I personally didn’t prepare at all and finished most of them early. Basically each interview starts with a product scenario. They’ll tell you something like “oh say we want to release service X, what metrics would we collect to measure its success?” Then you come up with the metrics and explain how they would be used. Then they’ll ask you to design a data model, which for the purpose of the interview will just be using a star schema. Just come up with your fact and then add foreign keys to your different dimension tables which store your attributes. Then once you do that they will give you SQL questions in which you’re supposed to reference your tables to solve the question. The Python ones asked to emulate SQL basically but using data structures like lists, dictionaries, sets, etc. Nothing crazy. It was just on how to process data. Then at some point they ask you to create a dashboard based on a metric you’re tracking. So you will just diagram the dashboard and explain how it can be used. Finally, you will have an ownership interview which is very similar to Amazon LP rounds. Just answer by using the typical STAR format.
    Sep 20, 2021 4
  • Pretty insightful information on the interview. Can i dm you for more info?
    Sep 20, 2021 1
  • Hey! How many YOE do you have
    Sep 20, 2021 2
  • New
    rmnc06

    New

    rmnc06
    Can i dm you as well? How did your onsite go?
    Feb 12 0