AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
PayU Payments Business Analyst Interview Questions and Answers
PayU Payments Business Analyst Interview Experiences
2 interviews found
217023 ncr.eee.15
I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.
(1 Question)
- Q1. A tough sql question
Anonymous
I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.
Marketing campaign case study
Interview questions from similar companies
I appeared for an interview in Dec 2016.
Interview Questionnaire
5 Questions
- Q1. Any thing which your friends hate about you?
- Ans.
I tend to be too organized and structured, which can annoy my friends at times.
My friends sometimes find my need for planning and structure to be excessive
I can be inflexible when it comes to deviating from my plans
My attention to detail can come across as nitpicky to some
I prioritize efficiency over spontaneity, which can be frustrating for my more laid-back friends
- Q2. Revenue collected by the barbers of Kanpur in an year
- Ans.
I don't have the available data to answer this question.
Need data on number of barbers in Kanpur
Need data on average revenue per barber
Need data on number of working days in a year
Need data on number of customers per barber per day
- Q3. If you are going to open an e-commerce website like Flipkart what will be the things that you will have to keep in mind.
- Ans.
To open an e-commerce website like Flipkart, one must keep in mind various factors such as target audience, product range, user experience, logistics, and marketing.
Identify the target audience and their preferences
Offer a wide range of products to cater to different needs
Ensure a seamless user experience with easy navigation and quick loading time
Establish a robust logistics network for timely delivery and hassle-free...
- Q4. If given the other job profile will you accept it?
- Ans.
It depends on the job profile and its alignment with my career goals.
I would consider the job profile and evaluate its alignment with my career goals.
I would assess the job responsibilities and the skills required for the role.
I would also consider the company culture and work environment.
If the job profile aligns with my career goals and offers growth opportunities, I would accept it.
However, if it does not align with...
- Q5. Any one decision you will like to change in course of these 4 years which could open a better career profile for you.
- Ans.
I would have pursued a certification in data science earlier.
I should have taken a course in data science during my undergraduate studies.
I could have pursued a certification in data science while working as a business analyst.
Learning data science earlier would have opened up more opportunities for me in the field.
I could have gained more experience in data analysis and visualization.
I could have applied for more adva...
Interview Preparation Tips
Experience: The question were tricky not conventional quant. Spend time on questions don't rush
Tips: CAT level preparation will be more than enough
Duration: 1 hour
Total Questions: 60
Round: HR Interview
Experience: Basic HR questions. Be confident and good communication skills will help
Round: Technical + HR Interview
Experience: There were 2 panelist one man and a woman. When they asked the revenue question, I asked the ma'am as to how many times do she go to a parlor and then how much does it cost each time. This lightened the mood and she was smiling throughout the interview. After listening to questions I was saying "Please give me 2 minutes to think over it" She finally said "Why do you want 2 minutes every time we ask a question" then i answered "I just want to come up with the best answer in 2 minutes and don't say anything irrelevant". They were very impressed said "Take as much time as you want "
Tips: Just be yourself. Confident with a smile. Workout the problem with them
Skills: Guesstimate Skills, HR Skills, Communication And Confidence, Ability To Handle Situations, Commitment
College Name: IIT Kanpur
Selected
I applied via Campus Placement and was interviewed in Sep 2023. There were 3 interview rounds.
General aptitude questions and excel questions
(1 Question)
- Q1. Knowledge of excel, guesstimate
(1 Question)
- Q1. Cultural fitment
What people are saying about PayU Payments
I applied via Campus Placement and was interviewed in Dec 2024. There were 2 interview rounds.
Quantitative aptitude, verbal ability, critical reasoning
(2 Questions)
- Q1. SQL: find store with highest AOV
- Ans.
Use SQL query to find store with highest Average Order Value (AOV).
Use GROUP BY clause to group by store
Calculate AOV by dividing total revenue by total orders
Use ORDER BY and LIMIT to find store with highest AOV
- Q2. Generic behavioural questions
I applied via LinkedIn and was interviewed in Jun 2023. There were 2 interview rounds.
(2 Questions)
- 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
- 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
This is a case study round revolve around a business problem in which we have to analyse data driven solutions.
Interview Preparation Tips
- SQL
- Excel
Skills evaluated in this interview
Selected
I applied via Recruitment Consulltant and was interviewed before Jul 2022. There were 3 interview rounds.
(2 Questions)
- Q1. Questions around Sql, python. Ranks, joins, self joins, partitions
- Q2. Tableau powerbi basics
Guesstimates, business case study
I applied via Approached by Company and was interviewed in Jul 2024. There were 2 interview rounds.
Case studies about Navi UPI
Case studies about Navi UPI App
Interview Preparation Tips
(1 Question)
- Q1. SQL, Python and Excel
I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.
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.
PayU Payments Interview FAQs
Tell us how to improve this page.
PayU Payments Interviews By Designations
- PayU Payments Software Engineer Interview Questions
- PayU Payments Software Developer Interview Questions
- PayU Payments Data Scientist Interview Questions
- PayU Payments Senior Software Engineer Interview Questions
- PayU Payments Team Manager Interview Questions
- PayU Payments Business Analyst Interview Questions
- PayU Payments Analyst Interview Questions
- PayU Payments Manager Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 2 interview experiences
Difficulty level
Duration
Business Analyst Interview Questions from Similar Companies
PayU Payments Business Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
|
Assistant Manager
224
salaries
|  ₹4.9 L/yr - ₹17.5 L/yr |
|
Software Engineer
201
salaries
| ₹12.1 L/yr - ₹36 L/yr |
|
Senior Software Engineer
183
salaries
| ₹13.5 L/yr - ₹42 L/yr |
|
Senior Manager
145
salaries
| ₹11.5 L/yr - ₹40 L/yr |
|
Manager
103
salaries
| ₹8.5 L/yr - ₹28 L/yr |
Angel One
Broadridge Financial Solutions
AGS Transact Technologies
PayPal
- Home >
- Interviews >
- PayU Payments Interview Questions
