Premium Employer

i

This company page is being actively managed by Razorpay Team. If you also belong to the team, you can get access from here

Razorpay Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Razorpay Data Analyst Interview Questions and Answers

Updated 1 Jan 2025

Razorpay Data Analyst Interview Experiences

3 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 1 Jan 2025

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Aptitude Test 

It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 28 Apr 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Mar 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Detailed discussion on past experience and projects.
Round 3 - Technical 

(2 Questions)

  • Q1. 2 Hackerrank SQL Questions
  • Q2. 1 Hackerrank Python Question

Interview Preparation Tips

Topics to prepare for Razorpay Data Analyst interview:
  • SQL
  • Python
Interview preparation tips for other job seekers - Deep knowledge of SQL and Python is required along with Data Analysis fundamentals.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Data Analyst Interview Questions & Answers

user image sahithi reddy

posted on 22 Mar 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. What is the order of execution in sql
  • Ans. 

    The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

    • 1. FROM: Specifies the tables involved in the query.

    • 2. WHERE: Filters the rows based on specified conditions.

    • 3. GROUP BY: Groups the rows that have the same values into summary rows.

    • 4. HAVING: Filters groups based on specified conditions.

    • 5. SELECT: Selects the columns to be included in the result set.

    • 6. ORDER BY: Sorts the result set base

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. How to do conditional formatting in excel
  • Ans. 

    Conditional formatting in Excel allows users to format cells based on specified conditions.

    • Select the range of cells you want to apply conditional formatting to

    • Go to the 'Home' tab and click on 'Conditional Formatting'

    • Choose the desired formatting option, such as color scales, data bars, or icon sets

    • Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be through with basics

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

5 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.

    • Experienced in using statistical analysis tools such as Python, R, and SQL

    • Proficient in data visualization tools like Tableau and Power BI

    • Skilled in data cleaning, data mining, and data modeling techniques

    • Strong problem-solving and critical thinking skills

    • Effective communicator and team player

    • Example: I have w...

  • Answered by AI
  • Q2. Biggest hurdle you faced during the work you did t organise the tech fest of your college
  • Ans. 

    The biggest hurdle I faced during organizing the tech fest of my college was securing sponsorships.

    • Difficulty in convincing companies to sponsor the event

    • Limited budget for organizing a large-scale tech fest

    • Competition with other college events for sponsorships

    • Negotiating sponsorship deals and ensuring deliverables

    • Finding sponsors aligned with the theme and objectives of the tech fest

  • Answered by AI
  • Q3. Would you go for an MBA?
  • Ans. 

    Yes, pursuing an MBA can enhance my skills and open up new career opportunities.

    • An MBA can provide a strong foundation in business and management principles.

    • It can help develop analytical and problem-solving skills.

    • An MBA can broaden my network and provide access to valuable connections.

    • It can open up leadership roles and higher-level positions in organizations.

    • Having an MBA can increase earning potential and job prosp...

  • Answered by AI
  • Q4. Reliance fresh wants to open a store in north-eastern part of India. Should it or should it not?
  • Ans. 

    Yes, Reliance Fresh should open a store in the north-eastern part of India.

    • The north-eastern part of India has a growing population and increasing consumer demand.

    • Reliance Fresh can tap into the untapped market potential in the region.

    • Opening a store in the north-eastern part of India can help Reliance Fresh expand its presence and increase its market share.

    • Reliance Fresh can leverage its existing supply chain and dist...

  • Answered by AI
  • Q5. Guesstimate the number of people travelling by local metro in mumbai
  • Ans. 

    The number of people travelling by local metro in Mumbai is estimated to be in millions.

    • Mumbai has a population of over 20 million people.

    • The local metro is a popular mode of transportation in Mumbai.

    • During peak hours, the metro trains are usually crowded.

    • The metro network in Mumbai is extensive, covering various parts of the city.

    • The number of daily commuters on the metro can be estimated based on population density a

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: cpi above 7.0

Round: Test
Experience: Basic maths, shares related questions and english
Duration: 1 hour
Total Questions: 40

Round: Technical + HR Interview
Experience: Very easy round.

Skills: Aptitude, Communication, Quantitative Aptitude, Leadership Skills, Technical Skill
College Name: IIT Kanpur

Data Analyst Interview Questions & Answers

PayPal user image AKASH KUMAR SINGH

posted on 2 Dec 2016

I applied via Campus Placement and was interviewed in Dec 2016. There were 6 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. For this round he gave me lot of problems and asked to develop optimal algorithm to solve that. Problems were mainly on trees and number sequences
  • Q2. In this round he mainly discussed my projects and asked me how these can be put to use in Paypal. He also asked some basic questions from ML
  • Q3. HR round was just for formality
  • Q4. Probability , question on calculating expected number of trials and puzzles

Interview Preparation Tips

Round: Test
Experience: The coding question was:
Given a binary string containing 0's and 1's. You can split the string such that each partition should be a exponential of 5 (1,5,25,625...). You were asked to return minimum number of partition for the given string such each partition is exponential of 5. If no such partition exists return -1.
Examples: '101101101' Ans: 3 (101, 101, 101)
'111' Ans: 3 (1,1,1)
10101 Ans: -1
Tips: For MCQ's prepare DSA, OS and Networking. For DSA you can refer to cormen
For Coding question practice on either geeksforgeeks or from any of the coding platforms like hackerrank
The shortlist was mainly dependent on coding question
Duration: 1 hour 30 minutes

Round: Puzzle Interview
Tips: Do lot of puzzles from heard on the street, -----/ , Try to search for more. It will be helpful in other interviews as well

Round: Technical Interview
Tips: Practice algorithm section from geeksforgeeks. There are lot of standard problems. The given questions were slightly modified version of standard problems

Round: Technical Interview
Tips: For this round you need to be well prepared with your projects and resume.

College Name: IIT Madras
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. What techonologies do you know?
  • Ans. 

    I am proficient in SQL, Python, R, Tableau, and Excel for data analysis and visualization.

    • SQL

    • Python

    • R

    • Tableau

    • Excel

  • Answered by AI
Round 2 - Coding Test 

SQL Coding Tests. You get 3 tables and they ask you to find customer with certain conditions. Not hard

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL case study for data
  • Q2. Find nth salary
  • Ans. 

    To find the nth salary in a dataset

    • Sort the dataset in descending order based on salary

    • Remove duplicates if necessary

    • Return the salary at index n-1

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Implement lag() and lead() without using lag() or lead()
  • Ans. 

    Implement lag() and lead() functions without using lag() or lead()

    • To implement lag(), shift the values in the array by one position to the right

    • To implement lead(), shift the values in the array by one position to the left

    • For example, to implement lag() on [1, 2, 3, 4], you can shift the values to get [null, 1, 2, 3]

    • For lead(), you can shift the values to get [2, 3, 4, null]

  • Answered by AI
  • Q2. How will you go about optimising a query?
  • Ans. 

    Optimising a query involves identifying bottlenecks and improving efficiency.

    • Identify slow-performing queries using tools like query execution plans.

    • Optimize database indexes to speed up query performance.

    • Limit the number of columns and rows returned in the query.

    • Avoid using SELECT * and instead specify only the necessary columns.

    • Use appropriate data types and avoid unnecessary data conversions.

    • Consider denormalizing d...

  • Answered by AI
  • Q3. If the 3rd position in a string contains 'b' replace it with 'v'
  • Ans. 

    Replace 'b' with 'v' in the 3rd position of each string in an array

    • Iterate through each string in the array

    • Check if the 3rd position contains 'b'

    • If yes, replace 'b' with 'v'

  • Answered by AI

Skills evaluated in this interview

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. General questions and sql questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare aptitude and SQL questions and Bi tools
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Jul 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Easy questions based on Logical Reasoning, Mathematics, English

Round 2 - Group Discussion 

Be sure to put your thoughts on the topic you get, and try to put a point that meets the goals or aspirations of the company.

Round 3 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself Tell me something from your resume Desribe your project

Razorpay Interview FAQs

How many rounds are there in Razorpay Data Analyst interview?
Razorpay interview process usually has 2 rounds. The most common rounds in the Razorpay interview process are Technical, Resume Shortlist and Aptitude Test.
How to prepare for Razorpay Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Razorpay. The most common topics and skills that interviewers at Razorpay expect are SQL, Access management, Automation, Data Mining and Analytics.
What are the top questions asked in Razorpay Data Analyst interview?

Some of the top questions asked at the Razorpay Data Analyst interview -

  1. How to do conditional formatting in ex...read more
  2. What is the order of execution in ...read more
  3. 2 Hackerrank SQL Questi...read more

Tell us how to improve this page.

Razorpay Data Analyst Interview Process

based on 3 interviews

Interview experience

4.3
  
Good
View more
Join Razorpay Revolutionize the FinTech space with groundbreaking solutions
Razorpay Data Analyst Salary
based on 35 salaries
₹4 L/yr - ₹12.8 L/yr
49% more than the average Data Analyst Salary in India
View more details

Razorpay Data Analyst Reviews and Ratings

based on 5 reviews

4.5/5

Rating in categories

4.3

Skill development

4.5

Work-life balance

4.0

Salary

4.2

Job security

4.5

Company culture

3.7

Promotions

4.5

Work satisfaction

Explore 5 Reviews and Ratings
Junior Analyst
115 salaries
unlock blur

₹2.4 L/yr - ₹5.5 L/yr

Analyst
102 salaries
unlock blur

₹3.5 L/yr - ₹7.3 L/yr

Software Engineer
102 salaries
unlock blur

₹8 L/yr - ₹24 L/yr

Senior Associate
93 salaries
unlock blur

₹5.2 L/yr - ₹15 L/yr

Software Development Engineer
87 salaries
unlock blur

₹8 L/yr - ₹31.5 L/yr

Explore more salaries
Compare Razorpay with

Paytm

3.3
Compare

PayPal

3.9
Compare

BharatPe

3.5
Compare

Fiserv

3.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview