I applied through an employee referral. The process took 1 week. I interviewed at Meta (New York, NY) in Feb 2025
Interview
The first step after Resume Screening is Phone Screening. They asked me to choose time slots on 5 different days and then they arranged the meeting. As soon as we began I was given a topic and in my case it is Facebook Marketplace. As this was a fresher position at Product Analytics, I was let of easy.
Interview questions [3]
Question 1
I was asked 2 basic sql questions based on a buyer seller interaction data.
Then a case scenario where the company was planning to add a notification option for the similar products they have viewed and asked me what are all the metrics I would consider to show if this feature would improve the product. There were a series of follow up questions.
SQL + Product Case. The Interviewer was really nice and asked a bunch of good follow-up questions including how to optimize SQL. Overall positive exp. Got the result the next morning from the HR.
The interview started with an introduction, followed by case study questions to solve business problems, showcasing thought process and problem-solving skills. Then, the SQL questions. The interview concluded with a brief Q&A.
Interview questions [1]
Question 1
The SQL question was to get the category with the maximum count using GROUP BY and ORDER BY.