Uber
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Clear (1)
I applied via Campus Placement and was interviewed in Aug 2023. There were 3 interview rounds.
Aptitude Test had questions on sql, analytic ques, case study ques on uber
SQL joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.
SQL joins are used to retrieve data from multiple tables based on a related column between them (e.g. INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN).
Window functions are used to perform calculations on a set of rows related...
Answering SQL queries in an interview for Data Analyst Intern position
Understand the database schema and tables involved
Use SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY clauses
Practice writing queries for common data analysis tasks like filtering, aggregating, and joining tables
Here they given three case study questions of uber where they would like to check you analytic behavior, they want to know how would you use the data to solve such a problem.
Top trending discussions
I applied via LinkedIn and was interviewed in Sep 2020. There was 1 interview round.
Sharing data insights can help improve services and identify revenue opportunities.
Analyzing customer behavior can help identify areas for improvement
Identifying trends in sales data can help optimize pricing strategies
Using data to personalize marketing efforts can increase customer engagement
Predictive modeling can help identify potential revenue opportunities
Tracking key performance indicators can help optimize busi
I applied via Referral and was interviewed before Aug 2022. There were 2 interview rounds.
Setting up a Dark Store involves converting a retail store into a fulfillment center for online orders.
Select a suitable location for the Dark Store, preferably in a centralized area with good access to transportation.
Optimize the layout of the store for efficient picking, packing, and shipping of orders.
Implement inventory management systems to track stock levels accurately and prevent stockouts.
Train staff on order f...
Joins combine data from two or more tables based on a related column.
Joins are used to retrieve data from multiple tables based on a related column
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
The order of execution in a query determines the sequence in which operations are performed.
1. The order of execution in a query typically follows the sequence: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
2. The FROM clause specifies the tables involved in the query.
3. The WHERE clause filters the rows based on specified conditions.
4. The GROUP BY clause groups the rows that have the same values into summary rows.
5...
Group By is used to aggregate data based on a specific column, while Distinct is used to remove duplicate rows from a result set.
Group By is used with aggregate functions like COUNT, SUM, AVG, etc.
Distinct is used to retrieve unique values from a column or set of columns.
Group By can be used to group data based on multiple columns, while Distinct operates on individual columns only.
I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.
Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing
1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day
Duration - 1hr, Mostly questions are from Excel and SQL ( But a little knowledge of R and Python is very useful) .For me, it's knowing the concepts and answering no codes were ask to write.
I was interviewed in Aug 2024.
Calculate the number of rows after joining two datasets.
Count the number of rows in each dataset
Perform the join operation
Count the number of rows in the resulting dataset
Use Excel's text to columns feature to split person names into separate columns.
Select the column containing the full names
Go to the Data tab and click on Text to Columns
Choose 'Delimited' and select the delimiter that separates the names (e.g. space)
Click Finish to split the names into separate columns
I applied via Referral and was interviewed in Oct 2021. There was 1 interview round.
I applied via Job Portal and was interviewed in Jun 2023. There were 3 interview rounds.
Aptitude test is a way for employers to assess a candidate's abilities through a variety of different testing formats. Aptitude tests will test your ability to perform tasks and react to situations at work. This includes: problem-solving.
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
I applied via Company Website and was interviewed in Jul 2023. There were 4 interview rounds.
Number sires, clock, logic, arithmetic, geometry
Code test basic, ans the basic knowledge, write code
Python is a high-level programming language known for its simplicity and readability.
Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.
It emphasizes code readability and uses indentation to define code blocks.
Python has a large standard library and a vibrant community of developers.
Example: print('Hello, World!')
Example: import pandas as pd
Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.
Data analysis and visualization
Web development (Django, Flask)
Artificial intelligence and machine learning (TensorFlow, PyTorch)
Automation and scripting
Scientific computing (NumPy, SciPy)
Python is a high-level programming language known for its simplicity and readability.
Python is an interpreted language, meaning it does not need to be compiled before running.
It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.
Python has a large standard library and a thriving community, making it versatile and widely used.
Example: Python is used for web develop...
Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.
OOP allows for the organization of code into reusable components called classes.
Classes can have attributes (variables) and methods (functions) associated with them.
In Python, everything is an object, and classes can be defined using the 'class' keyword.
Encapsulation, inheritance, and polymorph
An array in Python is a data structure that stores a collection of elements of the same type.
Arrays can store elements such as integers, floats, or strings.
Arrays are indexed starting from 0, with elements accessed using their index.
Example: arr = ['apple', 'banana', 'cherry']
based on 1 interview
Interview experience
Driver
585
salaries
| ₹0 L/yr - ₹0 L/yr |
CAR Driver
361
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
161
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
135
salaries
| ₹0 L/yr - ₹0 L/yr |
Operations Executive
135
salaries
| ₹0 L/yr - ₹0 L/yr |
Amazon
Ola Cabs
Airbnb