Bank
JPMorgan interview themes
What people report studying for — not a take-home dump. Last editorial update 2026-07-30.
Rounds you should expect
Modeling
SCD2 on a customer dimension. Point-in-time join to a fact. Who owns the grain.
From the question bank
medium · SQL · SQL
A join exploded revenue. How do you find the grain mismatch in five minutes?
Practice →easy · SQL · SQL
CROSS JOIN a 10-row parameter table to a 10M-row fact. When is that correct?
Practice →medium · Cloud · AWS
Glue job vs Lambda vs EMR. Who owns a 40-minute Spark transform?
Practice →medium · Cloud · AWS
CDC from RDS to the lake. Sketch the path.
Practice →easy · Cloud · Azure
Key Vault references vs a secret in an ADF global parameter. What do you say in a bank interview?
Practice →medium · Orchestration · Dagster
When do you keep Airflow instead of moving to Dagster?
Practice →easy · Warehouse · Trino
When is federation the wrong design?
Practice →