Uber Interview Questions, Process, and Tips

Q1. Competency based question and followed with some situational / role-based questions
Add your answer

Situation based to solve a real wold problem

Presentation round with a panel

Round duration - 60 minutes
Round difficulty - Easy

Timing: 8:00-9:00 PM
There was 1 MCQ and 3 SQL queries. The platform was easy to use and navigate.

Q1. 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.
Ans. 
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.
Answered by CodingNinjas
View 1 more amswer
Q2. 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 t...read more
Ans. 
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.
Answered by CodingNinjas
Add your answer
Q3. 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.
Ans. 
I did not have enough time to think about this question, and could not solve it. I submitted a blank response for this question.
Answered by CodingNinjas
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

Timing: 11 AM-11:30 AM
The interviewer was very kind and helpful. He helped me by giving hints whenever I was stuck.

Q1. 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...read more
Ans. 
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.
Answered by CodingNinjas
Add your answer
Q2. 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...read more
Ans. 
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'.
Answered by CodingNinjas
Add your answer
Q3. 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...read more
Ans. 
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.
Answered by CodingNinjas
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

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.

Q1. 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...read more
Ans. 
Tip 1 : Clarify the question properly if you have any doubts
Tip 2 : Try to think of out of the box solutions
Answered by CodingNinjas
Add your answer
Q2. Puzzle Question
What new feature would you like to add in Uber?
Ans. 
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
Answered by CodingNinjas
Add your answer

Round duration - 30 minutes
Round difficulty - Hard

Timing: 3:00PM to 3:30PM
This was Hiring Manager round. He asked me case study type of questions.

Q1. Puzzle Question
How would you predict which user is likely to churn in the next 1 month? What variables would you consider for this?
Ans. 
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.
Answered by CodingNinjas
Add your answer

Q1. Hr round is good
Add your answer
Q2. About pacakge and job role and background
Add your answer
Q3. Uber good or bad
Add your answer
Q4. Employees good or bad
Add your answer
Q5. What about team
Add your answer

Coding test are defulct and good

Case study on business process

Q1. Understanding of the business metrics. People management questions. Operational excellence questions
Add your answer
Q2. People Management questions
Add your answer
Q3. Operational excellence questions
Add your answer
Q4. Team management
Add your answer

SQL and Math are judged in this round

Analytical and Presentation skills are judged in this round

Q1. Stakeholder management, situational questions, STAR methodology
Add your answer