I applied through an employee referral. I interviewed at Meta (Sunnyvale, CA) in Nov 2025
Interview
The SQL questions are typically medium difficulty, involving joins, aggregations, window functions, and CTEs, often tied to real business scenarios like retention or funnel analysis. The coding questions (mostly in Python) lean toward easy to medium difficulty and cover arrays, strings, hashmaps, and 2-pointer techniques. Focus your prep on Meta-tagged LeetCode and StrataScratch problems, especially in SQL and data-heavy logic, and practice writing clean, performant queries.
Interview questions [1]
Question 1
SQL Questions
Python Questions
Data Modeling:
facts:
* different types of facts and their grain
* pro/con of your fact design
* don't be afraid to give more than one fact table
* identify pk, fk and relationship (1 to 1, 1 to M)
* pay attention to the grain you defined
dimensions:
* give attributes
* bridge table, scd 2, role play, pro/con of each type in terms of performance
I applied online. I interviewed at Meta (New York, NY)
Interview
Prepare technical concepts, and practice previously asked questions as much as you can find online. 4 rounds in the total process. It's easy as long as you just practice a LOT.
I had Python and SQL round for 30 minutes each. The interview was for 1 hour 30 minutes for SQL and 30 mins for python coding.
Completed 5 questions each but still got rejection email the next day.
