Sanjaay Gowda T S
All company profiles

COMPANY CONTEXT / 12 IN THE STUDY LIST

Walmart Inc.

Consumer StaplesUnited StatesSystem designData science

Walmart operates retail stores and digital commerce serving customers across multiple markets.

Original company-context practice, not verified company interview questions. Use the business setting to explain technical choices clearly.

01 / PRACTICE IN CONTEXT

Two problems to reason through.

Clarify assumptions before reading the model answer. Discuss what would change with different constraints.

Original company-context practiceHard

System design

Coordinate grocery substitutions with customer decisions

Walmart Inc. · Concept

Original practice scenario: Design a hypothetical grocery fulfillment workflow where a picker proposes a substitute, the customer may respond late, and the original item becomes available again.

Read model answer

Model the order line as a versioned decision workflow with a clear fulfillment cutoff. Stock availability, customer preference and picker action are related events rather than interchangeable truth.

Work through it

  1. Assign an order-line identity and record the proposed substitute, its price basis and the line version against which approval is requested.
  2. Accept a response only if it still matches the active proposal and cutoff; make repeated responses idempotent and expose conflicts to the picker.
  3. Record the actual picked item separately, reconciling it with the accepted decision and payment adjustment before finalizing fulfillment.

Tradeoffs to discuss

  • Waiting longer for customer input improves choice but can delay picking; defaults need a disclosed policy and an explicit unresolved state.

Common pitfalls

  • A late approval must not overwrite a newer rejection or an already completed pickup.
  • Handle quantity changes and price differences directly rather than assuming a substitute is always one equivalent unit.
Open full question
Original company-context practiceHard

Data science

Measure a promotion when stores start with different demand

Walmart Inc. · Concept

Original practice scenario: A hypothetical retail team compares promoted stores with other stores and sees higher sales. Propose an evaluation that distinguishes incremental demand from store selection and stock availability.

Read model answer

Define the promotion effect and eligible store-product population before comparing totals. High-demand stores and well-stocked locations may have been more likely to receive the promotion.

Work through it

  1. Prefer randomized assignment with comparable periods; otherwise document the selection mechanism and examine pre-promotion trends and relevant store differences.
  2. Measure sales alongside availability, price, returns and neighboring-product substitution, preserving stores with poor execution instead of quietly excluding them.
  3. Estimate effects with uncertainty and relevant store or product clusters, checking whether gains persist after the promotion and whether nearby sales were displaced.

Tradeoffs to discuss

  • A tightly controlled pilot strengthens attribution but may miss rollout constraints; a broader observational study needs more assumptions.

Common pitfalls

  • Do not compare only stores that successfully kept the product in stock after treatment.
  • A higher promoted-item total is not necessarily higher category demand or durable customer value.
Open full question

02 / STRENGTHEN THE FOUNDATIONS

Related technical practice.

Browse company questions

03 / TEST AN APPROACH

Suggested coding exercises.

Exercises selected for these technical tracks. They are independent practice with visible tests and public solutions.

Study list: PwC Global Top 100 companies by market capitalisation, 2026 · 31 March 2026.

Keep learning beyond the interview.

Explore the Learning Hub