Dataford
Top 25
Prep plan
Updated weekly · Last refresh Sep 22
C

CI Financial Data Engineer Interview Questions

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

25questions
~3htotal time
Track your progressSign up free to work through all 25 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 12 questions · ~96 min
Design an ETL Pipeline for Large DatasetsMedium
Recently asked

Design an ETL pipeline to process 10TB of data daily from multiple sources into a data warehouse with strict data quality checks.

InfrastructureETLData ModelingCCI Financial
Debugging Production Data PipelinesMedium
Recently asked

A structured approach to debugging production data pipelines, with focus on orchestration, data quality, idempotency, and safe backfills.

InfrastructureToolsQualityCCI Financial
Batch vs Streaming Data ProcessingEasy
Recently asked

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

Stream ProcessingETLBatch ProcessingCCI Financial
Data Quality and Schema EvolutionMedium
Recently asked

Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.

schema evolutionData ModelingQualityCCI Financial
More Pipelines questions with a free account
2
SQL & Data Manipulation4 questions + 3 drills · ~62 min
Star vs Snowflake for Sales AnalyticsMedium
Recently asked

Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.

JoinsData WranglingGroup ByCCI Financial
SQL Joins and AWS SchedulingMedium
Recently asked

Assesses your SQL fundamentals and your ability to operationalize ETL scheduling on AWS for CI Financial.

CCI Financial
Partitioning and Indexing StrategyMedium
Recently asked

Assesses your ability to design warehouse performance and cost optimizations.

indexingpartitioningCCI Financial
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
Contact Center Agent Performance MetricsHard
Practice
Practice drill

Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.

ETLAggregationsData ModelingADP
Cleaning a Messy DatasetMedium
Practice
Practice drill

Filter invalid game events and normalize event names using PostgreSQL string and null handling.

missing valuesdata cleaningnull handlingQuantiumScopelyCarvana
More SQL & Data Manipulation 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
3
Behavioral & Leadership9 questions · ~72 min
Reconciling Competing Client RequirementsMedium
Recently asked

Tests conflict resolution across stakeholders, especially how you prioritize competing requirements and drive alignment to a clear outcome.

Stakeholder Managementclient managementconflicting requirementsCCI Financial
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 25 questions plus 3 hands-on drills to finish this plan.