Uber Interview Questions, Process, and Tips

Aptitude Test had questions on sql, analytic ques, case study ques on uber

Q1. What are Sql joins, window functions
Ans. 
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...read more
Answered by AI
Add your answer
Q2. Write sql queries
Ans. 
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
Answered by AI
Add your answer
Q3. Given 5L and 3L jar. How will you make it 4L (Logical thinking)
Add your answer
Q4. Questions on resume projects
Add your answer
Q5. Questions on excel functions
Add your answer

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.

Question on Bellman Ford Algorithm

Python, SQL, Quant, Statistics, Numpy

Q1. SQL, Python, Puzzle total 9Q
Add your answer
Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
Add your answer

Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
Add your answer

Q1. Questions mostly focused on window functions like row_number and aggregate functions like group by there was also a question based on self-join.
Add your answer