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!
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.
I applied online. The process took 1 week. I interviewed at Meta in Nov 2025
Interview
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.
Interview questions [1]
Question 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.
