Tata CLiQ Category Manager Interview Questions and Answers for Experienced

Q1. Puzzles were asked, geeks for geeks puzzle
Add your answer
Q2. Case study quetions were asked
Add your answer

Merchandising problems on otb

Q1. General discussion
Add your answer

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

Simple aptitude test!

Q1. Introduce yourself
Ans. 
Experienced Category Manager with a background in retail and a proven track record of driving sales and profitability.
• Over 5 years of experience in category management

• Strong analytical skills to identify trends and opportunities

• Implemented successful strategies to increase sales by 20% in previous role
Answered by AI
Add your answer
Q2. Talk about relevant experiences
Ans. 
I have over 5 years of experience as a Category Manager in the retail industry.
• Managed product assortment and pricing strategies

• Developed strong vendor relationships

• Implemented successful promotional campaigns

• Analyzed sales data to optimize category performance
Answered by AI
Add your answer

Q1. Take me through your CV
Ans. 
Experienced Category Manager with a background in retail and supply chain management.
• Started career in retail as a sales associate, quickly moving up to assistant manager

• Managed inventory and ordering for multiple product categories

• Implemented successful promotional strategies to increase sales

• Collaborated with vendors to negotiate pricing and terms
Answered by AI
Add your answer

Q1. Cultural question
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. 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. KPIs to look after in the e-commerce industry?
Add your answer
Q2. -
Add your answer