Upload Button Icon Add office photos

PhonePe

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

PhonePe Analyst Interview Questions and Answers

Updated 10 Sep 2024

PhonePe Analyst Interview Experiences

2 interviews found

Analyst Interview Questions & Answers

user image Anonymous

posted on 10 Sep 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Job Portal and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Difference between rank & dense rank
  • Ans. 

    Rank assigns unique numbers to each row based on the order specified, while dense rank assigns consecutive numbers without gaps.

    • Rank leaves gaps in the ranking sequence if there are ties, while dense rank does not

    • Rank function is used to assign a unique rank to each row, while dense rank function is used to assign a unique rank to each distinct row

    • For example, if there are two rows with the same value and rank 1, the n...

  • Answered by AI
  • Q2. Given two tables Tell how many values would be there for left right inner outer join
  • Ans. 

    The number of values in different types of joins depends on the relationship between the tables.

    • In a left join, all values from the left table are included along with matching values from the right table. The number of values will be equal to the number of rows in the left table.

    • In a right join, all values from the right table are included along with matching values from the left table. The number of values will be equ...

  • Answered by AI
  • Q3. Find the newest customer id for every product
  • Ans. 

    Use SQL query to find the newest customer id for every product

    • Use GROUP BY clause to group by product

    • Use MAX() function to find the newest customer id for each product

    • Join the tables if necessary

  • Answered by AI

Skills evaluated in this interview

Analyst Interview Questions & Answers

user image Anonymous

posted on 13 Oct 2022

I applied via Campus Placement and was interviewed in Sep 2022. There were 2 interview rounds.

Round 1 - Aptitude Test 

Aptitude reasoning quant and permutations and combinations

Round 2 - Group Discussion 

A topic was given for a group ..eg cryptocurrency is boon or bane

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and prepare accordingly for the role .

Analyst Interview Questions Asked at Other Companies

asked in Capgemini
Q1. N-th Fibonacci Number Problem Statement Given an integer ‘N’, you ... read more
asked in Deloitte
Q2. Reverse a Number Problem Statement Given an integer 'N', write a ... read more
Q3. A 10x10x10 cube is made up of 1x1x1 cubes. Its outer surface is p ... read more
Q4. Ninja and the Game of Words In this game, Ninja is provided with ... read more
Q5. Good old standard problem: Playing number game with your friend t ... read more

Interview questions from similar companies

I appeared for an interview in Mar 2017.

Interview Questionnaire 

4 Questions

  • Q1. Tell us something about yourself.
  • Ans. 

    I am a detail-oriented business analyst with experience in data analysis and project management.

    • Experienced in data analysis and project management

    • Detail-oriented and analytical mindset

    • Strong communication and interpersonal skills

    • Proficient in various analytical tools such as Excel, SQL, and Tableau

  • Answered by AI
  • Q2. What do you about our company?
  • Ans. 

    I am not familiar with your company.

    • I have not had the opportunity to research your company yet.

    • I would appreciate it if you could provide me with more information about your company.

    • I am open to learning more about your company and its goals.

  • Answered by AI
  • Q3. Why should we hire you?
  • Ans. 

    I have the skills, experience, and passion to excel in this role and contribute to the success of the company.

    • I have a strong background in data analysis and problem-solving, which are essential skills for a business analyst.

    • I have experience working with various stakeholders, including clients, developers, and project managers, to ensure successful project delivery.

    • I am a quick learner and adaptable to new technologie...

  • Answered by AI
  • Q4. What are the marketing strategies according to you?
  • Ans. 

    Marketing strategies are plans and tactics implemented by businesses to promote their products or services and reach their target audience.

    • Identifying target audience and market segmentation

    • Creating a unique value proposition

    • Developing a marketing mix (product, price, place, promotion)

    • Utilizing digital marketing channels (social media, email marketing, SEO)

    • Implementing content marketing and storytelling

    • Building brand a...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: The questions were very tough to complete.Highly based on technical questions.
Tips: Hard work is necessary to crack it.
Duration: 3 hours
Total Questions: 45

Round: HR Interview
Experience: It went on very smoothly and i was quite comfortable with the interviewer.
Tips: One just needs to answer all the questions asked by the interviewer in a proper manner or confident manner presenting valid points.

College Name: Kiit university

Business Analyst Interview Questions & Answers

Paytm user image Rockey Maheshwari

posted on 8 Sep 2015

Interview Preparation Tips

Round: Test
Experience: It was a test of moderate level.

20 ques in 20 min.

Basic focus was speed and accuracy.

Tested calculation speed.
Tips: Try to decide which ques to answer and which ones to leave.

Its very important not to get stuck in any 1 ques and waste time. MOVE ON!
Duration: 20 minutes
Total Questions: 20

Round: Technical Interview
Experience: Hi ! i dont remember the question but I do remember that they were easy.

The interviewers are there to test you not to embarrass you. or humiliate you.
They dont expect you to answer every ques so no need to get frustrated if you get a couple of them wrong.
Tips: Go easy...
If you dont know answer to a ques , dont panic,. They are willing to qive you points for your approach.

General Tips: Relax at all times
Skill Tips: Just practice. Whenever you are on facebook solve a couple of brain teasers.


Skills: Aptitude
College Name: DTU
Motivation: Good Future prospects!

I applied via Naukri.com and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. They ask about previous work experience
  • Q2. They ask related to analitics questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Read about job description and prepare accordingly

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

  • Answered by AI
  • 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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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...

  • Answered by AI
  • 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

  • Answered by AI

Interview Preparation Tips

Round: Test
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
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Basic capital market question

Interview Questionnaire 

1 Question

  • Q1. Business analysis, scrum master

Interview Preparation Tips

Interview preparation tips for other job seekers - Very insightful
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview in Sep 2024.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Project related questions
  • Q2. Financial instruments knowledge
Round 2 - One-on-one 

(2 Questions)

  • Q1. General project related questions
  • Q2. Financial domain in depth questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Current CTC, Preferred location
  • Ans. 

    Current CTC and preferred location are confidential information.

    • Current CTC and preferred location are personal and confidential details.

    • It is common practice not to disclose current CTC during interviews.

    • Preferred location may vary based on individual circumstances and preferences.

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. About yourself, projects worked, sql questions, Python questions

PhonePe Interview FAQs

How many rounds are there in PhonePe Analyst interview?
PhonePe interview process usually has 2 rounds. The most common rounds in the PhonePe interview process are Resume Shortlist, Aptitude Test and Group Discussion.
How to prepare for PhonePe 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 PhonePe. The most common topics and skills that interviewers at PhonePe expect are Financial Services, Medical Insurance, Wellness, travel insurance and MIS.
What are the top questions asked in PhonePe Analyst interview?

Some of the top questions asked at the PhonePe Analyst interview -

  1. Given two tables Tell how many values would be there for left right inner outer...read more
  2. Find the newest customer id for every prod...read more
  3. Difference between rank & dense r...read more

Tell us how to improve this page.

PhonePe Analyst Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more

Analyst Interview Questions from Similar Companies

PayPal Analyst Interview Questions
3.9
 • 2 Interviews
Slice Analyst Interview Questions
3.2
 • 2 Interviews
View all
PhonePe Analyst Salary
based on 20 salaries
₹4.1 L/yr - ₹17.3 L/yr
52% more than the average Analyst Salary in India
View more details

PhonePe Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

1.0

Skill development

3.0

Work-life balance

2.0

Salary

5.0

Job security

2.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Key Accounts Executive
696 salaries
unlock blur

₹3.7 L/yr - ₹7.5 L/yr

Territory Sales Manager
522 salaries
unlock blur

₹4.5 L/yr - ₹10.5 L/yr

Business Development Executive
513 salaries
unlock blur

₹1.1 L/yr - ₹5 L/yr

Business Development Associate
388 salaries
unlock blur

₹2.4 L/yr - ₹5.9 L/yr

Software Engineer
314 salaries
unlock blur

₹12.2 L/yr - ₹45.8 L/yr

Explore more salaries
Compare PhonePe with

Paytm

3.3
Compare

Fiserv

3.0
Compare

KFintech

3.5
Compare

Angel One

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