Recruiter call, tech screen, 4 onsite interviews. Pretty standard IMO. The SQL questions were fairly straightforward without gotchas, just a couple of steps in the logic. The business case questions were also standard, not requiring specialized knowledge of the platform or the company, though I think having some familiarity with social media analytics would have been helpful.
Interview questions [1]
Question 1
SQL - joins, group by, date manipulation
Business case - a mix of open ended questions framed like "how would you see if xyz is a good idea" and more specific questions about metric movements and experimentation
I applied through a recruiter. I interviewed at Meta
Interview
Phone screen with Human Resources with simple SQL questions, coding interview with manager (used a shared screen), recruiter was very communicative and helpful, process was very streamlined, did not proceed to final round
Interview questions [1]
Question 1
What is the difference between a left join vs. a union vs. right join?
I applied online. The process took 2 months. I interviewed at Meta
Interview
I had three rounds of interviews, one 15-min phone screening with recruiter, then two 45-min rounds with data scientists. The interviews were very structured. In each interview, I was asked to talk about a data analysis project I've worked on. Then I was asked some simple data manipulation questions (you can choose to use SQL/Python/R), basic stats/probability questions, and product analytics case questions. Time at the end to ask the interviewer questions.
Interview questions [3]
Question 1
How would you create a model to find bad sellers on marketplace?