Fabindia Retail Supply Chain Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Supply Chain Analyst in e-commerce, retail, and D2C ensures products move efficiently from suppliers to customers. Day to day, you analyse demand forecasts, inventory levels, and logistics data to optimise costs and improve delivery speed. At a company like Fabindia Retail, you might work on vendor performance, warehouse operations, and last-mile delivery analytics.

Role and Technical Knowledge

1. 1

   How would you calculate safety stock for a fast-moving ethnic wear product at Fabindia?

   Explain safety stock formula using demand variability and lead time. Mention factors like seasonality and supplier reliability.

2. 2

   What are the key differences between push and pull supply chain strategies in e-commerce?

   Define push (forecast-driven) and pull (demand-driven). Give examples from retail like pre-orders vs made-to-order.

3. 3

   Explain OTIF and how it impacts customer satisfaction in D2C.

   Define On-Time-In-Full. Link to repeat purchases and brand loyalty. Suggest ways to improve OTIF.

4. 4

   How would you use SQL to analyse order delivery delays?

   Describe joining order, shipment, and carrier tables. Calculate average delay per carrier or region. Mention filtering by date.

Practical Scenarios

1. 5

   During festive season, Fabindia sees a sudden spike in orders but inventory is stuck at a warehouse due to a carrier strike. What do you do?

   Prioritise high-value orders, reroute via alternate carriers, communicate delays to customers, and update inventory visibility.

2. 6

   A key supplier of handloom fabrics is consistently late by 2 weeks. How would you mitigate this?

   Analyse root cause, negotiate buffer stock, identify backup suppliers, and adjust lead times in planning systems.

3. 7

   You notice that return rates for a particular product category are high. How would you investigate and reduce them?

   Segment returns by reason (size, quality, damage). Work with quality and product teams. Suggest better size charts or packaging.

4. 8

   Your warehouse is running out of space before Diwali. How do you optimise storage and flow?

   Prioritise fast-moving SKUs, use vertical storage, cross-dock, and temporarily lease overflow space. Coordinate with demand planning.

Behavioural and HR

1. 9

   Tell me about a time you used data to solve a problem. What was the outcome?

   Use STAR method. Highlight analysis, action, and measurable result. Link to supply chain if possible.

2. 10

   Why do you want to work in supply chain at a retail or D2C company like Fabindia?

   Show passion for retail, e-commerce growth, and problem-solving. Mention Fabindia's unique supply chain of artisans.

3. 11

   Describe a situation where you had to work under pressure with tight deadlines.

   Focus on prioritisation, communication, and staying calm. Give a concrete example from academics or internships.

4. 12

   How do you handle conflicting priorities from different stakeholders?

   Explain active listening, data-driven negotiation, and aligning with business goals. Give an example of resolving conflict.

Company and Sector Awareness

1. 13

   What are the main supply chain challenges for an omnichannel retailer like Fabindia?

   Discuss inventory visibility across stores and online, reverse logistics, and seamless returns. Mention integration of offline and online channels.

2. 14

   How does e-commerce impact traditional retail supply chains?

   Highlight demand volatility, last-mile delivery, and returns management. Explain how retailers adapt with dark stores and click-and-collect.

3. 15

   What metrics would you track to measure supply chain efficiency in D2C?

   List order cycle time, inventory turnover, perfect order rate, and cost per shipment. Explain why each matters.

4. 16

   How can supply chain analytics improve sustainability in retail?

   Discuss route optimisation to reduce emissions, packaging reduction, and local sourcing. Link to Fabindia's artisan-based model.