Walmart India Wholesale Supply Chain Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Supply Chain Analyst in e-commerce, retail, or D2C ensures products move efficiently from suppliers to customers by analysing demand, inventory, and logistics data. Day to day, they build forecasts, monitor stock levels, track delivery performance, and identify cost-saving or speed-improvement opportunities. They work closely with category managers, warehouse teams, and transport partners to keep the supply chain responsive and profitable.

Role and Technical Knowledge

1. 1

   What is the difference between safety stock and cycle stock in an e-commerce fulfilment centre?

   Explain safety stock as buffer against demand or lead-time variability, cycle stock as inventory to meet normal demand between replenishments. Give a small example from a fast-moving SKU.

2. 2

   How would you calculate reorder point for a product sold on a D2C website?

   Cover formula: (average daily sales x lead time) + safety stock. Mention that lead time includes supplier processing, transit, and receiving at warehouse.

3. 3

   What are OTIF and fill rate, and why do they matter in retail?

   OTIF means On Time In Full; fill rate is the percentage of customer demand met from available stock. Link them to customer satisfaction and penalty clauses with suppliers.

4. 4

   Explain how inventory turns impact working capital for a retailer.

   Higher turns mean faster selling and less cash tied up. Discuss trade-off with stockouts and the need to balance availability and cost.

Practical Scenarios and Case Questions

1. 5

   A top-selling SKU is showing 20 percent stockout rate in North India while South India has excess stock. How would you approach this?

   Start by validating data (stockout reasons, lead times, demand shift). Then propose inter-warehouse transfer, rebalancing safety stock, and adjusting regional forecast. Mention cost of transfer vs lost sales.

2. 6

   Last-mile delivery cost per order has increased by 15 percent in one month. What data would you pull and what actions would you suggest?

   Look at order density, delivery attempts, route efficiency, fuel surcharges, and return rates. Suggest route optimisation, batching, or partnering with local couriers for low-density areas.

3. 7

   You need to reduce overall supply chain cost by 10 percent without hurting customer experience. Where would you look first?

   Prioritise areas like inbound freight consolidation, warehouse space utilisation, packaging optimisation, and reducing expedited shipping. Quantify impact and quick wins.

4. 8

   During a festive sale, demand spikes 5x for certain categories. How would you plan inventory and logistics?

   Discuss pre-positioning stock, temporary warehouse space, extra last-mile capacity, and dynamic safety stock. Mention using historical sale data and real-time monitoring.

Behavioural and Situational Questions

1. 9

   Tell me about a time you had to analyse a large dataset to solve a problem. What was your approach?

   Use STAR format: situation, task, action (cleaning, pivot tables, SQL queries), result (insight that saved time or money). Keep it concise and quantifiable.

2. 10

   Describe a situation where you had to work with a team to meet a tight deadline. How did you handle it?

   Highlight clear communication, task division, and prioritisation. Show you can coordinate with different functions like operations, finance, or vendors.

3. 11

   Give an example of when you identified a process inefficiency and fixed it.

   Pick a college project or internship where you simplified a workflow, reduced errors, or saved time. Explain the measurable improvement.

4. 12

   How would you handle a conflict with a supplier who consistently delivers late?

   Show empathy but firmness: review data, discuss root cause, set improvement plan, and escalate if needed. Mention maintaining a backup supplier or safety stock.

HR and Motivation Questions

1. 13

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

   Connect personal interest in problem-solving and fast-paced environments to the visible impact of supply chain on customer experience. Mention specific aspects like demand planning or last-mile innovation.

2. 14

   Where do you see yourself in three years in this role?

   Show ambition to grow into senior analyst or category planning roles, and mention gaining expertise in forecasting, automation, or network design.

3. 15

   How do you stay updated with trends in supply chain and retail?

   Name a few sources like industry reports, LinkedIn learning, or news on quick commerce and AI in forecasting. Show curiosity and self-learning.

4. 16

   Are you comfortable working in shifts or during peak sale periods?

   Be honest but positive. Mention flexibility and willingness to support critical business periods, as retail supply chains run 24/7 during sales.