I applied through a recruiter. I interviewed at Meta
Interview
The interview was quite time-constrained, so it was important to move through the questions quickly. The interviewer was helpful and gave hints if you got stuck, which made it more collaborative. One key takeaway is to clarify the question upfront especially for SQL since there can be edge cases that aren’t obvious unless you discuss them first.
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.
I applied online. I interviewed at Meta (New York, NY)
Interview
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.
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.