Ikea India Catalog Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Catalog Analyst maintains product data accuracy and completeness for an e-commerce or retail catalog, ensuring every SKU has correct titles, descriptions, attributes, pricing, and images. Day to day you audit listings, fix data gaps, coordinate with vendors or merchandising teams, and use Excel or catalog tools to upload and validate bulk product information. In a D2C or retail setting like Ikea India, you also help localise content for the Indian market and support search and filter accuracy.

Role and Technical Knowledge

1. 1

   What is a product catalog in an e-commerce or retail context, and what does a Catalog Analyst do with it?

   Explain that a catalog is the structured list of all products with attributes like SKU, title, price, and category. Mention that a Catalog Analyst ensures this data is complete, accurate, and consistent across channels.

2. 2

   What are the key attributes you would check for a furniture product listing on an Indian e-commerce site?

   Cover basics like product name, SKU, price, dimensions, material, colour, assembly required, warranty, and category. Add India-specific details like delivery pin codes or EMI options if relevant.

3. 3

   How would you use Excel to find and fix duplicate or missing SKUs in a product sheet?

   Mention using COUNTIF to find duplicates, conditional formatting to highlight blanks, and VLOOKUP or XLOOKUP to match against a master list. Emphasise a systematic cleaning process.

4. 4

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

   An attribute is a property like colour or size, while a variant is a specific sellable version, such as a blue sofa in fabric versus leather. Use a clear product example.

Practical Scenarios and Problem Solving

1. 5

   You receive a product feed from a vendor with 500 items, but 50 have missing dimensions and 20 have wrong category tags. How do you handle this?

   Show a step-by-step approach: separate the errors, prioritise missing dimensions because they affect returns, contact the vendor for corrections, and use a validation sheet before upload. Mention documenting the fixes.

2. 6

   A popular product is showing the wrong price on the website compared to the internal system. What do you check first?

   Check the source of truth, like the PIM or ERP, then the upload log, then the website display rules. Mention escalating to pricing or tech teams if the issue is not in your control.

3. 7

   How would you improve the search results for a product like 'wooden dining table' on an Indian D2C site?

   Suggest adding relevant keywords to the title and description, using correct category and filters, and including synonyms like 'dining table set' or '6 seater'. Mention checking search logs for what customers actually type.

4. 8

   You have to upload 1,000 new SKUs in two days. How do you plan your work to avoid errors?

   Break the work into batches, use a template with validation rules, do a small test upload first, and keep a checklist. Mention communicating realistic timelines if the volume is too high.

Behavioural and Teamwork Questions

1. 9

   Tell me about a time you noticed a small error in a school project or internship that others missed. What did you do?

   Use STAR format: describe the situation, the error you spotted, how you fixed it, and the result. Highlight your attention to detail and willingness to speak up.

2. 10

   Catalog work can be repetitive. How do you stay accurate and motivated over long data entry or audit tasks?

   Mention techniques like taking short breaks, using checklists, setting small goals, and double-checking your own work. Show that you understand the importance of accuracy over speed.

3. 11

   Describe a time you had to coordinate with someone who was not responding to your requests for product information.

   Explain how you followed up politely, offered a simpler format for them to share data, and escalated only when necessary. Emphasise clear communication and patience.

4. 12

   Give an example of how you have handled feedback on a mistake you made in a team or academic setting.

   Be honest about the mistake, show that you accepted the feedback without defensiveness, and explain the concrete step you took to avoid repeating it. End with what you learned.

HR and Company Fit

1. 13

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

   Connect your interest in online shopping, data accuracy, or product discovery to the role. Mention that you enjoy structured work and want to learn how large catalogs are managed.

2. 14

   What do you know about Ikea India's product range or online presence, and how does a catalog team support it?

   Show basic awareness of flat-pack furniture, home accessories, and the Indian market focus. Explain that a catalog team ensures every product is listed correctly for online and store channels.

3. 15

   Where do you see yourself in two years, and how does this role fit your growth?

   Say you want to become strong in catalog operations, learn PIM or ERP tools, and possibly move into merchandising, e-commerce operations, or data analysis. Keep it realistic and tied to the role.

4. 16

   Are you comfortable with a fixed shift, repetitive data tasks, and working from an office or warehouse location if required?

   Answer honestly but positively. Mention that you understand the nature of catalog work and are willing to adapt to the team's schedule and location needs.