I was reached out to by a recruiter via email and scheduled a phone call interview. Next, I had an on-site interview where they gave me enough time to prepare. Prep calls are the best. They gave me a very brief mock interview process for product sense.
Main focus should be on product sense, SQL, and basic Python, specifically lists and dictionaries.
SQL: You should be well aware of aggregations and how to perform a one-table scan to provide aggregated values.
Product sense is something that will be covered in all your interview rounds.
Data Modeling: Focus on how you design dimension and fact tables. Make sure to have denormalized fact tables. Review data models from Uber, DoorDash, and LinkedIn (at a high level, not like graph databases).
SQL questions will be based on your design approach.
Python: Basic questions, such as calculating averages and traversing/sorting lists and dictionaries, would be sufficient.
The following metrics were computed from 347 interview experiences for the Meta Data Engineer role in United States.
Meta's interview process for their Data Engineer roles in the United States is extremely selective, failing the vast majority of engineers.
Candidates reported having very good feelings for Meta's Data Engineer interview process in United States.