Reliance Digital Catalog Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Catalog Analyst maintains the accuracy, completeness, and quality of product listings on an e-commerce or D2C platform. Day to day, they enrich product data, fix categorization and attribute errors, coordinate with vendors or category teams, and run audits to ensure customers see correct prices, images, and specifications. At a large retailer like Reliance Digital, this role directly affects search, filtering, and conversion on the website or app.

Role and technical knowledge

1. 1

   What does a catalog analyst do in an e-commerce company?

   A strong answer covers maintaining product listings, fixing attributes and categories, auditing data quality, and supporting search and filter accuracy. Mention that you work with category, vendor, and tech teams.

2. 2

   What is a product taxonomy and why does it matter?

   Explain that taxonomy is the hierarchical classification of products (for example, Electronics > Mobiles > Smartphones). It matters because it powers navigation, search, filters, and recommendations.

3. 3

   How would you handle a product with missing attributes like color or size?

   Say you would first check the source (vendor sheet, product image, or manufacturer site), then update the listing or raise a ticket. If missing data blocks a key filter, flag it to the category team.

4. 4

   What are the common catalog errors you have seen or can imagine?

   List examples like wrong category, duplicate SKUs, incorrect price, missing images, mismatched titles, and wrong attribute values. Show that you understand each error hurts customer trust or returns.

Practical scenarios and problem solving

1. 5

   You find that 20 percent of mobile phone listings are missing the 'RAM' attribute. How do you fix this?

   A strong answer suggests extracting RAM from titles or descriptions using a rule or formula, validating against the product image, and then bulk updating. Also mention setting up a check to prevent future gaps.

2. 6

   A vendor sends you a catalog file with 500 rows and several columns mismatched. What is your first step?

   Say you would first map the vendor columns to your internal template, then use VLOOKUP or a script to align data. After that, run a quick validation for missing or invalid values before uploading.

3. 7

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

   Prioritize by business impact: fix errors on high-traffic or high-revenue products first, then issues that break filters or search, then cosmetic issues. Mention using sales or traffic data to decide.

4. 8

   A product image shows a black phone but the attribute says blue. What do you do?

   You would verify the correct color from the vendor or brand site, update the attribute or image, and document the correction. If unsure, escalate to the category manager rather than guessing.

Tools and data skills

1. 9

   How comfortable are you with Excel? Give an example of a formula you would use for catalog work.

   Mention VLOOKUP or XLOOKUP to merge vendor data with your master sheet, IFERROR to handle missing values, and pivot tables to count errors by category. Be ready to explain one formula step by step.

2. 10

   What is the difference between a SKU and a product ID?

   A SKU is a unique identifier for a specific sellable variant (size, color, pack). A product ID groups variants under one parent product. Explain that both are needed for catalog structure.

3. 11

   Have you used any catalog or PIM tool? If not, how would you learn one?

   If you have no experience, say you would start with tutorials, ask for sample data, and practice on a free tool or a mock sheet. Show willingness to learn quickly.

4. 12

   How would you use SQL in a catalog analyst role?

   Give simple examples like SELECT queries to find products with null attributes, COUNT to measure error rates per category, and JOIN to compare vendor data with live listings.

Behavioural and HR questions

1. 13

   Tell me about a time you found and fixed a mistake in your work or a project.

   Use a STAR example. Focus on how you noticed the error, what you did to correct it, and what you changed to avoid repeating it. Show ownership and attention to detail.

2. 14

   How do you handle repetitive tasks like data entry or auditing?

   Say you stay accurate by using checklists, batching similar work, and taking short breaks. Mention that you look for ways to automate or template repetitive steps.

3. 15

   Why do you want to work in e-commerce catalog operations?

   Connect your interest to how product data drives online shopping. Mention that you enjoy detail-oriented work and want to learn how large retailers like Reliance Digital manage millions of listings.

4. 16

   Describe a time you had to coordinate with someone to get missing information.

   Give a college or internship example where you followed up politely, explained why the data was needed, and met a deadline. Highlight clear communication and persistence.