I applied through a recruiter. I interviewed at Meta (Menlo Park, CA) in Jun 2025
Interview
Writing this review for initial technical screen. so it helps others. You should be good at reading questions fast and grasping what to write. SQL somebody posted in blind, mostly revolves around books, copies and authors etc. they are 4 to 5 schemas for me. Python too continues similar to SQL questions, for me it was Library related questions for both SQL and Python. SQL, get comfortable writing SQL by looking at schemas and without expected output not looking at data, because you won’t have time to look each table data. Questions mostly aggregations with joins. Specially Counts & percentages. Python leetcode won’t help much. Understand common data structures like they said list, tuple, sets, hashmaps and all functions with them. And may be practice stratrascratch python questions not leetcode. Because python questions too are like business usecase, lengthytakes time to read and get comfortable to write code
Interview questions [2]
Question 1
Sql - how many books are in good condition and not returned, what percentage of book copies for above statement have renewed more than 2 times
Python- list of tuple with book category and points. Find max number of points student can score for up to 3 books. Book must belong to different category
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.