I applied through a recruiter. I interviewed at Airbnb in May 2024
Interview
Started with a hackerrank online test, 4 sql questions and 1 programming question in an hour. Needed 100% to move on to the onsite.
Onsite was five rounds, 1 behavior, 1 programming, 1 system, 1 "data modeling" (but was really a sql round), 1 pure SQL round.
Interview questions [5]
Question 1
Given a list of attributes and graph of relationships, compute the total list of properties for each node in the graph.
The data modeling round was about designing the schema for two tables, one to represent individual bookings and one to represent the properties being booked, and then writing queries off of them.
The systems design question was weird. The interviewer basically spec'd out a full system of a SQL dump into Hive into daily partitions and gave me the two tables and the query they wanted to run as an ETL.
First round of interview is takehome Hackerank with 3-4 SQL + 2 Python coding question.
Next is final round interview - Virtual onsite of five rounds: coding with DSA, general coding, data modeling, behaviorial question, E2E system design.
Interview questions [1]
Question 1
Take home Hackerank with 3-4 SQL + 2 Python coding question.
Virtual onsite of five rounds: coding with DSA, general coding, data modeling, behaviorial question, E2E system design.
