E-commerce, retail and D2C
Quikr India Supply Chain Analyst Interview: Rounds, Questions and Preparation
For Supply Chain Analyst roles at companies like Quikr India
What the job involves
A Supply Chain Analyst in e-commerce, retail, or D2C manages inventory planning, demand forecasting, order fulfilment, and logistics coordination to ensure products reach customers quickly and cost-effectively. Day to day, you track stock levels, analyse sales and delivery data, coordinate with warehouse and courier partners, and solve problems like stockouts, delayed shipments, or high return rates. At fast-growing companies like Quikr India, you often work with small teams and wear multiple hats across planning, operations, and vendor management.
Role and Technical Knowledge
- 1
What is the difference between safety stock and reorder point, and how would you calculate them for a fast-moving product?
A strong answer explains that safety stock is a buffer against demand or lead time uncertainty, while reorder point is the inventory level that triggers a new order. Mention formula like reorder point = (average daily demand x lead time) + safety stock, and give a simple example.
- 2
How would you measure the success of a supply chain operation in an e-commerce company?
Focus on metrics like order fill rate, on-time delivery, inventory turnover, cost per shipment, and return rate. Explain why each matters and how they connect to customer experience and profitability.
- 3
Explain how you would use Excel to analyse a dataset of daily orders and inventory levels.
Mention using pivot tables to summarise orders by SKU or region, VLOOKUP or INDEX-MATCH to combine inventory and sales data, and charts to spot trends. Show awareness of cleaning data before analysis.
- 4
What is the role of a 3PL partner in e-commerce fulfilment, and how would you coordinate with them?
Explain that a 3PL handles warehousing, packing, and shipping. Coordination involves sharing order forecasts, tracking SLAs, resolving delays, and conducting regular review calls. Show you understand both cost and service level trade-offs.
Practical Scenarios
- 5
A top-selling product is out of stock on your website, and customers are complaining. What steps would you take?
Start with immediate actions like checking incoming stock, prioritising pending orders, and updating the website. Then investigate root cause (forecast error, supplier delay) and suggest preventive measures like better safety stock or alternative sourcing.
- 6
You notice that delivery costs have increased by 20 percent in the last month. How would you investigate and reduce them?
Break down cost drivers: fuel, courier rates, zone mix, return shipments, or packaging. Suggest negotiating with couriers, optimising delivery routes, or encouraging prepaid orders. Show a data-driven approach using cost per order.
- 7
During a festive sale, demand spikes unexpectedly. How would you plan inventory and logistics to avoid stockouts and delays?
Talk about using historical sale data, pre-booking inventory with suppliers, setting up temporary warehouses or dark stores, and adding extra delivery capacity. Mention real-time monitoring and daily review meetings.
- 8
A supplier consistently delivers late, affecting your fill rate. How would you handle this vendor?
First review contract terms and penalties, then have a performance review meeting to understand their issues. Suggest alternatives like dual sourcing, buffer stock, or helping them improve. Show a balance between relationship and accountability.
Behavioural and Situational
- 9
Tell me about a time you had to prioritise multiple tasks under a tight deadline. How did you decide what to do first?
Use a real example from college projects, internships, or part-time work. Explain your criteria (impact, urgency, effort) and how you communicated your plan. Show that you are organised and calm under pressure.
- 10
Describe a situation where you worked in a team to solve a problem. What was your contribution?
Pick a team project or event. Highlight your specific role, how you coordinated with others, and the outcome. Emphasise listening, sharing credit, and adapting to team needs.
- 11
Have you ever made a mistake that affected a project or task? How did you handle it?
Choose a small, honest mistake. Focus on how you owned it, fixed it quickly, and what you learned to prevent it. Avoid blaming others or giving a fake weakness.
HR and Company Fit
- 12
Why do you want to work as a Supply Chain Analyst in e-commerce or D2C?
Connect your interest to the fast pace, data-driven decisions, and direct impact on customer experience. Mention specific aspects like solving real-time problems or learning about logistics technology.
- 13
How do you handle working in a fast-changing environment where priorities shift daily?
Give an example of adapting to change, such as a last-minute college event or internship task. Show you stay flexible, communicate proactively, and focus on solutions rather than complaints.
- 14
Where do you see yourself in three years in this role?
Show ambition to grow into a senior analyst or operations lead, while emphasising learning supply chain tools and business acumen. Avoid saying you want to leave the company or switch fields.
- 15
What do you know about our company and how does this role fit into it?
Research the company's business model (e-commerce, retail, D2C) and mention how supply chain supports it. For a company like Quikr India, talk about the importance of efficient listings, fulfilment, and customer trust in a growing marketplace.
Ready to try it for real?
Take a timed test or talk through a mock interview for this role, then see your scores.
This is practice material for Supply Chain Analyst roles, written with AI. It is not a list of questions Quikr India or any other company has asked.