AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
PhonePe
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
PhonePe Data Analyst Interview Questions and Answers
PhonePe Data Analyst Interview Experiences
5 interviews found
Megha choudhary
Selected
(2 Questions)
- Q1. Sql,power bi,aptitude,technical
- Q2. How you take criticism
Anonymous
I applied via Campus Placement and was interviewed in Apr 2024. There were 4 interview rounds.
Apti was based on analytical skills
It was a fun GD which had the topic future app experiences.
Asked questions on guestimates and my analytical skills
(3 Questions)
- Q1. HR questions and 1 analytical question asked.
- Q2. Question asked on my location
- Q3. Question asked on guestimates
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed in Jul 2023. There were 3 interview rounds.
Easy questions based on Logical Reasoning, Mathematics, English
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.
(1 Question)
- Q1. Tell me about yourself Tell me something from your resume Desribe your project
I applied via IIM Jobs and was interviewed before Nov 2021. There were 5 interview rounds.
(2 Questions)
- Q1. Different types of Joins in SQL and what are the outputs when you join two tables with nulls.
- Ans.
Different types of Joins in SQL and the outputs when joining two tables with nulls.
Types of joins in SQL include inner join, left join, right join, and full outer join.
When joining two tables with nulls, the output depends on the type of join used.
In an inner join, null values are excluded from the result.
In a left join, all rows from the left table and matching rows from the right table are included, with nulls for no...
- Q2. Can you union tables with different datatypes.
- Ans.
Yes, but it requires careful handling of data types and potential conversion.
Union can be performed on tables with different datatypes, but the resulting table will have a common datatype for each column.
Data types should be compatible, otherwise conversion may be necessary.
For example, a table with a column of integers can be unioned with a table with a column of floats, but the resulting column will be of type float.
...
(2 Questions)
- Q1. Given a data set, should write sql queries to answer a few questions
- Q2. A few puzzles would be asked to evaluate the problem solving skills.
(1 Question)
- Q1. Business Case studies - try parctising profitablility and other cases
(1 Question)
- Q1. An Excel round will also be there if you apply for business analyst role.
Interview Preparation Tips
All the best for the interview.
Skills evaluated in this interview
PhonePe interview questions for designations
(1 Question)
- Q1. General questions and sql questions
Interview Preparation Tips
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
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
sameer kulkarni
(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
sahithi reddy
Selected
I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.
(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
(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...
Interview Preparation Tips
Skills evaluated in this interview
PhonePe Interview FAQs
Tell us how to improve this page.
PhonePe Interviews By Designations
- PhonePe Key Accounts Executive Interview Questions
- PhonePe Business Development Executive Interview Questions
- PhonePe Software Developer Interview Questions
- PhonePe Business Development Associate Interview Questions
- PhonePe Territory Sales Manager Interview Questions
- PhonePe Software Engineer Interview Questions
- PhonePe Team Lead Interview Questions
- PhonePe Graduate Trainee Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Data Science Analyst Interview Questions
- Show more
PhonePe Data Analyst Interview Process
based on 4 interviews
1 Interview rounds
- Resume Shortlist Round
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
PhonePe Data Analyst Reviews and Ratings
based on 4 reviews
Rating in categories
|
Key Accounts Executive
696
salaries
|  ₹3.7 L/yr - ₹7.5 L/yr |
|
Territory Sales Manager
518
salaries
| ₹4.5 L/yr - ₹10.5 L/yr |
|
Business Development Executive
514
salaries
| ₹1.1 L/yr - ₹5.1 L/yr |
|
Area Sales Manager
398
salaries
| ₹6.5 L/yr - ₹15.4 L/yr |
|
Business Development Associate
389
salaries
| ₹2.4 L/yr - ₹5.9 L/yr |
Paytm
Fiserv
KFintech
Angel One
- Home >
- Interviews >
- PhonePe Interview Questions >
- PhonePe Data Analyst Interview Questions
