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.
Begins with an application review and recruiter screening, followed by a technical phone interview that assesses SQL, data modeling, data warehousing, ETL processes, and coding skills in languages such as Python or Java. Successful candidates then proceed to onsite or virtual interviews, which include multiple rounds covering coding, system design, data architecture, problem solving, and behavioral questions.
Interview questions [1]
Question 1
Tell us about yourself and why you want to work for us
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.