This is the first round of interview I'm writing about. The result is yet to come, so I'll update my progress later. I was contacted in the past regarding the interview and my old recruiter connected me to this new recruiter. She was pretty friendly and walked me through the life at FB and patterns. She scheduled for a phone interview. Based on my recruiter answering 3-4 questions of SQL (Postgre not MySQL) and Programming problems each in a total of 50 minutes should put you ina good spot , though you're asked to prepare for 5 each in 50 minutes.
I'd recommend medium level SQL (questions on Leet Code and Easy - Medium Programming questions. I chose Java.
Interview questions [2]
Question 1
SQL - I was given 4 tables Sales, Product, Promotion and something else (Never had to use it).
1. Which product had the highest sales with promotions and sales ( basically a where clause on 2 flags)
2. What % of sales happened on the first and last day of promotion.
I don't remember the rest.. I'd say your ability to translate regular english statements into SQL is tested very well
I applied through an employee referral. The process took 3 months. I interviewed at Meta (Menlo Park, CA) in Jan 2019
Interview
Initial phone screen was with the recruiter and I just had to get ~75% of the questions right. All the questions were about basic Python and SQL syntax.
Telephonic consists of 5 SQL & 5 programming questions. The SQL setup in Coderpad was very easy to understand and use. The recruiter just let me do my own thing and he would respond when I got the answer right and proceed to set me up for the next question. At the end, he asked about some SQL function use cases.
On-site interview was three 1-hour technical interviews with a half-hour personality interview. Each technical interview tested a different aspect of data engineering (modeling, visualization, Python, and SQL).
Interview questions [2]
Question 1
Design a relational database for a ride-sharing app.
I applied online. The process took 1 day. I interviewed at Meta (Palo Alto, CA) in Jan 2020
Interview
I had a telephonic interview for about one hour after completing the HR round. Hr Round they asked simple Python and SQL questions. Telephonic interviewer not so interested in conversing just showed questions and asked to code.