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. I interviewed at Meta (New York, NY)
Interview
Prepare technical concepts, and practice previously asked questions as much as you can find online. 4 rounds in the total process. It's easy as long as you just practice a LOT.
I had Python and SQL round for 30 minutes each. The interview was for 1 hour 30 minutes for SQL and 30 mins for python coding.
Completed 5 questions each but still got rejection email the next day.
