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.
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.
