Decathlon India Catalog Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Catalog Analyst maintains the accuracy, completeness, and quality of product data in an e-commerce or retail catalog. Day to day, they enrich product attributes, correct errors, coordinate with vendors and merchandising teams, and use Excel or catalog tools to ensure listings are searchable and conversion-friendly.

Role and Technical Knowledge

1. 1

   What is a product catalog in an e-commerce context, and why is data accuracy important?

   Define catalog as the structured set of product information. Explain that inaccurate data leads to wrong search results, returns, and lost sales.

2. 2

   What are the key attributes you would check for a sports shoe listing on an e-commerce site?

   List attributes like size, colour, material, gender, sport type, brand, price, stock, and images. Mention that missing attributes hurt discoverability.

3. 3

   How would you use Excel to find and fix duplicate product entries in a catalog?

   Describe using COUNTIF or Remove Duplicates, then VLOOKUP or conditional formatting to compare SKUs, names, and attributes before merging.

4. 4

   What is a SKU, and how does it differ from a product ID or model number?

   Explain SKU as a unique internal code for a specific sellable variant. Product ID or model number may group variants under one parent.

Practical Scenarios

1. 5

   You notice that 200 product listings have missing size information. How would you handle this?

   Prioritise by traffic or sales impact, extract the list, contact vendors or source data, update in bulk, and verify a sample after upload.

2. 6

   A vendor sends a product feed with inconsistent colour names like 'Navy', 'Navy Blue', and 'Dark Blue'. What do you do?

   Standardise to one approved value using a mapping sheet, document the rule, and communicate the standard back to the vendor to prevent repeats.

3. 7

   How would you prioritise your work if you have 500 new listings to upload and 50 customer complaints about wrong product details?

   Address complaints first because they affect live customers, then batch-upload new listings. Mention using a simple impact versus effort matrix.

4. 8

   You find that a product image does not match the description. What steps do you take before the listing goes live?

   Flag the mismatch, pause the listing if possible, request correct image or description from the vendor, and re-verify both before publishing.

Behavioural and Situational Questions

1. 9

   Tell me about a time you found a small error that others had missed. What did you do?

   Use a specific example from college projects or internships. Show that you checked carefully, corrected it, and informed the right person.

2. 10

   Describe a situation where you had to meet a tight deadline with incomplete information.

   Explain how you gathered what was available, made reasonable assumptions, asked for help early, and still delivered on time.

3. 11

   How would you handle a vendor who repeatedly sends incomplete product data?

   Stay professional, share a clear checklist of required fields, offer a template, and escalate politely if the issue continues.

4. 12

   Give an example of working in a team where tasks were divided. What was your contribution?

   Highlight your specific role, how you coordinated with others, and the final outcome. Show you are reliable and communicative.

HR and Motivation Questions

1. 13

   Why do you want to work as a Catalog Analyst in e-commerce or retail?

   Connect your interest in data accuracy, online shopping, and structured work. Mention that you enjoy detail-oriented tasks that improve customer experience.

2. 14

   How do you stay organised when handling repetitive data tasks?

   Talk about checklists, batching similar tasks, using shortcuts, and taking short breaks to maintain focus and accuracy.

3. 15

   Where do you see yourself in two to three years in this role?

   Show ambition to grow into senior catalog, merchandising, or data quality roles. Emphasise learning deeper tools and processes.

4. 16

   What do you know about our company's products or brand, and why does that interest you?

   Research the company's product range, customer base, and online presence. Link your interest to the role, such as improving sports product listings.