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.
Questions d'entretien [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.
J'ai postulé via un recruteur. J'ai passé un entretien chez Airbnb en mai 2024
Entretien
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.
Questions d'entretien [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.