Uber Senior Analyst Interview Questions and Answers

Versant test English skills

Q1. Explain about O2c cycle
Ans. 
O2c cycle refers to the order to cash cycle which involves all the processes from receiving an order to receiving payment.
• The cycle starts with receiving an order from the customer

• The order is then processed and the product is shipped to the customer

• An invoice is generated and sent to the customer

• The customer makes the payment and the payment is recorded

• The cycle ends with the reconciliation of accounts
Answered by AI
Add your answer

Q1. Difference Between Rank and Dense Rank
Ans. 
Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.
• Rank does not skip ranks when there are ties, while Dense Rank does

• Rank will have gaps in ranks if there are ties, while Dense Rank will not

• Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row
Answered by AI
Add your answer
Q2. Some Basic Joins
Add your answer
Q3. Socks Pair Puzzle Qustions
Add your answer

The questions were related to Data Interpretation/Logical Reasoning and general aptitude.

Q1. Questions related to SQL queries, window functions, 2-3 sql queries had to write
Add your answer
Q2. Statistics related questions, left skewed, right skewed etc.
Add your answer
Q3. Questions related to basics of ML
Add your answer

A company wants to open a new store, what would the factors you would consider.
A ride sharing company wants dynamic pricing in place of flat pricing, what factors you would consider.

Q1. General Project and HR related questions.
Add your answer
Q2. Things you want to improve in swiggy and metrics to measure and evaluate them.
Add your answer

GD COMMON TOPIC WAS DISCUSSED

Q1. TELL ABOUT YOURSELF , SKILLSETS YOU BRING TO THE TABLE
Add your answer

Q1. EXPECTED INCOME , RELOCATION PREFERENCE
Add your answer

Q1. All related to manual testing
Add your answer

Q1. 1. Related to Manual Testing
Add your answer

Q1. Manual testing, java
Add your answer

Q1. All fake build ups
Ans. 
Fake build ups refer to false claims or exaggerations made about a product or service.
• Fake build ups can mislead customers and damage the reputation of a company.

• Examples include exaggerated claims about the effectiveness of a product or false testimonials from supposed satisfied customers.

• Quality analysts play a crucial role in identifying and rectifying fake build ups to ensure transparency and trustworthiness.
Answered by AI
Add your answer

Q1. Guesstimators,puzzle
Add your answer
Q2. Puzzle.guesstimators
Add your answer

Q1. Normal verification
Add your answer

Q1. Questions related to sql
Add your answer
Q2. Windows function in sql
Ans. 
The Windows function in SQL is used to perform calculations on a specific subset of rows in a result set.
• The Windows function is used with the OVER clause to define the subset of rows to perform calculations on.

• Common Windows functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.

• Example: SELECT ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS row_num FROM employees;
Answered by AI
Add your answer

Q1. Interview with stakeholders
Add your answer

Q1. What was your previous process and how would it help solve a problem we have at Airbnb?
Add your answer
Q2. Explain a situation where u failed to take a decision and how did you tackle such scenario based on your current role?
Add your answer
Q3. Best hosting experience received and what made it special?
Add your answer