I applied through a recruiter. The process took 2 months. I interviewed at Meta (Menlo Park, CA) in Aug 2019
Interview
I was contacted by a facebook recruiter in April for a data engineering position in their Menlopark location. I scheduled my phone screen in May and got past the phone screen. It mainly consisted of SQL questions mentioned in other posts here. The next ppart was Coding in python which was fairly simple too. By the time i got result of my phone screen, the position I was interviewing for got filled. The recruiter contacted me again when they had an opening in the NYC office. I was invited to Menlopark for the onsite. There were 3 rounds of technical interview, one ownership interview and one lunch meeting. The questions were fairly easy, they just want you to be comfortable in SQL and basic data structures.
Interview questions [1]
Question 1
High level SQL questions, Designing a database given a scenario and questions based on that, join optimization, reporting SQL questions without using special functions like lag.
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.
