Top 27

Prep plan

Updated weekly · Last refresh Oct 17

Intercontinental Exchange Data Analyst Interview Questions

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

27questions

~4htotal time

Track your progressSign up free to work through all 27 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 6 questions + 2 drills · ~71 min

Second Highest Trader SalaryEasy

Practice

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

SubqueriesRankingSorting

Intercontinental Exchange

Explain SQL Join TypesEasy

Explain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.

JoinsData WranglingGroup By

Intercontinental Exchange

Handling Missing and Dirty SQL DataMedium

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQuality

Intercontinental Exchange

Subtracting Columns in a DataFrameMedium

Tests hands-on ability to manipulate columns in Python for analysis.

Data Manipulationpython

Intercontinental Exchange

SQL, Python, and Power BI BasicsMedium

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

Data Analysissqlpython

Intercontinental Exchange

SQL Join Two TablesMedium

Tests SQL join skills for combining production and sales datasets.

Data Analysis

Intercontinental Exchange

GROUP BY vs PARTITION BYMedium

Practice

Practice drill

Demonstrate how GROUP BY collapses rows while PARTITION BY preserves detail for venue-level trade totals.

Group Bysqldatabase querying

Intercontinental Exchange Holdings

Intercontinental Exchange

SQL and Data Warehouse ConceptsMedium

Practice

Practice drill

Use PostgreSQL CTEs and joins to identify current, delayed, failed, and missing real-time warehouse pipeline loads.

JoinsCTEssql

Intercontinental Exchange

Behavioral & Leadership20 questions · ~169 min

Ensuring Data Accuracy at ScaleEasy

Tests ownership of data quality at scale, including validation process, risk communication, and accuracy under operational pressure.

processattention to detailQuality

Intercontinental Exchange

More Behavioral & Leadership 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

The finish line: interview-readyComplete all 27 questions plus 2 hands-on drills to finish this plan.