IndiaMART Catalog Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Catalog Analyst in e-commerce, retail, or D2C manages product data accuracy, completeness, and consistency across online marketplaces and internal systems. Day to day, they clean and enrich product listings, resolve taxonomy and attribute issues, coordinate with sellers or vendors, and use Excel or SQL to audit catalog health. At a B2B marketplace like IndiaMART, they ensure that supplier listings, categories, and product specifications meet platform standards so buyers can search and compare easily.

Role and Technical Knowledge

1. 1

   What is product taxonomy and why is it important for an e-commerce catalog?

   Explain that taxonomy is a hierarchical classification of products into categories and subcategories. Strong answers mention that it improves search, filtering, and buyer experience, and reduces misclassification.

2. 2

   How would you check if a product listing is complete and accurate?

   Cover key fields like title, description, images, price, attributes, and category. Mention checking against a style guide or checklist and using formulas or filters to spot missing or inconsistent values.

3. 3

   What are some common catalog quality issues you have seen or read about in Indian e-commerce?

   Examples include duplicate listings, wrong categories, missing key attributes (size, color, material), poor images, and inconsistent units. Show awareness of how these hurt search and conversion.

4. 4

   What is the difference between a SKU and a product ID? How do they help in catalog management?

   SKU is a unique identifier for a specific sellable variant, while product ID groups variants under one parent. Explain how both help track inventory, avoid duplicates, and manage listings at scale.

Practical Scenarios

1. 5

   You find 500 listings in the wrong category. How would you fix this efficiently?

   Suggest a systematic approach: identify the correct category using keywords or mapping rules, use Excel or SQL to bulk update, and spot-check a sample before full rollout. Mention coordinating with sellers if needed.

2. 6

   A seller uploads a product with a misleading title and poor images. What steps do you take?

   Strong answers include flagging the listing, checking against platform guidelines, requesting corrections from the seller, and temporarily hiding the listing if it violates policy. Emphasize clear communication and documentation.

3. 7

   How would you measure the health of a product catalog?

   Mention metrics like fill rate (percentage of listings with all key attributes), accuracy rate, duplicate rate, and time to fix issues. Explain how you would track these weekly using Excel or a dashboard.

4. 8

   You have to onboard 200 new products from a vendor in one day. How do you plan your work?

   Show prioritization: create a template, validate data in batches, use formulas to check for errors, and set aside time for vendor queries. Mention keeping a checklist and communicating progress.

Behavioural and Situational Questions

1. 9

   Tell me about a time you found a mistake in your work or someone else's work and fixed it.

   Use the STAR method. Focus on how you detected the error, what action you took, and what you learned to prevent it. Show attention to detail and ownership.

2. 10

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

   Highlight clear communication, using simple examples, and checking for understanding. Mention patience and avoiding jargon.

3. 11

   You are given a repetitive task with a tight deadline. How do you stay accurate?

   Talk about breaking the task into chunks, using checklists, taking short breaks, and double-checking a sample. Show that you value accuracy over speed but can still meet deadlines.

4. 12

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

   Connect your interest in data, detail, and online shopping. Mention wanting to improve buyer experience and learn about marketplace operations. Avoid generic answers like 'I need a job'.

HR and Company Fit

1. 13

   What do you know about our company and this role?

   Research the company's business model (B2B or B2C), recent news, and how catalog fits in. For a B2B marketplace like IndiaMART, mention supplier listings and buyer search.

2. 14

   How do you handle feedback or criticism about your work?

   Show openness, ask clarifying questions, and give an example of implementing feedback. Emphasize that you see it as a chance to improve.

3. 15

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

   Focus on growing into a senior analyst or catalog specialist, mastering tools like SQL and PIM, and taking ownership of larger categories or projects.

4. 16

   Are you comfortable with rotational shifts or weekend work if required?

   Be honest but flexible. If you are open, say yes and explain how you manage time. If not, state your constraints politely and show willingness to adjust.