I applied through an employee referral. I interviewed at Meta in Sept 2020
Interview
A quick pre-screening interview that involved general concept questions on SQL and coding. No long explanations required, they just expect a two to three word answer. I expected a normal interview (e.g. Starting with introducing myself, etc.) but apparatently this is just pre-screening and they jumpted right into the questions part.
Interview questions [1]
Question 1
I had questions like what's the default sorting order in SQL, how do you join two tables wuth only common rows selected, etc.
2 technical calls - first one was SQL + Case Study on metrics, second one was similar case study and a quantitative stats type questions. Got the offer ~ 10 days after, full process took 2 months or so
resume -> product case -> 2 SQL
Product case ask about the market place. "Based on the conversation between custumer and seller, how to determine whether the custumer's issue has been solved or not"
SQL is easy.
Interview questions [1]
Question 1
Product case ask about the market place. "Based on the conversation between costumer and seller, how to determine whether the costumer's issue has been solved or not"
There were two interviews, both were 45 minutes long. First focused on SQL and a product case portion. Second focused on SQL and "quant" (basically familiarity with numbers and statistics)
Interview questions [1]
Question 1
What metrics would you track if Facebook were to launch Facebook Dating (before they actually launched)