Data Engineer Interview at FB
Anyone willing to do a mock interview for DE role for FB? I have one coming up in next 10 days. This will be very helpful. Appreciate and thanks in advance. @facebook #facebook #dataengineer #dataengineerinterview
Listen to your recruiter. Read Datawarehouse Toolkit by Kimball. Complete the exercises for Uber, Spotify, Dropbox, and Venmo to answer following Q’s: 1.) what are the important metrics for each business 2.) build a star schema data model for each business 3.) write the sql to build the metics (cut by important dimensions) 4.) explain trade offs for different designs (one user table or one table for consumer and another table for producer?) Important concepts: 1.) self joins 2.) joins where the left and eight aren’t = but > or < or other join logic 3.) dims vs facts Have questions to ask interviewer that ties to FB culture. PM Me and we’ll connect
Thanks a lot for the detailed response! I will send you DM to connect.
This is a great response! Do you have recommendations for prep material —books, blogs, YouTube channels to prepare for analyst roles at Facebook?
I am preparing for DE interviews too. We can connect and help each other with mock interviews
I’d be interested.. pm me
Hey I’m interested I have my on-site next Thursday Can I ping you
On-site..
When is your interview?
How did your interview go, I'm prepping for DE too . I got the leetcode and practice questions. Sql is easy but I need to brush up on python.
Received a full time offer 2 years ago. Understand their business models for their products (Instagram, whatsapp, Facebook, etc.) develop key results to measure and how you’d create a dashboard, ERD, transactions, etc. Understand python data transformation (easy if you have any object oriented programming) Star schema for things like Uber, Instagram, etc. Understand joins, coalesce, views and other stuff.
Ralph Kimball is bs. If you have to read theory , you aren't a DE already. Initial interview should focus on sql and python
Prepfully's got a couple of FB DEs but they charge 100 bucks for a mock. PS - I've only used them for PM mocks, for which they were awesome. A friend used them for FB and Spotify DE mocks though (SQL/ETL and Data Modeling practice) PPS - I have a referral code, DM me if you want it. Disclosure: I get 5 bucks off if you use it.
How much % off is the referral ?
Also 5 bucks
Mn lnnqqqq sweet wxcsvwvk c
Menlo Park?
Yes