Koovs India Catalog Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Catalog Analyst at an e-commerce or D2C company like Koovs India manages product data to ensure accurate, complete, and appealing listings across the website and marketplaces. Day to day, they upload new products, write descriptions, assign categories and attributes, fix data errors, and coordinate with merchandising, photography, and sourcing teams. They also track catalog health metrics and support pricing and promotion updates.

Role and E-commerce Knowledge

1. 1

   What do you understand by the term catalog in an e-commerce context, and what does a Catalog Analyst do?

   Explain that a catalog is the structured collection of product listings with titles, descriptions, images, prices, and attributes. Mention that a Catalog Analyst ensures accuracy, completeness, and consistency of this data to help customers find and buy products.

2. 2

   Why is accurate product data important for an online fashion retailer like Koovs India?

   Highlight that accurate data reduces returns, improves customer trust, boosts search visibility, and enables smooth order fulfillment. Give an example like wrong size chart leading to returns.

3. 3

   What are product attributes and why do they matter? Give examples from fashion e-commerce.

   Attributes are details like size, color, material, fit, sleeve length, and occasion. They matter for filtering, search, and recommendations. Use examples like 'cotton', 'slim fit', 'casual'.

4. 4

   How would you handle a product with missing images or incomplete description?

   Explain that you would flag it to the concerned team (photography or sourcing), temporarily unpublish or mark as incomplete, and follow up until resolved. Emphasize not publishing incomplete listings.

Technical and Practical Skills

1. 5

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

   Describe using conditional formatting to highlight duplicates, or using COUNTIF to flag repeated SKUs or product names. Mention sorting and filtering to review and remove duplicates.

2. 6

   What is a SKU and how is it different from a product ID?

   SKU is a unique identifier for a specific variant (size, color) used internally for inventory. Product ID may group variants under one parent product. Explain with an example like a t-shirt in three sizes having three SKUs but one product ID.

3. 7

   If you notice that a product title is too long and lacks keywords, how would you improve it?

   Suggest including brand, product type, key attributes (color, material, fit), and relevant keywords in a concise format. Mention keeping it readable and following the company's title guidelines.

4. 8

   What steps would you take to ensure a new batch of 100 products is uploaded without errors?

   Outline a checklist: verify data in template, validate mandatory fields, check images, cross-check with source sheet, do a sample test upload, and review live listings. Mention using Excel formulas to catch missing data.

Scenario-Based Questions

1. 9

   You find that 20 products are showing incorrect prices on the website. What do you do?

   Say you would immediately inform your supervisor and the pricing team, identify the source of error (e.g., wrong upload), correct the data, and re-verify. Also check if any orders were placed at wrong price and escalate.

2. 10

   A merchandiser wants a product live in 2 hours, but the images are not ready. How do you handle it?

   Communicate the dependency clearly, suggest going live with placeholder images temporarily if allowed, or prioritize other tasks. Show ability to manage expectations and find a workaround without compromising quality.

3. 11

   You are assigned to categorize 500 new arrivals into existing categories. How do you approach this?

   First understand the taxonomy, then use filters and sorting in Excel to group similar items. For ambiguous items, refer to guidelines or ask senior. Mention doing a quick quality check after categorization.

4. 12

   You notice that a competitor's website has better product descriptions. What do you do with this observation?

   Suggest analyzing their style, identifying gaps, and proposing improvements to your team. Show initiative and awareness of market trends without directly copying.

Behavioral and HR Questions

1. 13

   Tell me about a time you had to pay close attention to detail to avoid a mistake.

   Use STAR method: describe a situation (e.g., college project, internship), the action you took to double-check, and the positive outcome. Emphasize thoroughness.

2. 14

   How do you handle repetitive tasks while maintaining accuracy?

   Talk about creating checklists, taking short breaks, using tools like Excel to automate, and setting personal quality checks. Show that you understand the nature of catalog work.

3. 15

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

   Connect your interest in fashion or online shopping with data accuracy and problem-solving. Mention wanting to learn about e-commerce operations and grow in the sector.

4. 16

   Describe a time you worked in a team to meet a deadline.

   Give an example from college or internship where you coordinated tasks, communicated progress, and helped the team finish on time. Highlight collaboration and reliability.