Dataford
Dataford
Top 17
Prep plan
Updated weekly · Last refresh Oct 17

CIBC Data Engineer Interview Questions

The questions to prepare for a CIBC Data Engineer interview. Questions from real interview reports rank first. Updated daily.

17questions
~2htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 3 drills · ~62 min
SQL, PySpark, and Azure StackMedium
Recently asked

Tests your practical SQL and PySpark capability and your experience building on the Azure data stack.

pysparksqlCIBC
Diagnose Slow ETL Query BottlenecksHard
Recently asked

Tests performance troubleshooting and optimization of ETL SQL workloads.

JoinsCTEsquery optimizationCIBC
Model Daily Account Balance ChangesMedium
Recently asked

Tests data modeling choices for financial time-series tracking and correctness.

Date FunctionsRunning TotalsData ModelingCIBC
SQL, Java, Polymorphism, JoinsHard
Practice
Recently asked
Practice drill

Use joins and conditional logic to summarize polymorphic account activity while retaining accounts with no recent events.

javaJoinsData ManipulationCIBC
Schema Design ScenarioHard
Practice
Practice drill

Design a normalized account schema and produce balances, owners, latest activity, and type-level rankings.

data relationshipsschema designnormalizationCIBC
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
More SQL & Data Manipulation questions with a free account
2
Pipelines8 questions · ~64 min
Core Spark and Storage ConceptsMedium
Recently asked

Evaluates your understanding of Spark execution, Python fundamentals, and data format choices for performance.

distributed systemssparkCIBC
Spark RDD vs DataFrameMedium
Recently asked

Tests Spark fundamentals and the ability to choose the right abstraction for pipelines.

InfrastructureToolsData ModelingCIBC
Data Quality During On-Prem to Cloud MigrationMedium
Recently asked

Tests data validation, reconciliation, and governance practices during migrations.

InfrastructureETLQualityCIBC
Handle Late-Arriving DataMedium
Recently asked

Tests event-time vs processing-time handling and resilient pipeline design.

IdempotencyDependenciesBackfillingCIBC
More Pipelines questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership5 questions · ~40 min
Prioritizing Conflicting High-Stakes WorkEasy
Recently asked

Tests prioritization under pressure, stakeholder management, and ownership when multiple urgent requests compete for limited time.

Stakeholder ManagementOwnershipDealing With AmbiguityCIBC
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 17 questions plus 3 hands-on drills to finish this plan.