I was contacted by a Facebook recruiter in April for a data engineering position in their Menlo Park location.

I scheduled my phone screen in May and passed it. It mainly consisted of SQL questions, as mentioned in other posts here. The next part was coding in Python, which was fairly simple too.

By the time I got the results of my phone screen, the position I was interviewing for had been filled. The recruiter contacted me again when they had an opening in the NYC office.

I was invited to Menlo Park for the onsite interview. There were:

• 3 rounds of technical interviews
• 1 ownership interview
• 1 lunch meeting

The questions were fairly easy; they just want you to be comfortable with SQL and basic data structures.

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.