I applied online. I interviewed at Meta (Newark, NJ) in Sep 2019
Interview
One phone interview followed by Technical round
If you get selected you will be called for in person technical interviews which includes multiple rounds
The interview panel is very friendly , ask questions and talk through whet you are thinking while solving the problems . They are looking at the approach along with the problem solving abilities
Interview questions [1]
Question 1
Sql problems - basic queries
python - list manipulation
I applied through other source. I interviewed at Meta (Menlo Park, CA) in Dec 2020
Interview
The interview wasn't hard but was full of logical thinking exercises and they wanted to measure your knowledge in Data Warehousing field. The interviewers were nice and helpful and the interview was more like a conversation. This was my first FAANG interview and the recruiters and interviewers made me feel so comfortable.
Interview questions [1]
Question 1
Data Modeling:
Data Modeling Question for a hypothetical scenario where you have scope to work on your Data Warehousing knowledge.
How will you design ETL pipelines for the model?
SQL question to display data from your model.
Python/SQL questions.
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.