PhonePe Interview Questions, Process, and Tips

Finance and accounting related test

Q1. Employee knowledge
Add your answer
Q2. Employee confident
Add your answer

Q1. Finance related hiring the question
Add your answer
Q2. Taxation related
Add your answer
Q3. Job related questions
Add your answer

Q1. They asked questions on basic SQL and focused more on writing optimised query rather than correct query.
Add your answer
Q2. Others were few case study question and stats
Add your answer

Q1. Im waiting for Interview
Add your answer
Q2. Ready to join Phonepe - please call XXXXX
Add your answer

Q1. Please contact XXXXX
Add your answer
Q2. I'm immediate joiner, 6 Yrs of exp in quality auditing
Add your answer

Q1. Related to linux, commands
Add your answer

Q1. Questions were from topics like computer networks, cyber security
Add your answer
Q2. About projects and resume based
Add your answer

Q1. Questions were mainly based on my college projects
Add your answer

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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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
Add your answer

Q1. Workex, RCA questions based on the industry where I had worked
Add your answer

Q1. All about the industry that the role was for
Add your answer

Q1. Product Design question: Increase the average order value of Swiggy customers
Ans. 
To increase the average order value of Swiggy customers, we can implement upselling techniques and personalized recommendations.
• Implement a loyalty program where customers can earn points for every order and redeem them for discounts or free items.

• Offer bundle deals or combo meals at a discounted price to encourage customers to spend more.

• Utilize data analytics to provide personalized recommendations based on past orde...read more
Answered by AI
Add your answer

Q1. How is Gpay better than PhonePe. What new feature would you add in Gpay
Ans. 
Gpay offers seamless integration with other Google services and has a wider user base. A new feature could be integration with Google Maps for location-based payments.
• Gpay has a larger user base compared to PhonePe

• Gpay offers seamless integration with other Google services such as Gmail and Google Calendar

• A new feature could be integration with Google Maps for location-based payments
Answered by AI
Add your answer