Dataford
Top 16
Prep plan
Updated weekly · Last refresh Aug 30

Natixis Corporate & Investment Banking Data Analyst Interview Questions

The questions to prepare for a Natixis Corporate & Investment Banking Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 2 drills · ~64 min
Second-Highest Transaction Amount QueryMedium
Practice

Find the second-highest distinct transaction amount using a subquery in PostgreSQL without LIMIT.

SubqueriesRankingsalaryNatixis Corporate & Investment Banking
LEFT JOIN vs INNER JOINEasy

Explain how INNER JOIN and LEFT JOIN differ when analyzing matched and unmatched records in SQL.

null handlingJoinsData WranglingNatixis Corporate & Investment Banking
Handling NULLs in AveragesEasy

Tests your SQL and data-cleaning approach for accurate financial metrics with missing values.

null handlingfinancial dataData WranglingNatixis Corporate & Investment Banking
Optimizing Slow SQL QueriesHard

Tests query optimization skills, including execution plans and performance tuning strategies.

SubqueriesPerformance TuningsqlNatixis Corporate & Investment Banking
SQL Basics and JoinsEasy

Tests SQL fundamentals and practical decision-making for joins and data retrieval.

basicssqlNatixis Corporate & Investment Banking
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
SQL Expected vs Actual ComparisonHard
Practice
Practice drill

Compare expected and actual 6sense QA results using a FULL OUTER JOIN, aggregation, NULL-safe comparisons, and CASE status logic.

SubqueriesJoinsData Wrangling6senseApex Systems
2
Behavioral & Leadership10 questions · ~88 min
Correcting a Critical Data AnomalyMedium

Tests ownership and analytical rigor in finding, fixing, and preventing a data anomaly with business impact.

Data WranglingProblem Solvingtechnical experienceNatixis Corporate & Investment Banking
Prioritizing Competing Urgent RequestsMedium

Tests prioritization under pressure, stakeholder management, and decision-making when urgent analytical requests compete.

cross-functionalStakeholder ManagementPrioritizationNatixis Corporate & Investment Banking
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~9 min
KPIs for Daily Market ExposureMedium

Tests your ability to define relevant KPIs for risk and market exposure reporting.

kpi hierarchyNatixis Corporate & Investment Banking

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 16 questions plus 2 hands-on drills to finish this plan.