Sanjaay Gowda T S
All company profiles

COMPANY CONTEXT / 84 IN THE STUDY LIST

Commonwealth Bank of Australia

FinancialsAustraliaData scienceSQL & data engineering

Commonwealth Bank provides banking and other financial services in Australia and other 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 practiceMedium

Data science

Evaluate a simpler onboarding flow

Commonwealth Bank of Australia · Concept

Original practice scenario inspired by Commonwealth Bank of Australia's public business context; this is not a reported interview question or a description of its internal systems. A fictional banking app tests a shorter onboarding flow. Completion improves, but support contacts and later document corrections also rise. How would you decide whether the experiment supports rollout?

Read model answer

Predefine the primary outcome and guardrails across the whole onboarding journey. Faster completion is useful only in the context of eligibility, downstream correction, and customer-support costs.

Work through it

  1. Randomize at the applicant level and keep assignment stable across devices. Define the eligible population and measure intent-to-treat completion within a fixed follow-up window.
  2. Check assignment balance, event completeness, and repeat applicants. Report absolute effects and uncertainty for completion, corrections, and support contacts.
  3. Inspect whether follow-up is mature enough to observe delayed issues. Decide using prespecified guardrails and a reversible staged rollout rather than choosing only favorable metrics.

Tradeoffs to discuss

  • A shorter test delivers answers sooner but may miss delayed operational consequences. Multiple guardrails need a clear decision policy, not selective significance hunting.

Common pitfalls

  • Analyzing only completed applicants conditions on an outcome changed by treatment.
  • A relative lift without base rates hides practical effect size.
Open full question
Original company-context practiceHard

SQL & data engineering

Reconstruct a statement as of its cutoff

Commonwealth Bank of Australia · Concept

Original practice scenario inspired by Commonwealth Bank of Australia's public business context; this is not a reported interview question or a description of its internal systems. A synthetic account ledger has booking_time, effective_day, amount_cents, and correction relationships. Explain how to produce a reproducible statement for a historical cutoff without accidentally including later-known corrections.

Read model answer

Specify whether the statement represents knowledge at publication or a later restatement. Booking time controls what was known; effective day controls the business period to which an entry belongs.

Work through it

  1. Filter entries to booking_time at or before the recorded statement cutoff, then apply the documented effective-day range. Keep both timestamps in the audit trail.
  2. Aggregate signed ledger entries, treating reversals and corrections according to their explicit relationships. Do not silently overwrite original posted amounts.
  3. Persist statement parameters and source watermark. Test a late correction effective in the earlier month, an exact cutoff boundary, and a reversal arriving after publication.

Tradeoffs to discuss

  • Immutable statement snapshots improve reproducibility but require a separate restatement process when later information changes the period.

Common pitfalls

  • Filtering only by effective day leaks later knowledge into the original statement.
  • Summing both an overwritten value and its adjustment can double-count the correction.
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