Sulekha Catalog Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Catalog Analyst in e-commerce, retail, or D2C manages product data to ensure accuracy, completeness, and discoverability across online platforms. Day to day, they audit listings, enrich attributes, categorize products, and coordinate with merchants and tech teams to fix data issues. At fast-growing companies like Sulekha, they also help scale catalog operations and improve search relevance.

Role and Technical Knowledge

1. 1

   What is the difference between a product category and a product attribute? Give examples.

   A category is a broad classification (e.g., Electronics), while attributes are specific properties (e.g., brand, color, size). Use examples from e-commerce listings.

2. 2

   How would you handle a product with missing key attributes?

   Explain the process: identify missing attributes, source data from merchant or web, validate, and update. Mention using templates and quality checks.

3. 3

   What are some common catalog errors in e-commerce, and how do you fix them?

   Common errors include incorrect categorization, missing images, and wrong pricing. Fix by auditing, using validation rules, and coordinating with sellers.

4. 4

   What is SKU and why is it important?

   SKU is a unique identifier for each product variant. It helps in inventory management, tracking, and ensuring accurate listings.

Practical Scenarios

1. 5

   You have 1000 product listings with inconsistent brand names (e.g., 'Samsung', 'samsung', 'SAMSUNG'). How would you clean this data?

   Use Excel functions like TRIM, PROPER, or find-and-replace. For large datasets, use SQL or a script. Emphasize standardizing to a master list.

2. 6

   A merchant uploads a product with a wrong category. How do you resolve it?

   Verify the correct category based on product details, update the listing, and inform the merchant. Suggest preventive measures like category mapping guides.

3. 7

   How would you prioritize which catalog issues to fix first when you have limited time?

   Prioritize by business impact: high-traffic products, revenue-generating categories, and errors affecting customer experience. Use data to identify top issues.

4. 8

   You notice that a popular product is not appearing in search results. What steps would you take?

   Check if the product is active, correctly categorized, and has relevant keywords. Review search algorithm factors and coordinate with tech team if needed.

Behavioral and HR

1. 9

   Tell me about a time you paid attention to detail and caught an error.

   Use STAR method: describe a situation where you spotted a mistake, how you fixed it, and the positive outcome. Relate to data accuracy.

2. 10

   How do you handle repetitive tasks while maintaining accuracy?

   Mention strategies like setting checkpoints, using checklists, and taking short breaks. Emphasize consistency and quality.

3. 11

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

   Show passion for e-commerce, data accuracy, and problem-solving. Mention how catalogs impact customer experience and sales.

4. 12

   Describe a time you worked under a tight deadline. How did you manage?

   Highlight prioritization, time management, and communication. Give an example of completing a task on time without compromising quality.

Company and Sector Awareness

1. 13

   What do you understand about Sulekha's business model?

   Sulekha is a local services and classifieds platform connecting users with service providers. Catalog analysts help maintain accurate listings for services and products.

2. 14

   How does catalog quality impact an e-commerce company's success?

   Good catalog quality improves search, customer trust, and conversion rates. Poor quality leads to returns and dissatisfaction.

3. 15

   What trends in e-commerce do you think affect catalog management?

   Mention trends like AI for auto-categorization, voice search, and personalization. Explain how they change data requirements.

4. 16

   If you could improve one aspect of a typical e-commerce catalog, what would it be and why?

   Choose an aspect like attribute completeness or image quality. Justify with impact on customer experience and sales.