Naaptol Online Shopping Category Manager Interview Questions and Answers

Q1. Joins with with subquery questions
Add your answer
Q2. Window function usage and application
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Window functions are used to calculate cumulative sums, averages, ranks, and more.

• They allow for calculations to be performed on a specific subset of rows within a larger result set.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer

Merchandising problems on otb

Q1. General discussion
Add your answer

Q1. KPIs to look after in the e-commerce industry?
Add your answer
Q2. -
Add your answer

Q1. How do you think your skills are aligned with the role you want to get into?
Ans. Anything from the past work experience which emphasis on the new JTBD will suffice. One basically needs to answer what they bring to the table and how will it help the employer.
Answered by Anushka Gupta
Add your answer

Q1. Team/ Managerial skills
Add your answer

Q1. How will you manage conflicts with stakeholders?
Ans. 
I will address conflicts by actively listening, understanding perspectives, finding common ground, and proposing solutions.
• Actively listen to all stakeholders involved to understand their perspectives

• Identify common ground and areas of agreement to build upon

• Propose solutions that address the concerns of all parties involved

• Seek input and feedback from stakeholders throughout the conflict resolution process
Answered by AI
Add your answer

Q1. A lot of questions around sales funnel and how to improve the same
Add your answer
Q2. Questions around how digital marketing would be leveraged Upon
Add your answer

Improvements and Suggestions for Grocery

Q1. Details about P and L
Add your answer
Q2. P and L cases of my previous company, sample P and L, unit economics questions of Grocery
Add your answer
Q3. Details about previous company work experience
Add your answer

Q1. Overall understanding of grocery
Ans. 
An overall understanding of grocery includes knowledge of various product categories, consumer preferences, market trends, and supply chain management.
• Understanding different product categories such as fresh produce, dairy, meat, canned goods, etc.

• Knowledge of consumer preferences and purchasing behavior in the grocery industry.

• Awareness of market trends and emerging products in the grocery sector.

• Understanding supply ...read more
Answered by AI
Add your answer
Q2. Types of Grocery delivery
Ans. 
There are various types of grocery delivery services available.
• Traditional grocery delivery: Customers place orders online or over the phone and groceries are delivered to their doorstep.

• Subscription-based grocery delivery: Customers subscribe to a service and receive regular deliveries of groceries.

• On-demand grocery delivery: Customers can order groceries through a mobile app or website and have them delivered within ...read more
Answered by AI
Add your answer

Q1. Concept questions - what are the steps that you will follow to analyse the issue
Add your answer

Case study on two of three business questions.

Q1. Questions from someone outside of the team to check the overall fitment
Add your answer

Q1. What skills needed to perform well in the job ...blah blah
Add your answer