Sanjaay Gowda T S
All company profiles

COMPANY CONTEXT / 68 IN THE STUDY LIST

Royal Bank of Canada

FinancialsCanadaSQL & data engineeringAI & machine learning

Royal Bank of Canada provides banking, wealth-management and other financial services.

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

SQL & data engineering

Generate reproducible synthetic account statements

Royal Bank of Canada · Concept

Original practice scenario: A fictional banking system receives backdated adjustments after a monthly statement is issued. How should its statement query support both original and corrected views?

Read model answer

Separate effective transaction time from knowledge time. Reproducing an issued statement requires the records known at issuance, while a corrected view may incorporate later accepted adjustments.

Work through it

  1. Store immutable event revisions with effective and recorded timestamps, and identify each statement by its cutoff and data snapshot.
  2. Apply accepted debit, credit and reversal rules within that snapshot, reconciling opening balance plus movements to closing balance in the account currency.
  3. Test late adjustments, timezone boundaries, duplicate events and a correction that changes a prior month; link corrected statements to the originals.

Tradeoffs to discuss

  • Bitemporal histories cost storage and query complexity but allow both operational reporting and faithful historical reproduction.

Common pitfalls

  • Do not overwrite the data that supported an issued statement.
  • A transaction date and its ingestion date answer different reporting questions.
Open full question
Original company-context practiceHard

AI & machine learning

Evaluate a bilingual synthetic support assistant

Royal Bank of Canada · Concept

Original practice scenario: A hypothetical Canadian banking support assistant answers English and French questions from fictional policy documents. How should language quality be evaluated?

Read model answer

Evaluate factual support and task completion separately from language fluency. Parallel translations can hide errors in terminology, regional phrasing or evidence retrieval across document languages.

Work through it

  1. Create matched and independently authored questions in both languages, including ambiguous requests, unsupported policies and code-switching where relevant.
  2. Score retrieval relevance, citation entailment, key terminology and appropriate inability responses using a documented rubric and qualified reviewers.
  3. Report results by language and question category, testing inconsistent document versions and preserving user language without inventing missing policy details.

Tradeoffs to discuss

  • Matched questions make comparisons easier but may underrepresent natural language differences; independent questions improve realism with less direct comparability.

Common pitfalls

  • Do not treat automatic translation quality as proof of correct financial policy.
  • Use synthetic account examples and avoid requesting private customer information.
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