PhonePe
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Job Portal and was interviewed in Aug 2024. There was 1 interview round.
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...
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...
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
I applied via Campus Placement and was interviewed in Sep 2022. There were 2 interview rounds.
Aptitude reasoning quant and permutations and combinations
A topic was given for a group ..eg cryptocurrency is boon or bane
Top trending discussions
I appeared for an interview in Mar 2017.
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
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.
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...
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...
I applied via Naukri.com and was interviewed in Jan 2021. There were 3 interview rounds.
I appeared for an interview in Dec 2016.
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
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
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...
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...
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
posted on 12 Jun 2024
posted on 9 Oct 2024
I appeared for an interview in Sep 2024.
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.
based on 2 interviews
Interview experience
based on 1 review
Rating in categories
Key Accounts Executive
696
salaries
| ₹3.7 L/yr - ₹7.5 L/yr |
Territory Sales Manager
522
salaries
| ₹4.5 L/yr - ₹10.5 L/yr |
Business Development Executive
513
salaries
| ₹1.1 L/yr - ₹5 L/yr |
Business Development Associate
388
salaries
| ₹2.4 L/yr - ₹5.9 L/yr |
Software Engineer
314
salaries
| ₹12.2 L/yr - ₹45.8 L/yr |
Paytm
Fiserv
KFintech
Angel One