Uber interview experience Real time questions & tips from candidates to crack your interview
Data Science Intern
Uber
4 rounds | 9 Coding
problems
Selected Interview preparation journey
Preparation
Duration: 3.5 months
Topics: Machine Learning Algorithms, SQL Queries, Python, Data Mining, Data Visualization, Descriptive and Inferential Statistics, Random Variables and Probability Distributions.
Tip 1 : Practice SQL and python coding questions using online coding platforms.
Tip 2 : Get in-depth theoretical knowledge about all the machine learning algorithms.
Tip 3 : Strengthen your statistics understanding.
Application process
Where: Campus
Eligibility: No criteria
Tip 1 : Highlight your skills properly
Tip 2 : Have thorough understanding about everything written in the resume
Interview rounds
01
Round
Easy
Online Coding Interview
Duration60 minutes
Interview date6 Dec 2021
Coding problem3
Timing: 8:00-9:00 PM
There was 1 MCQ and 3 SQL queries. The platform was easy to use and navigate.
1. SQL Question
A table containing the details of all the drivers, and another table containing the details of trips is provided. Query the name of drivers that have taken at least 1 trip.
Problem approach
Step 1 : I performed inner join on the 2 tables on the driver_id key.
Step 2 : Then I selected the distinct driver_name 's from the joined table.
Step 3 : This query was satisfying all the 5 test cases.
2. SQL Question
A table containing the details of all the drivers, and another table containing the details of trips is provided. Query the name and number of trips taken by each driver which has rating more than 4.
Problem approach
Step 1 : I performed inner join on the 2 tables on the driver_id key.
Step 2 : Then I performed group by on the driver_id, and selected the name and COUNT(trip_id). I filtered out the trips with rating less than 4 by using "WHERE trip_rating>4".
Step 3 : This query was satisfying all the 5 test cases.
3. SQL Question
A table containing the details of Uber employees were provided. I had to query the maximum number of employees that worked in the company during each employee's tenure.
Problem approach
I did not have enough time to think about this question, and could not solve it. I submitted a blank response for this question.
02
Round
Medium
Video Call
Duration30 minutes
Interview date9 Dec 2021
Coding problem3
Timing: 11 AM-11:30 AM
The interviewer was very kind and helpful. He helped me by giving hints whenever I was stuck.
1. SQL Question
User table containing user_id, ph_no, email_id, signup_city, banned, role, timestamp and trips table containing trip_id, client_id, driver_id, city_id, product_id, request_at, status={completed,rider_cancelled, driver_cancelled}was provided. Find the number of trips in January 2021.
Problem approach
Step 1 : Get the month and year from the request_at variable which is in timestamp format.
Step 2 : Select COUNT(trip_id) to get the number of trips
Step 3 : Put the WHERE condition to get only the trips of January 2021.
2. SQL Question
User table containing user_id, ph_no, email_id, signup_city, banned, role, timestamp and trips table containing trip_id, client_id, driver_id, city_id, product_id, request_at, status={completed,rider_cancelled, driver_cancelled}was provided. Find the total number of trips taken by users whose role is RIDER.
Problem approach
Step 1 : Join the 2 tables on trips.client_id=User.user_id
Step 2 : Select COUNT(DISTINCT trip_id) to get the number of trips
Step 3 : Put the WHERE condition to get only the trips where user has role='RIDER'.
3. SQL Question
User table containing user_id, ph_no, email_id, signup_city, banned, role, timestamp and trips table containing trip_id, client_id, driver_id, city_id, product_id, request_at, status={completed,rider_cancelled, driver_cancelled}was provided. Find the proportion of unfulfilled trip in January 2021.
Problem approach
Step 1 : Join the 2 tables on trips.client_id=User.user_id
Step 2 : Use CASE WHEN statement to get 0 and 1 for successful and unsuccessful trips respectively.
Step 3 : Take ratio of unsuccessful trip by total trips to get the proportion of unsuccessful trips.
Step 4 : Get the month and year from the request_at variable which is in timestamp format.
Step 5 : Put the WHERE condition to get only the trips of January 2021.
03
Round
Medium
Video Call
Duration30 minutes
Interview date9 Dec 2021
Coding problem2
Timing: 12:15 PM to 12:45 PM.
The interviewer was very helpful and friendly. He was more interested in my approach rather than the final answer.
1. Puzzle Question
In a bank, suppose there are 5 counters. Which approach mentioned below is better?
1) The new customer goes to whichever counter has a smaller queue
2) Each counter has a specific purpose (e.g., cash withdrawal, cash deposit, cheque, passbook update, etc), and the new customer goes to the queue of the counter that best serves his purpose.
Problem approach
Tip 1 : Clarify the question properly if you have any doubts
Tip 2 : Try to think of out of the box solutions
2. Puzzle Question
What new feature would you like to add in Uber?
Problem approach
Tip 1 : Creativity has no limit in such questions
Tip 2 : Suggest any of the dreams that you would like to see in your dream company
Tip 3 : I suggested ideas such as Uber Ambulance, Uber Flights, etc
04
Round
Hard
Video Call
Duration30 minutes
Interview date9 Dec 2021
Coding problem1
Timing: 3:00PM to 3:30PM
This was Hiring Manager round. He asked me case study type of questions.
1. Puzzle Question
How would you predict which user is likely to churn in the next 1 month? What variables would you consider for this?
Problem approach
Tip 1 : Thoroughly understand the question
Tip 2 : Ask questions about the existing approach that is used by the company
Tip 3 : Try to answer from a technical, as well as business point of view.
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
Which operator is used for exponentiation in Python?
Choose another skill to practice
Similar interview experiences
SDE - 1
2 rounds | 4 problems
Interviewed by Uber
Rejected
959 views
0 comments
0 upvotes
SDE - 1
3 rounds | 5 problems
Interviewed by Uber
Selected 3284 views
0 comments
0 upvotes
SDE - Intern
2 rounds | 5 problems
Interviewed by Uber
Selected 587 views
0 comments
0 upvotes
Software Engineer
3 rounds | 7 problems
Interviewed by Uber
Selected 1458 views
0 comments
0 upvotes