Top 24
Prep plan
Updated weekly · Last refresh Oct 17

Intercontinental Exchange Data Engineer Interview Questions

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

24questions
~4htotal time
Track your progressSign up free to work through all 24 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 8 questions · ~78 min
Batch vs Streaming Data ProcessingEasy

Compare batch and streaming data processing, including when each fits best in a pipeline.

Stream ProcessingETLBatch ProcessingIntercontinental Exchange
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityIntercontinental Exchange
Real-Time Market Data Pipeline DesignHard

Design a resilient streaming and batch pipeline for ingesting, validating, storing, and serving ICE market data.

system designdata pipelinedata pipelinesIntercontinental Exchange
More Pipelines questions with a free account
2
SQL & Data Manipulation3 questions + 1 drill · ~39 min
SQL and Data Warehouse ConceptsMedium
Practice

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

JoinsCTEssqlIntercontinental Exchange
GROUP BY vs PARTITION BYMedium
Practice

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

Group Bysqldatabase queryingIntercontinental Exchange
Query Performance OptimizationMedium

Tests your ability to improve SQL performance using tuning, indexing, and execution-plan reasoning.

data engineeringquery optimizationIntercontinental Exchange
Second Highest Trader SalaryEasy
Practice
Practice drill

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

SubqueriesRankingSortingeClinicalWorksNNeenOpal CanadaInformatica
3
Behavioral & Leadership11 questions · ~107 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~19 min
Python Class and Config BasicsMedium
Practice

Implement a Python application entry point with class instantiation, INI configuration, and a command-line DEBUG logging override.

CodingDevOpscode structureIntercontinental Exchange
Write an If Statement in ShellEasy

Assesses basic shell scripting control flow used in data pipelines and automation.

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