I applied through a recruiter. The process took 4 weeks. I interviewed at Meta (Menlo Park, CA) in Nov 2018
Interview
The recruiter reached me on linkedIn , we set up a phone screen which was more about the position. Then I had technical coding interview on coder pad with an other data engineer, Its not hard at all, all basics question around string,list, dictionaries. i answered 5 Sql and 5 python questions total of 1 hour.
Finally, I had my on site interview. for some reason the recruiter called the question full stack questions but there is no css or JS coding involved. All on site questions are regarding DW design, table design, Schema design and etc. The interviewers ask sql questions based on the DW that I designed for them.
The onsite questions are no match with coder pad interview. You need to have a good understanding of system architecture and system design.
I personally could not finish a python question . The question was about updating metrics (I defined the metrics to answer earlier question) for a fb module as stream of new data is coming in. As interviewer point out I was on right track having a session id and user id to de-dup same user activity, but it was not enough i guess.
My impression was they want someone who answers quickly and smoothly in all questions. I literally just missed 25 % of a python question and I got rejection. Also I got the feedback that I have good product sense and coding experience which made me fee like they expect you answer all of their questions.
One last note: They ask questions to make sure that you are not using data engineer position to switch some other questions like data scientist or etc , i heard a friend aced the technical but was rejected because of that in the last round.
Interview questions [1]
Question 1
Flatten a nested dictionary?? ( this was the hardest question in coder pad questions )
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.