Airbnb
Online marketplace for lodging with strong data science and infrastructure.
4 Rounds
~21 Days
Hard
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Scientist
•
Coding
•
medium
Given a 'searches' table and a 'bookings' table, write a SQL query to calculate the search-to-booking conversion rate for each city over the past 30 days, considering only searches that resulted in a booking within 7 days of the search.
#Joins
#Date Functions
#Aggregations
#Conversion Rate
Data Scientist
•
Coding
•
hard
Write a SQL query to find all hosts who have had 3 or more consecutive cancelled bookings. You are given a 'bookings' table with booking_id, host_id, created_at, and status ('completed', 'cancelled').
#Window Functions
#Gaps and Islands
#Advanced SQL
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.