Razorpay Interview Questions, Process, and Tips

Q1. Types of join in SQL
Ans. 
Types of join in SQL include inner join, outer join (left, right, full), cross join, and self join.
• Inner join: returns rows when there is a match in both tables

• Outer join: returns all rows from one table and matching rows from the other table

• Cross join: returns the Cartesian product of the two tables

• Self join: joins a table with itself
Answered by AI
Add your answer
Q2. 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 leaves gaps between ranks if there are ties, while dense rank does not

• Rank(1, 2, 2, 3) would result in 1, 2, 4, 3

• Dense Rank(1, 2, 2, 3) would result in 1, 2, 2, 3
Answered by AI
View 2 more answers

Was asked to create a UI component keeping in mind scalability and reuseability.

General discussion about resume and projects, and then some basic JS coding questions like implement throttling and memoization.

Q1. Discussion about past experiences and projects
Add your answer
Q2. Why you want to leave current job.
Add your answer
Q3. Expectations from the role and company
Add your answer

Q1. Questions on joins and window functions in SQL
Add your answer
Q2. Basic operations on dataframe in Python. E.g.: how would you compute a moving average
Add your answer
Q3. Questions on A/B testing experience from resume. Explain the complete process followed to conduct an A/B test
Add your answer

Q1. Tell me about your self
Ans. 
I am a detail-oriented operations analyst with a strong background in data analysis and process improvement.
• I have a Bachelor's degree in Business Administration with a focus on operations management.

• I have experience using data analysis tools such as Excel, SQL, and Tableau.

• I have successfully implemented process improvements that resulted in cost savings for my previous employer.

• I am skilled at identifying inefficien...read more
Answered by AI
Add your answer
Q2. Why are you leaving your current organisation
Ans. 
Seeking new challenges and growth opportunities
• Looking for a new challenge to further develop my skills

• Seeking opportunities for career advancement

• Interested in exploring new industries or sectors

• Current organization lacks growth opportunities
Answered by AI
Add your answer
Q3. Are you a immediate joiner
Ans. 
Yes, I am available to join immediately.
• I am available to start immediately

• I can join as soon as required

• I have no notice period to serve
Answered by AI
Add your answer
Q4. Why are interested in this role
Ans. 
I am interested in this role because of my passion for analyzing data and optimizing operations.
• Passion for analyzing data and identifying trends

• Desire to optimize processes and improve efficiency

• Excitement for working in a dynamic and fast-paced environment
Answered by AI
Add your answer
Q5. Are you comfortable in Hindi
Ans. 
Yes, I am comfortable in Hindi and can communicate effectively in the language.
• I am fluent in Hindi and can speak, read, and write in the language.

• I have previous experience working in a Hindi-speaking environment.

• I am comfortable conducting business conversations in Hindi.
Answered by AI
Add your answer