Metro Cash and Carry India Catalog Analyst Interview: Rounds, Questions and Preparation

What the job involves

Catalog Analysts manage product data for e-commerce and retail catalogs, ensuring accuracy, completeness, and consistency across platforms. They enrich product listings with attributes, images, and pricing, and work with merchandising and supply chain teams to optimize discoverability and sales. In B2B retail like Metro Cash and Carry India, they handle large SKU volumes, bulk pricing, and compliance with category standards.

Role and Technical Knowledge

1. 1

   What do you understand by catalog management in an e-commerce or retail context?

   Explain that it involves organizing product data, ensuring accuracy, and maintaining taxonomy for easy search and purchase. Mention SKU management, attributes, and images.

2. 2

   What are the key attributes you would include for a grocery product in a B2B catalog?

   Cover basics like SKU, product name, brand, unit size, pack size, price, MRP, expiry, and category-specific attributes like organic or dietary info. Highlight bulk pricing and MOQ for B2B.

3. 3

   How would you ensure data accuracy when uploading a large batch of products?

   Describe validation rules, sample checks, using Excel formulas or scripts, and cross-referencing with source data. Mention maintaining a checklist and version control.

4. 4

   What is the difference between a product and a SKU? Give an example.

   A product is a general item (e.g., 'Amul Butter'), while a SKU is a specific variant (e.g., 'Amul Butter 500g'). Explain that SKUs track inventory and pricing.

Practical Scenarios

1. 5

   You find that 20% of products in a category have missing images. How would you handle this?

   Prioritize high-selling items, coordinate with vendors or internal teams for images, and set up a tracking sheet. Suggest temporary placeholders if allowed.

2. 6

   A supplier sends product data in a different format than required. What steps would you take?

   Map their fields to your template, use Excel functions like VLOOKUP or Power Query to transform data, and validate before upload. Communicate with the supplier for clarifications.

3. 7

   How would you handle a situation where a product is priced incorrectly on the website?

   Immediately flag it to the pricing or category team, check if it's a systemic error, and suggest a temporary fix. Emphasize speed and accuracy to avoid customer issues.

4. 8

   You need to add 500 new SKUs to the catalog within a week. How do you plan your work?

   Break down tasks, prioritize based on launch date, use bulk upload tools, and set daily targets. Mention collaboration with team members and regular progress checks.

Behavioral and HR Questions

1. 9

   Tell me about a time you had to meet a tight deadline. How did you manage?

   Use STAR method: describe the situation, task, action (prioritization, time management), and result. Highlight staying calm and delivering quality.

2. 10

   Describe a situation where you found a mistake in your work. What did you do?

   Show accountability: you identified the error, corrected it, and implemented a check to prevent recurrence. Emphasize learning and honesty.

3. 11

   Why do you want to work in catalog management, especially in retail or e-commerce?

   Connect your interest in data accuracy, product organization, and the dynamic nature of retail. Mention how this role is foundational to customer experience.

4. 12

   How do you handle repetitive tasks while maintaining focus?

   Talk about setting small goals, taking short breaks, using checklists, and finding ways to automate or streamline. Show that you value consistency and quality.

Company and Sector Awareness

1. 13

   What do you know about Metro Cash and Carry India and its business model?

   Mention it's a B2B wholesale retailer serving businesses like hotels, restaurants, and kirana stores. Highlight its focus on bulk sales, own brands, and digital catalog.

2. 14

   How does catalog management impact customer experience in B2B retail?

   Explain that accurate product info, pricing, and availability help business customers make quick purchase decisions, reducing returns and building trust.

3. 15

   What trends in e-commerce and retail do you think affect catalog management?

   Discuss personalization, omnichannel integration, AI for auto-tagging, and the need for real-time updates. Relate to how catalogs must adapt.

4. 16

   Why should we hire you for this role?

   Summarize your relevant skills (Excel, attention to detail, data management), your enthusiasm for retail, and your ability to learn quickly and work in a team.