Top 32
Prep plan
Updated weekly · Last refresh Oct 17

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 daily.

32questions
~5htotal time
Track your progressSign up free to work through all 32 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 10 questions + 1 drill · ~109 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
SQL FundamentalsMedium
Practice

Use filtering and aggregation to summarize completed orders by customer.

JoinsData ManipulationGroup ByBank Of Tokyo-Mitsubishi UFJ
SQL for Branch PerformanceHard
Practice
Practice drill

Rank branches by transaction volume and exception rate using joins, aggregation, CTEs, and window functions.

JoinsGroup ByAggregationsBank Of Tokyo-Mitsubishi UFJ
More SQL & Data Manipulation questions with a free account
2
Pipelines17 questions · ~168 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
Monitor a Mission Critical PipelineMedium

Design a monitoring and alerting approach for a mission critical pipeline, covering system health, data quality, and operational response.

InfrastructureToolsQualityBank 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
Coding5 questions · ~49 min
Traverse Data Job DependenciesMedium
Practice

Traverse reachable data-job dependencies in deterministic breadth-first order using a queue and visited set.

RecursionQueuebfsBank 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
The finish line: interview-readyComplete all 32 questions plus 1 hands-on drill to finish this plan.