Top 31
Prep plan
Updated weekly · Last refresh Aug 30

Bank Of Tokyo-Mitsubishi UFJ Data Engineer Interview Questions

The questions to prepare for a Bank Of Tokyo-Mitsubishi UFJ Data Engineer interview. Questions from real interview reports rank first. Updated weekly.

31questions
~4htotal time
Track your progressSign up free to work through all 31 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 10 questions + 2 drills · ~105 min
Customer Transaction Running TotalsEasy
Practice

Calculate each customer's cumulative transaction amount over time using a CTE and window function.

Window FunctionsDate FunctionsRunning TotalsBank Of Tokyo-Mitsubishi UFJ
Optimizing Slow PostgreSQL Research QueriesMedium

Explain how you diagnosed and optimized a slow PostgreSQL query using execution plans, indexing, and query rewrites.

JoinsData WranglingAggregationsBank Of Tokyo-Mitsubishi UFJ
Top Customers by Rolling VolumeEasy

Tests SQL skills for joins, windowing, and aggregation over large transaction datasets.

Window FunctionsJoinsRankingBank Of Tokyo-Mitsubishi UFJ
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
Contact Center Agent Performance MetricsHard
Practice
Practice drill

Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.

ETLAggregationsData ModelingADP
More SQL & Data Manipulation questions with a free account
2
Pipelines17 questions · ~144 min
Recover a Failed Batch JobHard

Handle a daily batch pipeline that fails midway through processing 100 million rows without duplicating data or breaking downstream tables.

Batch ProcessingIdempotencyBackfillingBank Of Tokyo-Mitsubishi UFJ
Backfill While Preserving Real TimeHard

Approach for running large historical backfills without breaking real-time pipeline freshness or correctness.

Stream ProcessingDependenciesBackfillingBank Of Tokyo-Mitsubishi UFJ
Design an ETL Pipeline for Large DatasetsMedium

Design an ETL pipeline to process 10TB of data daily from multiple sources into a data warehouse with strict data quality checks.

InfrastructureETLData ModelingBank Of Tokyo-Mitsubishi UFJ
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
Coding3 questions · ~25 min
Python or Java for Data EngineeringEasy

Tests practical coding experience for building and maintaining data processing systems.

javapythonprogramming languagesBank Of Tokyo-Mitsubishi UFJ
Maintainable ETL Code StructureMedium

Tests engineering practices for reliable ETL development, testing, and maintainability.

RecursionHash TablesSortingBank Of Tokyo-Mitsubishi UFJ
More Coding questions with a free account
4
More topics1 question · ~8 min
More questions with a free account
The finish line: interview-readyComplete all 31 questions plus 2 hands-on drills to finish this plan.