Scotiabank Data Engineer Interview Questions
The questions to prepare for a Scotiabank Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Set up CI CD and automated testing for data pipelines so changes ship faster with fewer production issues.
Approach for stabilizing an automated workflow that is failing broadly, with focus on orchestration, data quality, idempotency, and rollback.
Explain how you improved a slow ETL pipeline on multi-terabyte data, including bottleneck analysis, tuning choices, and validation.
Approach for managing data pipeline infrastructure as code, including orchestration, drift control, and operational monitoring.
Explain practical SQL techniques to preserve data integrity when combining multiple data sources.
Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.
Evaluates your troubleshooting and performance tuning approach for real workloads.
Find the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.
JPMorganChase
Silicon Valley Bank
Banco SantanderCalculate each Scotiabank customer's rolling 30-day transaction average using PostgreSQL window functions and date-based frames.
Ascendion
LendbuzzAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests mentorship and coaching through a concrete example of helping a teammate build a meaningful skill and deliver better results.