TradeIndia Catalog Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Catalog Analyst in e-commerce and D2C manages product data so that listings are accurate, complete, and search-friendly. Day to day you clean supplier feeds, write and standardise titles and attributes, categorise products, and fix errors that block a product from going live. You also track catalog health metrics and coordinate with sellers, merchandisers, and tech teams to improve discovery and conversion.

Role and E-commerce Catalog Knowledge

1. 1

   What does a Catalog Analyst do in an e-commerce company, and how does the role impact the customer experience?

   Explain that you own product data accuracy, completeness, and discoverability. Strong answers link clean catalog data to fewer returns, better search results, and higher conversion.

2. 2

   What is a product taxonomy, and why is it important for a marketplace like TradeIndia?

   Define taxonomy as a hierarchical classification of products. Mention that correct categories help buyers filter, compare, and find products, and help sellers appear in relevant searches.

3. 3

   What are some common catalog errors you might find in a seller-uploaded product feed?

   List examples like missing attributes, wrong categories, duplicate SKUs, inconsistent units, poor images, and spelling mistakes. Say how you would prioritise fixing high-traffic or high-return items first.

4. 4

   How would you measure the health of a product catalog?

   Mention metrics such as attribute fill rate, image compliance, category accuracy, duplicate rate, error rate, and return rate. Explain that you would track these weekly and set targets.

Technical and Tool-Based Questions

1. 5

   How would you use Excel to clean a list of 10,000 product titles that have inconsistent formatting?

   Describe steps like removing extra spaces with TRIM, using PROPER or LOWER for case, finding duplicates with COUNTIF, and using Text to Columns or Flash Fill for splitting data. Mention saving a backup and documenting the rules.

2. 6

   Write a basic SQL query to find all products in a table where the category is null.

   A strong answer shows SELECT * FROM products WHERE category IS NULL. Explain that this helps you identify missing data that blocks listing quality.

3. 7

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

   SKU is a unique internal identifier for a specific sellable variant. Product ID may be a marketplace or brand identifier, and a model number is manufacturer-defined. Explain why consistency matters for inventory and catalog matching.

4. 8

   How would you handle a product feed where the same product appears under three different categories?

   Say you would check the taxonomy rules, identify the most specific correct category, merge duplicates, and update the seller or source system. Mention communicating the fix to avoid recurrence.

Practical Scenarios and Case Questions

1. 9

   A top-selling product has a 40 percent return rate because the size chart is wrong. How would you investigate and fix it?

   Start by verifying the size chart against the actual product and competitor listings. Then correct the attribute, update the listing, and monitor returns. Mention coordinating with the seller and category manager.

2. 10

   You have 500 new seller listings to review in one day, but only time to check 200 properly. How do you prioritise?

   Prioritise by revenue potential, category importance, and risk of customer complaints. Check high-value or high-traffic items first, and use bulk rules for low-risk items. Communicate what was not checked.

3. 11

   A seller keeps uploading products with missing key attributes like color and material. What process would you set up to reduce this?

   Suggest a mandatory attribute template, validation rules at upload, seller training, and a feedback loop with error reports. Mention tracking improvement in fill rate over time.

4. 12

   How would you write a product title for a mobile phone listing that is both accurate and search-friendly?

   Include brand, model, key specs like RAM and storage, and color. Keep it readable, avoid keyword stuffing, and follow the platform's title guidelines. Give a short example.

Behavioural and HR Questions

1. 13

   Tell me about a time you found and fixed a data error that others had missed.

   Use the STAR method. Focus on how you noticed the issue, what you did to correct it, and how you prevented it from happening again. Show attention to detail.

2. 14

   This role involves repetitive data work. How do you stay accurate and motivated?

   Talk about creating checklists, taking short breaks, using formulas to reduce manual work, and tracking your own accuracy. Show that you understand the importance of consistency.

3. 15

   Describe a situation where you had to explain a technical or data issue to a non-technical person.

   Give a clear example from a project or internship. Emphasise using simple language, visuals, and focusing on the impact rather than the technical details.

4. 16

   Why do you want to work as a Catalog Analyst in e-commerce, and why our company?

   Connect your interest in data accuracy and online shopping to the company's growth stage or marketplace model. Mention specific aspects like seller onboarding or category expansion that excite you.