Dataford
Dataford
Top 33
Prep plan
Updated weekly · Last refresh Oct 17

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

33questions
~5htotal time
Track your progressSign up free to work through all 33 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 8 questions · ~76 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
Python DataFrame Column DifferenceMedium

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

Data ManipulationpythonIntercontinental Exchange Holdings
SQL, Python, and Power BI BasicsMedium

Assesses practical familiarity with core analytics tools used in the role.

Data AnalysissqlpythonIntercontinental Exchange Holdings
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership23 questions · ~217 min
Handling Silence After an AssessmentEasy

Tests resilience, professionalism, and ownership when effort isn't reciprocated with feedback or closure.

resilienceCommunicationfeedbackIntercontinental Exchange Holdings
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~19 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 33 questions to finish this plan.