I applied online. The process took 3 months. I interviewed at Meta (New York, NY) in May 2024
Interview
Technical coding assessment consisting of 10 questions within 60 minutes, 5 SQL and 5 Python
Systems design question
Behavioral interview
Data modeling question focusing on star schema and complex product questions
HR call then leetcode questions with a mix of Sql and python. Covering data structures and algorithms, had to answer 5 out of the 10 questions to pass in 50 min
Interview questions [1]
Question 1
Algorithm question in python and standard sql questions
sql and python questions 5 each in 25 mins was the first round after a recruiter screen then a full loop round but i didnt make it to there pretty difficult and they dont care about the explaination just producing answers