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 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.
It was a contractual job , so the contractors reached out , they needed only SQL & Python proficiency. They explained the requirement and arranged the interview based on my availability.They were pretty efficient.I
Bowls
Get actionable career advice tailored to you by joining more bowls.
Want the inside scoop on your own company?
Check out your Company Bowl for anonymous work chats.