I applied through a recruiter. The process took 2 weeks. I interviewed at Meta in Dec 2020
Interview
First call was with recruiter and then the coding interview on coderpad with a data engineer. 1 hour of interview with 25 mins each for SQL and Programming (I chose Python ) , 5 mins of intro and 5 mins of Q&A at the end.
Interview questions [1]
Question 1
Python: 1. count occurrence of a word ,
2. Uncommon words from two sentences
3. Replace None with previous value
SQL: questions on Sales, Promotion, Product tables. Calculation of percentage of total sales on start and end dates with overall sales, etc.
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.
