Razorpay Assistant Business Manager Interview Questions and Answers

I had a very bad interview experience. The interviewer didn't start with any introduction and immediately jumped into asking case study. After giving a case, he would leave for a few minutes, which made it seem like he was not interested in the process.

Questions asked:
Q1: You are an Analyst at UBER. The gross cab cancellation rate daily is 5% whereas on a particular day, it goes up to 10%. What could be the factors affecting the same?
To analyze the same list down the tables required in the database along with all the columns and write the query using the same table name & columns to find the required metrics.

Q2: Assume you work for YouTube Music and the CEO wants you to create a Business Health Dashboard. List down all the metrics the CEO will be interested in looking at.

Q1. A tough sql question
Add your answer

Q1. Joins outputs for various types of joins
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FU...read more
Answered by AI
Add your answer
Q2. Query using window functions
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations on a set of rows related to the current row.

• They allow you to perform calculations like ranking, moving averages, and cumulative sums.

• Examples of window functions include ROW_NUMBER(), RANK(), and SUM() OVER().
Answered by AI
Add your answer

Q1. SQL Queries for JOINS
Ans. 
SQL queries for JOINS
• Use INNER JOIN to retrieve rows from both tables that have matching values

• Use LEFT JOIN to retrieve all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to retrieve all rows from the right table and the matched rows from the left table

• Use FULL JOIN to retrieve rows when there is a match in either table
Answered by AI
Add your answer
Q2. QUERY FOR metrics given in the sheet
Ans. 
The query is asking for metrics provided in a specific sheet.
• Identify the specific sheet being referred to in the question

• Review the metrics listed in the sheet

• Analyze the relevance of each metric to the query
Answered by AI
Add your answer

This is a case study round revolve around a business problem in which we have to analyse data driven solutions.

Data Representation, Logical Reasoning

Q1. Why do you want to join HighRadius?
Add your answer

Q1. Tell me something about yourself
Add your answer

Q1. HR called me and discussed
Add your answer
Q2. Work experience and ask me for back finance and bank detail
Add your answer

Case studies about Navi UPI

Case studies about Navi UPI App

Q1. Current CTC, Preferred location
Ans. 
Current CTC and preferred location are confidential information.
• Current CTC and preferred location are personal and confidential details.

• It is common practice not to disclose current CTC during interviews.

• Preferred location may vary based on individual circumstances and preferences.
Answered by AI
Add your answer

Q1. About yourself, projects worked, sql questions, Python questions
Add your answer