I applied through a recruiter. I interviewed at Meta in Oct 2021
Interview
Recruiter call and basic screening questions.
Followed by a coderpad technical screen with an engineer.
Involves 30 mins python, not complicated, progressively complex questions, not algorithmic.
SQL questions 30 mins.
Interview questions [1]
Question 1
given a schema progressively ask sql queries ranging from basic to window functions.
1st round - phone screen; 2nd round - online assessment; 3rd round - talking to a senior data engineer. Did not go well on the last round and was not well prepared
Interview questions [1]
Question 1
What is the fundamental of building a data pipeline. What is the most challenge project that you have ever worked on. If you have conflicts with your manager, what would u do
I applied through a recruiter. The process took 4 weeks. I interviewed at Meta in Feb 2021
Interview
two rounds of coding and one on site, sql, python, basic live coding questions, Join tables, rolling average, string manipulation etc ... nothing too difficult, interviewer is nice and helpful