Razorpay Senior Analyst Interview Questions and Answers

Visualisation assessment

Q1. Puzzle questions
Add your answer
Q2. SQL QUESTION and
Add your answer

Q1. Brief about previous job
Ans. 
I worked as a Senior Analyst at a financial services firm, analyzing market trends and providing insights for investment decisions.
• Analyzed market trends to identify investment opportunities

• Provided insights and recommendations for investment decisions

• Collaborated with team members to develop financial models

• Presented findings to senior management and clients

• Utilized data analysis tools such as Excel and Bloomberg Term
Answered by AI
Add your answer

Quantitative aptitude, verbal ability, critical reasoning

Q1. SQL: find store with highest AOV
Add your answer
Q2. Generic behavioural questions
Add your answer

General SQL Question

Q1. General puzzle questions from GFG
Add your answer
Q2. Normal interview level SQL Question
Add your answer

Q1. There were lot of behavioral questions
Add your answer
Q2. Then there were few questions related to how to navigate through the data
Add your answer

Q1. SQL Joins and remove duplicates
Add your answer
Q2. Function to create a transaction bin column
Add your answer

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. Are you kannadiga?
Add your answer
Q2. Can you turn analytics team into operational?
Ans. 
Yes, by aligning team goals with operational objectives, providing necessary resources, and implementing efficient processes.
• Align team goals with operational objectives to ensure focus on key priorities

• Provide necessary resources such as training, tools, and technology to support team's operational tasks

• Implement efficient processes and workflows to streamline operations and maximize productivity
Answered by AI
Add your answer
Q3. Can you talk a lot in meetings irritating others?
Add your answer

Q1. We don't need technical as all we need is copy paste
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