Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto 3 mesi. Ho sostenuto un colloquio presso Meta (San Francisco, CA) nel mese di mar 2025
Colloquio
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
Domande di colloquio [1]
Domanda 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.
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Meta (New York, NY)
Colloquio
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.
Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Meta
Colloquio
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.
