they gave you 3 python and 5 sql problems, SQL ones are hard and you have 1 hour time to solve all of them. Interviewer keep on asking about your thought process and time complexity.
Ho presentato la mia candidatura tramite segnalazione di un dipendente. Ho sostenuto un colloquio presso Meta nel mese di mag 2017
Colloquio
Round 1 - 30 min call with recruiter to gauge the fundamental understanding of concepts in SQL + Python
Round 2 - Phone Screen on Coderpad - Coding questions on SQL + Python
Onsite Interviews - 3 full stack interviews + 1 lunch Interview
The full stack interviews will involve - Identifying metrics,Data Modelling,Data Visualization,SQL query writing and Python coding
Domande di colloquio [1]
Domanda 1
Given a Problem statement,had to figure out the KPI's immediately.
Ho presentato la mia candidatura online. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso Meta nel mese di nov 2025
Colloquio
Had a recruiter reachout + questionnaire. After I scheduled my technical screen (5 python 5 SQL in 50 minutes). Must solve 6-7/10 to move onto the onsite. Try to practice with a timer as the questions aren't too difficult, but you need to be fast.
Domande di colloquio [1]
Domanda 1
Which books are in good condition and have been renewed exactly twice? What percentage of books have more than 10 copies in the inventory? What is the difference in renewal counts between a borrower and the member who referred them? Given a list of (category, price) pairs for each user, where each user is allowed to borrow items from up to 3 unique categories, how can you calculate the total price of borrowed items per user? Given log entries for each book where True indicates a checkout and False indicates a return, how would you validate the logs such that: A book cannot be checked out if it's already checked out. A book cannot be returned if it's not currently checked out.
Ho sostenuto un colloquio presso Meta (Londra, Inghilterra)
Colloquio
So far easy, I had prescreen, screening (python) and on site interview, best experienceI had a smooth journey through the interview process, starting with a prescreen followed by a screening focused on Python, and then an engaging on-site interview. It was my best experience!
