AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Razorpay
Compare
Filter interviews by
Razorpay Senior Data Analyst Interview Questions and Answers for Experienced
Razorpay Senior Data Analyst Interview Experiences for Experienced
1 interview found
Anonymous
Selected
I applied via Instahyre and was interviewed before Mar 2023. There were 3 interview rounds.
(3 Questions)
- Q1. SQL questions regarding window functions
- Q2. Calc retained revived new customer per month basis what are joins in sql what is dense rank
- Ans.
To calculate retained, revived, and new customers per month basis, joins in SQL and dense rank are used.
To calculate retained, revived, and new customers per month basis, you would typically use SQL queries to join different tables containing customer data.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Dense rank is a function in SQL that assigns a rank to each row ...
- Q3. How sql query work behind the scenes
- Ans.
SQL queries work by parsing and executing commands to retrieve data from databases.
SQL query is written in a specific syntax to communicate with databases.
The query is parsed by the database management system to understand the command.
The database engine then executes the query to retrieve the requested data.
Queries can involve selecting, updating, inserting, or deleting data from tables.
Example: SELECT * FROM table_na
Tv commercial case study regarding if we run campaign of product over television how can attribute it to spike or increase in tration which we see in our data.
(1 Question)
- Q1. Cultural fit round
Interview Preparation Tips
python numpy and pandas working
guesstimates
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
AKASH KUMAR SINGH
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
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 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...
- 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
- 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...
- 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...
- 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
Interview Preparation Tips
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
I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.
(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
SQL Coding Tests. You get 3 tables and they ask you to find customer with certain conditions. Not hard
Selected
I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.
(1 Question)
- Q1. Tell me about yourself and the current projects you are working on.
(1 Question)
- Q1. Sql Questions on regex, json , window functions were there.
(1 Question)
- Q1. Questions on current project, Tableau related question were there.
I applied via Referral and was interviewed in Oct 2024. There were 3 interview rounds.
Sql, python, statistical questions
(2 Questions)
- Q1. How daily work looks like?
- Ans.
Daily work involves analyzing data, creating reports, and communicating findings to stakeholders.
Reviewing and cleaning data sets
Creating visualizations and dashboards
Conducting statistical analysis
Communicating insights to non-technical stakeholders
- Q2. Most ise tools?
- Ans.
Some of the most commonly used tools for data analysis include Excel, Python, R, Tableau, and SQL.
Excel is widely used for data manipulation and analysis.
Python and R are popular programming languages for data analysis and machine learning.
Tableau is a powerful data visualization tool.
SQL is essential for querying databases and extracting data.
4 sql tasks on 3 tables. Joins, subqueries
Interview Preparation Tips
Sql mandatory
Skills evaluated in this interview
I applied via LinkedIn and was interviewed before Nov 2023. There were 2 interview rounds.
(1 Question)
- Q1. Brief me about yourself
(1 Question)
- Q1. What is your experience as a data analyst?
Vishwesh Dayama
(2 Questions)
- Q1. SQL Joins and remove duplicates
- Q2. Function to create a transaction bin column
- Ans.
Create a function to generate a transaction bin column based on transaction amounts.
Create bins based on transaction amounts (e.g. $0-$100, $101-$200, etc.)
Use pandas cut() function in Python to create bins
Assign bin labels to the transactions based on the bin ranges
I applied via Campus Placement and was interviewed in Dec 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Technical questions on sql
Interview Preparation Tips
Snehith Korukonda
I applied via Naukri.com and was interviewed in Jul 2024. There were 4 interview rounds.
Topics were, DSA, SQL, PL/SQL, Data Augmentation
Customer churn classification using a classification ML model
(2 Questions)
- Q1. Write a pseudo code for Bubble sort
- Ans.
Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements, and swaps them if they are in the wrong order.
Start with the first element and compare it with the next element, swapping if necessary
Repeat this process for each pair of adjacent elements in the array until the entire array is sorted
Continue this process for each element in the array until no more swaps are ne
- Q2. What is an API
- Ans.
An API (Application Programming Interface) is a set of rules and protocols that allows different software applications to communicate with each other.
APIs define the methods for requesting and receiving data between software applications
APIs can be used to access data from external sources, such as social media platforms or weather services
Examples of APIs include the Twitter API, Google Maps API, and Spotify API
(2 Questions)
- Q1. Tell me about yourself
- Ans.
I am a data analyst with a strong background in statistics and data visualization.
Graduated with a degree in Statistics
Proficient in programming languages like Python and R
Experience in analyzing large datasets and creating data visualizations
Strong problem-solving skills and attention to detail
- Q2. Salaray compensation how much
Skills evaluated in this interview
Razorpay Interview FAQs
Tell us how to improve this page.
Razorpay Interviews By Designations
- Razorpay Product Manager Interview Questions
- Razorpay Senior Software Engineer Interview Questions
- Razorpay Software Engineer Interview Questions
- Razorpay Senior Associate Interview Questions
- Razorpay Software Developer Interview Questions
- Razorpay Product Development Engineer Interview Questions
- Razorpay Territory Manager Interview Questions
- Razorpay Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Analyst Intern Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Associate Data Analyst Interview Questions
- Data Analyst Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Show more
Razorpay Senior Data Analyst Interview Process for Experienced
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Razorpay Senior Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Junior Analyst
121
salaries
|  ₹2 L/yr - ₹5.5 L/yr |
|
Software Engineer
105
salaries
| ₹6.9 L/yr - ₹24 L/yr |
|
Senior Software Engineer
103
salaries
| ₹12.6 L/yr - ₹47.2 L/yr |
|
Analyst
102
salaries
| ₹3.5 L/yr - ₹7.3 L/yr |
|
Software Developer
96
salaries
| ₹8 L/yr - ₹30 L/yr |
Paytm
PayPal
BharatPe
Fiserv
- Home >
- Interviews >
- Razorpay Interview Questions >
- Razorpay Senior Data Analyst Interview Questions for Experienced
