Star Bazaar Catalog Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Catalog Analyst ensures product data on an e-commerce or D2C platform is accurate, complete, and optimised for search and conversion. Day to day, they enrich product listings, fix categorization and attribute errors, monitor catalog health metrics, and coordinate with merchants and tech teams to improve discoverability.

Role and technical knowledge

1. 1

   What is the difference between a product category and a product attribute? Give an example from grocery retail.

   Explain that category is a broad grouping (e.g., 'Snacks') while attributes are specific properties (e.g., 'flavour', 'weight', 'brand'). Use a real product like 'Lays Classic Salted 52g' to show both.

2. 2

   How would you check if a product listing is complete and ready to go live on an e-commerce site?

   Mention key fields: title, description, images, price, stock, category, and mandatory attributes. Show you would use a checklist or validation rules to catch missing data.

3. 3

   What is a SKU and why is it important for catalog management?

   Define SKU as a unique identifier for each sellable variant. Explain that it helps track inventory, avoid duplicates, and link listings to orders and pricing.

4. 4

   In Excel, how would you find and remove duplicate product entries from a list of 10,000 rows?

   Describe using 'Remove Duplicates' or a helper column with COUNTIF. Mention sorting and conditional formatting to visually spot duplicates before deleting.

Practical scenarios

1. 5

   You notice that a popular grocery item is showing up under 'Electronics' on the site. How do you fix it and prevent it from happening again?

   Outline steps: correct the category immediately, check if other items are misclassified, and suggest a validation rule or periodic audit to catch similar errors.

2. 6

   A merchant uploads a product feed with missing images for 200 items. What do you do?

   Prioritise by best-selling or high-margin items, communicate with the merchant, and set a temporary placeholder if allowed. Also propose a feed validation step before upload.

3. 7

   How would you handle a situation where two different products have the same title but different SKUs?

   Explain that titles should be unique enough for search. You would enrich titles with brand, variant, or size, and ensure attributes differentiate them. Do not merge SKUs unless they are truly duplicates.

4. 8

   You are asked to improve search results for 'atta'. What catalog changes would you make?

   Focus on adding synonyms, ensuring 'atta' is in the title and keywords, mapping to the correct category (e.g., 'Flour'), and including brand and weight attributes for filtering.

Behavioural and situational

1. 9

   Tell me about a time you had to work with a large amount of data and ensure accuracy. How did you do it?

   Use a college project or internship example. Highlight your method: breaking data into chunks, using formulas or scripts, and double-checking with spot audits.

2. 10

   Describe a situation where you found a mistake that others had missed. What did you do?

   Show proactiveness and attention to detail. Explain how you identified the error, how you corrected it, and how you communicated it to the team without blaming anyone.

3. 11

   You have to meet a daily target of enriching 500 products, but the data is messy. How do you stay productive?

   Talk about prioritisation, creating templates or macros for repetitive tasks, and asking for help when patterns are unclear. Mention tracking your progress to stay motivated.

4. 12

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

   Connect your interest in data accuracy and online shopping. Mention that you enjoy structured work and want to learn how catalogs drive customer experience and sales.

HR and company fit

1. 13

   What do you know about our company and how does this role fit into it?

   Research the company's retail or e-commerce presence. Explain that catalog analysts help ensure customers find the right products, which directly impacts sales and satisfaction.

2. 14

   How do you handle repetitive tasks without losing focus?

   Be honest but positive. Mention techniques like setting small goals, taking short breaks, and finding ways to automate or streamline repetitive work.

3. 15

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

   Show ambition to grow into senior catalog, merchandising, or data analytics roles. Emphasise learning deeper skills like SQL, Python, or category management.

4. 16

   Are you comfortable working with strict deadlines and shifting priorities?

   Give a brief example from college or an internship where you managed deadlines. Show flexibility and a calm approach to changing tasks.