Zudio Catalog Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Catalog Analyst in e-commerce, retail, or D2C manages product data that powers online and offline shopping experiences. Day to day, they create and update product listings, write descriptions, assign categories and attributes, verify image and size standards, and ensure pricing and stock accuracy. They also audit catalog quality, fix errors, and coordinate with buying, merchandising, and tech teams to keep the catalog complete and searchable.

Role and Technical Knowledge

1. 1

   What is a product taxonomy and why does it matter for an online fashion retailer?

   Explain that taxonomy is a hierarchical classification of products (for example, Men > Footwear > Sneakers). A strong answer covers how it improves search, filters, navigation, and reporting.

2. 2

   What are the key attributes you would capture for a t-shirt in an e-commerce catalog?

   List attributes like brand, product name, SKU, size, color, fabric, sleeve type, neck type, pattern, fit, price, and care instructions. Mention that attributes must follow a standard format for filters to work.

3. 3

   How would you write a product description that is both informative and search friendly?

   Cover the structure: a clear title with key keywords, a short benefit led paragraph, a bullet list of features, and size or care details. Avoid keyword stuffing and ensure accuracy.

4. 4

   What is a SKU and how is it different from a style code or a parent-child relationship in a catalog?

   Explain that a SKU is a unique identifier for a specific variant (size and color). A style code groups variants, and parent-child links show that a red medium t-shirt is a child of the t-shirt style.

Practical Scenarios

1. 5

   You notice that 200 products are missing their size attribute. How would you fix this efficiently?

   Suggest exporting the data, filtering missing values, and using a lookup or bulk update from a reliable source. Mention validating after upload and setting a recurring check to prevent repeats.

2. 6

   A product appears in search results for the wrong category. What steps would you take to investigate and correct it?

   Check the category mapping, attributes, and keywords. Verify if the product was misclassified during upload or if a bulk rule caused the issue. Correct the taxonomy and test search again.

3. 7

   How would you handle a situation where the same product is listed twice with different SKUs?

   Explain that you would confirm the duplication, check sales and stock for both, merge or retire the duplicate, and update the catalog to keep one master record. Mention informing the buying or merchandising team.

4. 8

   You have to launch a new category with 500 products in one week. How do you plan your work?

   Cover prioritization, creating a template, batch processing, quality checks at each stage, and coordinating with photographers, content writers, and category managers. Mention daily progress tracking.

Tools and Data Skills

1. 9

   How would you use VLOOKUP or INDEX-MATCH in Excel to enrich a catalog file?

   Describe pulling attributes like price or size from a master sheet into a product sheet using a common key such as SKU. Mention handling errors and checking for duplicates.

2. 10

   What is a PIM system and how does it help a catalog team?

   Explain that a Product Information Management system stores and organizes product data centrally. It helps maintain consistency, manage versions, and publish to multiple channels.

3. 11

   What basic SQL query would you write to find products with missing images?

   A query like SELECT sku, product_name FROM products WHERE image_url IS NULL OR image_url = ''. Mention that even basic filtering and joins are useful for catalog audits.

4. 12

   How do you ensure data accuracy when working with large catalog files?

   Talk about using validation rules, sample checks, conditional formatting, and cross verifying with source files. Mention documenting errors and fixing root causes.

Behavioural and HR Questions

1. 13

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

   Use the STAR method. Focus on how you detected the error, what you did to correct it, and what process you put in place to avoid it again.

2. 14

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

   Connect your interest in online shopping, product data, and attention to detail. Mention that you enjoy organizing information and improving customer experience.

3. 15

   Describe a situation where you had to meet a tight deadline with multiple tasks.

   Show how you prioritized, communicated with your team, and used tools or checklists to stay on track. End with the result and what you learned.

4. 16

   How would you handle feedback from a senior that your catalog data has many errors?

   Show a positive attitude: accept the feedback, ask for specific examples, review your work, and create a correction plan. Mention keeping the senior updated on progress.