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

Intercontinental Exchange Holdings Data Analyst Interview Questions

The questions to prepare for a Intercontinental Exchange Holdings Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

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. 6 questions + 1 drill · ~63 min
Second Highest Without AggregatesHard
Practice

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsIntercontinental Exchange Holdings
Second Highest Trader SalaryEasy
Practice

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingIntercontinental Exchange Holdings
Subquery vs CTE vs Temp TableMedium

Explain performance and tradeoffs between subqueries, CTEs, and temporary tables in a PostgreSQL data pipeline.

SubqueriesperformanceCTEsIntercontinental Exchange Holdings
Handle Duplicate Records in JoinsMedium

Tests data integrity and SQL strategy for deduplication during multi-table joins at scale.

null handlingJoinsdata integrityIntercontinental Exchange Holdings
Python DataFrame Column DifferenceMedium

Tests your ability to perform common DataFrame transformations for analysis and reporting.

Data ManipulationpythonIntercontinental Exchange Holdings
Second-Highest Transaction for AdvisorMedium
Practice
Practice drill

Use DENSE_RANK and a join to find the second-highest distinct posted transaction for a Raymond James advisor account.

Subqueriesfinancial dataRankingRaymond James Financial Services
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership24 questions · ~210 min
Explaining Technical Issues to ExecutivesEasy

Tests communication and influence: can you translate technical complexity into business decisions, align stakeholders, and drive action?

Influence Without AuthorityStakeholder ManagementCommunicationIntercontinental Exchange Holdings
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~18 min
Cleaning Missing Values in PipelinesEasy

Approach for handling missing values in a pipeline with data quality checks and repeatable transformations.

Data WranglingETLQualityIntercontinental Exchange Holdings
Validate Volatile Market FeedsHard

Tests pipeline design for validating noisy, volatile market data in ICE systems.

financial datadata validationQualityIntercontinental Exchange Holdings

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 32 questions plus 1 hands-on drill to finish this plan.