I applied through a recruiter. The process took 2 months. I interviewed at Meta (Menlo Park, CA) in Jan 2021
Interview
A recruiter screen followed by a 1-hour phone screen consisting of 5 Python and 5 SQL questions. Passing this got me to the onsite loop with 4 interviews (1 behavioral, 2 ETL, 1 Warehouse Design).
Recruiters were very helpful, prompt and friendly throughout the process. One of my best interviewing experiences.
Interview questions [1]
Question 1
Questions were on using/creating a data warehouse solution using SQL/Python to build a data pipeline to solve a business problem
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.
