Top 19
Prep plan
Updated weekly · Last refresh Oct 17

Sumitomo mitsui financial group Data Analyst Interview Questions

The questions to prepare for a Sumitomo mitsui financial group Data Analyst interview. Questions from real interview reports rank first. Updated daily.

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 2 drills · ~55 min
Top Three Transactions Per AccountMedium
Practice

Write a SQL query using a window function to find the top three highest-value transactions for each customer account over the last 30 days at Sumitomo mits...

Window FunctionsDate FunctionsJoinsSumitomo mitsui financial group
Optimize Slow T-SQL AggregationsHard

Tests query performance tuning for large-scale compliance aggregations in SQL Server environments.

Performance TuningsqlAggregationsSumitomo mitsui financial group
Join Choice for Incomplete RecordsEasy

Tests understanding of join semantics and impact on screening analytics with incomplete customer data.

null handlingJoinsdata integritySumitomo mitsui financial group
Deduplicate in Oracle Without Breaking KeysMedium

Tests PL/SQL and data integrity techniques for deduplication in regulated financial datasets.

data integritySumitomo mitsui financial group
SQL for Operational PerformanceMedium
Practice
Practice drill

Use joins, conditional aggregation, and date filtering to measure Carvana location performance over the last 30 days.

Date FunctionsGroup ByAggregationsCarvanaGeorgetown UniversityPluralsight
Data Integrity in AnalysesMedium
Practice
Practice drill

Audit claims for missing members, invalid amounts, and payment totals that exceed billed amounts.

JoinsData Wranglingdata validationHealthfirst (New York)BBritvic Soft DrinksAttentive
2
Pipelines3 questions · ~26 min
Pandas Missing Data Before PowerBIEasy

Tests data cleaning practices and preparation for BI exports in a financial analytics workflow.

Data QualityToolsData WranglingSumitomo mitsui financial group
Regulatory Changes and Data PipelinesMedium

Tests ability to adapt data pipeline design to evolving AML regulatory requirements.

data integrationregulatory constraintsschema evolutionSumitomo mitsui financial group
Data Flow Diagram for Cross-Border PaymentsHard

Tests end-to-end thinking about data lineage, controls, and compliance checkpoints for cross-border payments.

ComplianceData ModelingSumitomo mitsui financial group

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 & Leadership12 questions · ~104 min
Choosing Visualization for Executive DecisionsEasy

Tests communication and stakeholder judgment in selecting visualization approaches that drive marketing decisions.

Stakeholder ManagementCommunicationOwnershipSumitomo mitsui financial group
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 19 questions plus 2 hands-on drills to finish this plan.