Solicité el puesto a través de la recomendación de un empleado. El proceso duró 3 meses. Acudí a una entrevista en Meta (San Francisco, CA) en mar 2025
Entrevista
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
Preguntas de entrevista [1]
Pregunta 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.
Envié una solicitud electrónica. Acudí a una entrevista en Meta (New York, NY)
Entrevista
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.
Envié una solicitud electrónica. Acudí a una entrevista en Meta
Entrevista
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.
