I applied online. The process took 1 week. I interviewed at Meta in Feb 2025
Interview
First round technical screening: Given 2 tables, need to solve two SQL questions, then another case question based on the data from SQL questions. Last for 45 minutes, and nothing unique.
Interview questions [1]
Question 1
The questions are usually based on features of their products (such as information stream on Instagram).
💼 Screening Round:
It started with a product use case followed by SQL questions. Then moved into analytical reasoning—comparing CTRs, thinking through statistical significance. I felt pretty good by the end of that round.
(Cleared it!)
🌀 Then came the full loop—4 rounds, all virtual:
👨 Behavioral:
I talked through experiences—convincing cross-functional teams, handling tough coworkers, dealing with failure. Just kept it honest and tried to reflect on what I learned.
🤔 Analytical Reasoning:
This started off strong. I felt confident identifying success metrics and thinking through what “good” looks like for a product that had completed a pilot. Where I stumbled was in shifting from my usual A/B testing mindset to one that called for causal inference from past data. Definitely a learning moment I’ll carry forward.
👨💻 Technical Skills (SQL):
Pretty straightforward. I broke each question down into smaller parts and tackled them step-by-step. Focused on clarity, logic, and checking for edge cases.
🧮 Analytical Execution:
This round dove into stats and probability— binomial distribution, audience reach modeling, stuff like that. I actually enjoyed thinking through it live.
Interview questions [1]
Question 1
SQL - What is the daily revenue generated every day by this product in the US in the last 30 days?