Uber
Ride-hailing and delivery platform with massive real-time data challenges.
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 Engineer
•
Coding
•
medium
Write a SQL query to find the top 3 drivers by total earnings in each city over the last 30 days. Only include completed trips and account for potential ties in earnings.
#Window Functions
#Aggregations
#Date/Time Functions
Data Engineer
•
Coding
•
medium
Write a SQL query to calculate the rolling 7-day average of canceled rides per rider. The output should include the rider_id, date, and the 7-day moving average.
#Window Functions
#Moving Averages
#Time Series
Data Engineer
•
Coding
•
medium
Write a SQL query to find riders who have taken both an UberX ride and placed an Uber Eats order within the exact same 24-hour window.
#Joins
#Date/Time Math
#Correlated Subqueries
Data Scientist
•
Coding
•
medium
Write a SQL query to find the 7-day rolling average of driver cancellation rates for each city. Assume you have a trips table with trip_id, city_id, driver_id, status (completed, cancelled_by_driver, cancelled_by_rider), and request_timestamp.
#Window Functions
#Rolling Averages
#Aggregations
Data Scientist
•
Coding
•
medium
Write a SQL query to identify riders who have taken a trip in at least 3 different cities within a 30-day window.
#Self Joins
#Date Functions
#COUNT DISTINCT
Product Manager
•
Coding
•
medium
Given two tables, 'trips' and 'drivers', write a SQL query to find the top 5 cities with the highest driver cancellation rates over the last 30 days, considering only cities with at least 100 total trips.
#Joins
#Aggregations
#Filtering
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.