Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Uber interview experience Real time questions & tips from candidates to crack your interview

# Data Science Intern

Uber
4 rounds | 9 Coding problems

## 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

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
Resume tip

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 t...

View more
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

Minimum number of operands are required to use relational operators?

Start a Discussion
Similar interview experiences
SDE - 1
2 rounds | 4 problems
Interviewed by Uber
650 views
SDE - 1
3 rounds | 5 problems
Interviewed by Uber
1478 views