The process started with an online HackerRank test, consisting of four SQL questions and one programming question to be completed within an hour. A perfect score of 100% was required to advance to the onsite interview.
The onsite interview comprised five rounds:
Given a list of attributes and a graph of relationships, compute the total list of properties for each node in the graph.
The data modeling round involved designing the schema for two tables: one to represent individual bookings and one to represent the properties being booked. Then, queries were written off of them.
Behavioral round featured classic questions about past projects, difficult times, etc.
The systems design question was unusual. The interviewer essentially specified a full system involving a SQL dump into Hive with daily partitions. They provided two tables and the query they wanted to run as an ETL.
The SQL round was a miscellaneous gauntlet of joins, with another five questions in an hour.
The following metrics were computed from 1 interview experience for the Airbnb Senior Data Engineer role in United States.
Airbnb's interview process for their Senior Data Engineer roles in the United States is extremely selective, failing the vast majority of engineers.
Candidates reported having very negative feelings for Airbnb's Senior Data Engineer interview process in United States.