The process took 2 weeks. I interviewed at Meta (London, England) in Apr 2024
Interview
Meta's internal recruiter reached out over LinkedIn.
The 1st stage was a phone screen with the recruiter (same on that reached out). Fairly standard qs - Tell me about your experience/walk me through your CV, etc.
2nd Stage was a coding round. 6 questions in total:
3 SQL question - nothing too difficult - JOINs, Aggregations, filters. No more than 3 JOINs required in a query. There are 4 tables provided and a schema, the trick here is not rush - think about which tables you need and which ones you don’t need.
3 Python Question of varying difficulties. You start with a simple one liner solution, moving to a medium question that will require loops, list and dictionaries. The last question is a hard one.
Interview questions [5]
Question 1
Tell me about your experience/walk me through your CV
You have a dictionary - key is a string and values are list of str. You need to find the most frequently occurring str across all lists/values. Can’t use pandas or anything. Pure loops, lists and dictionaries
You have a list of data classes. The data class represent an object with various start and end time of a meeting as well as number of people in the meeting. There are overlapping meetings. Your task Is to find the most number of people that were in a meeting at once.
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.