Top 28
Prep plan
Updated weekly · Last refresh Aug 30

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

28questions
~4htotal time
Track your progressSign up free to work through all 28 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 2 drills · ~71 min
Second Highest Trader SalaryEasy
Practice
Recently asked

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

SubqueriesRankingSortingIntercontinental Exchange
Handling Missing and Dirty SQL DataMedium
Recently asked

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

Data WranglingCase WhenQualityIntercontinental Exchange
Explain SQL Join TypesEasy
Recently asked

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

JoinsData WranglingGroup ByIntercontinental Exchange
SQL Join Two TablesMedium

Tests SQL join skills for combining production and sales datasets.

Data AnalysisIntercontinental Exchange
Subtracting Columns in a DataFrameMedium

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

Data ManipulationpythonIntercontinental Exchange
SQL, Python, and Power BI BasicsMedium

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

Data AnalysissqlpythonIntercontinental Exchange
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
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
2
Behavioral & Leadership21 questions · ~177 min
Adapting to Mid-Project Requirement ChangesMedium
Recently asked

Tests adaptability under changing requirements, including reprioritization, ownership, and execution in ambiguity.

OwnershipDealing With AmbiguityPrioritizationIntercontinental Exchange
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
Statistical Analysis ExperienceMedium

Assesses capability to apply statistics to real analysis problems.

analyticsIntercontinental Exchange

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 28 questions plus 2 hands-on drills to finish this plan.