Sanjaay Gowda T S
All company profiles

COMPANY CONTEXT / 32 IN THE STUDY LIST

The Procter & Gamble Company

Consumer StaplesUnited StatesSoftware engineeringData science

P&G develops and markets consumer products across household, personal-care and related categories.

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

Software engineering

Release packaging artwork against the correct product version

The Procter & Gamble Company · Concept

Original practice scenario: A hypothetical consumer-products workflow approves label artwork for a formula, pack size and target market. The formula changes while artwork is awaiting approval. Design version checks.

Read model answer

Make each artwork approval refer to an immutable bundle of product and market inputs. A status called approved is incomplete unless the system records exactly what was reviewed.

Work through it

  1. Identify formula revision, packaging specification, language, market and artwork asset fingerprint; record dependencies rather than copying only a product name.
  2. Invalidate or re-review affected approvals when an input changes, using explicit rules that distinguish cosmetic updates from changes requiring authorized specialist review.
  3. Before publication, compare the approved bundle with the production request and retain a release manifest linking all versions and decisions.

Tradeoffs to discuss

  • Fine-grained dependency checks reduce repeated review but require maintained impact rules; a broader invalidation policy is simpler and more conservative.

Common pitfalls

  • Never assume an unchanged filename contains unchanged artwork.
  • The workflow records review evidence and must not claim that technical matching alone establishes regulatory or labeling compliance.
Open full question
Original company-context practiceHard

Data science

Reconcile demand forecasts across products and regions

The Procter & Gamble Company · Concept

Original practice scenario: A hypothetical household-products planner forecasts individual SKUs, brand totals and regional totals independently. The forecasts disagree. How would you construct a coherent evaluation?

Read model answer

Define the hierarchy and decision horizon, then assess both accuracy and consistency. Independently good forecasts can still imply impossible totals when their aggregation relationships are ignored.

Work through it

  1. Create an effective-dated product-region hierarchy, accounting for discontinued products and new pack sizes before building comparable historical series.
  2. Backtest bottom-up and other justified reconciliation approaches using the same rolling cutoffs, evaluating error at the levels where planning decisions are made.
  3. Preserve nonnegativity or other required constraints and inspect intermittent-demand products separately, comparing coherence and error with unreconciled baselines.

Tradeoffs to discuss

  • Bottom-up forecasts preserve detailed relationships but can be noisy for sparse SKUs; aggregate information may stabilize estimates while reducing local flexibility.

Common pitfalls

  • Do not reconcile against hierarchy memberships that were unknown at the historical forecast date.
  • A coherent set of totals is not necessarily an accurate forecast, so both properties need separate checks.
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