Top 38

Prep plan

Updated weekly · Last refresh Oct 17

Airbnb Data Engineer Interview Questions

The questions to prepare for a Airbnb Data Engineer interview. Questions from real interview reports rank first. Updated daily.

38questions

~8htotal time

Track your progressSign up free to work through all 38 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 14 questions · ~172 min

First-Time Bookings Monthly ReportMedium

Practice

Build a parameterized monthly booking report with total bookings, unique users, and first-time users, including empty months.

Date FunctionsCTEsAggregations

Airbnb

Holiday-Reservations MetricsHard

Practice

Calculate first-time guests, rolling cancellations, and the busiest season from resort bookings.

Date FunctionsCTEsAggregations

Airbnb

More SQL & Data Manipulation questions with a free account

Coding7 questions · ~86 min

Median of Two Sorted ArraysHard

Practice

Find the median of two sorted arrays using binary search over the shorter array in logarithmic time.

binary searchArraysAlgorithms

Airbnb

Friendship-Based City RecommendationsMedium

Practice

Use sets and adjacency mapping to recommend unique cities from friends' wishlists while excluding the user's saved cities.

deduplicationaggregationArrays

Airbnb

More Coding questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan

System Design4 questions · ~49 min

Iterative Data Model for MarketplaceHard

Build an Airbnb marketplace data model iteratively and write SQL for five business issues.

database accessiterative reasoningdesign

Airbnb

Query Execution InternalsHard

Explain how a backend query is parsed, optimized, executed, and monitored across storage and distributed execution layers.

latencydatabase accessdistributed systems

Airbnb

More System Design questions with a free account

Pipelines6 questions · ~74 min

ETL From SQL Dump to HiveHard

Design a repeatable ETL pipeline that loads two SQL dump tables into daily-partitioned Hive tables and supports the target query.

data loadingsystem designETL

Airbnb

Scalable Data Lake Storage LayerHard

Design a tiered data lake that preserves cold historical data while supporting fast interactive queries.

scalabilitydata architectureCloud

Airbnb

More Pipelines questions with a free account

Behavioral & Leadership7 questions · ~86 min

More Behavioral & Leadership questions with a free account

The finish line: interview-readyComplete all 38 questions to finish this plan.