practice a little every day, paws crossed ♡
Data Engineer Interview Questions
Practice 9403 coding, system design and machine learning questions from 546 companies, sorted by role, topic and interview round. Every question has step-by-step hints, a code runner that supports 8 languages and an AI mentor; members also get the full solution walkthrough.
- 9403
- Questions
- 546
- Companies
- 11
- Topics
- 8
- Languages
Showing 1–6 of 6 results
- AirbnbMediumData EngineerCalculate the Median House Price in Each City
Tests your ability to compute grouped medians in PostgreSQL, properly handling even and odd row counts, duplicate price values, and numeric precision.
Data Manipulation (SQL/Python)Onsitesqlpostgresqlaggregations - AirbnbMediumData EngineerEstimate Page-Visit Duration from the Next User Event
Implement logic to compute user page-visit durations based on adjacent event timestamps, deterministically resolving ties and handling boundary conditions for terminal events.
Data Manipulation (SQL/Python)Onsitepythonsqldata-manipulation - AirbnbMediumData EngineerFind Hosts Meeting Listing, Rating, and Review-Coverage Rules
Tests the ability to write a SQL query performing multi-table aggregations, date-windowed conditional logic, and host-level qualification filtering across listing counts, average ratings, and recent review coverage.
Data Manipulation (SQL/Python)Onsitesqlaggregationconditional-logic - AirbnbMediumData EngineerFind Users with Seven Consecutive Impression Days
Tests your ability to identify consecutive calendar-day activity streaks in PostgreSQL using window functions, date arithmetic, and deduplication.
Data Manipulation (SQL/Python)Onsitesqlpostgresqlwindow-functions - MetaMediumData EngineerRecommend two-hop follows in Python
This question evaluates fluency with graph traversal, set operations, deduplication, and frequency-based ranking in Python, targeting manipulation of directed "follows" relationships represented as dictionaries and is categorized under Data Manipulation (SQL/Python).
Data Manipulation (SQL/Python)Onsite - MetaMediumData EngineerReturn top-3 content per category
This question evaluates the ability to perform grouped top-k selection, deterministic tie-breaking and ordering, and to reason about algorithmic efficiency when manipulating structured datasets in the Data Manipulation (SQL/Python) domain for a Data Engineer role.
Data Manipulation (SQL/Python)Onsite
Airbnb
Meta