I applied through a recruiter. I interviewed at Meta in Apr 2025
Interview
The entire process follows 3 main steps.
1) HR screening
2) Technical screening; white board coding is tested here
3) Full Loop interview; should be 5 consecutive one hour interviews
Interview questions [1]
Question 1
Expect 5 sql and 5 python questions. You are given 4 tables for sql and have to create queries using joins and aggregations to answer. All questions will be focused around these 4 tables. For python, questions are related to string manipulation, arrays, and dictionaries.
I applied online. I interviewed at Meta (Menlo Park, CA)
Interview
The first round includes three Python questions and three SQL (PostgreSQL) questions, which are very tough, I think. The recruiter is very responsible and fast to reply. You can always see the interviewer via their website in advance.
Interview questions [1]
Question 1
Do you have any relevant experience for this position?
I applied through an employee referral. The process took 3 months. I interviewed at Meta (San Francisco, CA) in Mar 2025
Interview
Spoke to the recruiter and a Technical screening was setup.
5 min Intro
25 min SQL - Know your basics - Joins, Aggregation, CTE, Window function
25 min Python - Do data structures thoroughly and String Manipulation
5 min for questions
Interview questions [1]
Question 1
1.Retrieve the top 10 customers who purchased the highest total number of books in 2019, considering only non-refunded sales.
2. Calculate the average total purchase amount segmented by customer reward membership status and whether the purchase was made during a defined season or non-season period. (Season - after Nov 15)
3.Determine what percentage of total book sales (by revenue) is contributed by the top 5 most expensive books.
4.Identify customers who have made purchases on more than one distinct day and bought a combined total of more than 3 books on their first and last purchase dates.