Expedia Group Data Engineer Interview Guide
The Expedia Group data engineer loop, round by round: what each stage tests, example questions with the guidance interviewers actually score, the mistakes that sink strong candidates, and how to prepare.
What the Expedia Group loop tests: domains and difficulty
Our prediction of the question mix by domain and difficulty for this company's data engineer loop, from live listings and interview reports.
The domain and difficulty mix we predict for a Expedia Group data engineer loop, across 14 problems. It updates as more Expedia Group data lands.
7 real Expedia Group interview questions
Reported by candidates from real loops, tagged by domain, round, level, and year. Expand for what the round is scoring.
SQLL5 · 2025Get a list of all customers, their total number of trips booked, and the average ratingOnsite · sql+
Schema: customer(customer_id, first_name, last_name, email), booking(booking_id, customer_id, hotel_id, booking_date, stars). JOIN customer to booking on customer_id, GROUP BY customer fields, use COUNT(*) for trips and AVG(stars) for rating, ORDER BY total trips descending.
PythonL4 · 2024Generate unique identifiers for IoT devices by appending numbers on conflictsOnline assessment+
Given an array of device names like ["tv","fridge","microwave","tv","microwave","tv","fridge"], return ["tv","fridge","microwave","tv1","microwave1","tv2","fridge1"]. Track seen names with a dictionary counting occurrences. On conflict, append the current count. From Round 1 coding assessment (100 minutes, 3 problems).
PythonL4 · 2024Given an input string, write a function that returns the Run Length Encoded stringOnline assessment+
Example: input "wwwwaaadexxxxxx" returns "w4a3d1e1x6". Iterate through the string tracking consecutive character runs. For each run, append the character followed by its count. From Round 1 coding assessment (100 minutes, 3 problems) at Expedia Group Data Engineer interview.
PythonL4 · 2022a factorial questionPhone screen · screen sql+
PythonL4 · 2022top k frequent elementsPhone screen · screen sql+
PythonL5 · 2017Local minima in treesPhone screen · screen sql+
PythonL5 · 2017sorting million numbersPhone screen · screen sql+
How candidates rate the Expedia Group loop
How hard candidates rated the loop and how they felt, summarized across the reports below.
6 rated reports
2 rated Expedia Group reports
Try a Expedia Group-style SQL round
Find every user active on 3 or more CONSECUTIVE days. This gaps-and-islands shape shows up in nearly every DE SQL round. Edit the query and run it against the seed data.
Practice the Expedia Group loop
The problems our model expects in this company's interview, grouped by round. Work the shapes that come up, not the ones that read well on a list.
Expedia Group is hiring data engineers now
The roles behind this loop. Prep against the levels and locations they are actually filling.
Design, build, and evolve maintainable, scalable, testable, and observable software for our data lake platform.
Design, build, and maintain scalable batch and near real-time data pipelines and data products that support analytics, reporting, and downstream business use cases.
Expedia Group compensation and culture
The numbers, tech stack, and team structure live on the company overview.
Compare Expedia Group with other data engineering employers
How the role, pay, and loop stack up against peer companies.
Prepare at Expedia Group interview difficulty
- 01
Reading a solution is not the same as writing one
Every engineer who has frozen on a query they had read a dozen times knows the gap. The only preparation that closes it is producing the answer yourself, under time, before the interview does it for you
- 02
76% of hiring managers reject on the coding task, not the resume
From HackerRank's 2024 Developer Skills Report. Candidates who look strong on paper still fail the live screen if they haven't done timed, executable practice
- 03
5 problem shapes cover 80% of data engineer loops
Dedup, sessionization, top-N-per-group, slowly-changing dimensions, partition tricks. Writing the shapes by hand turns the unfamiliar into pattern recognition