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

Cgi Nederland Data Engineer Interview Questions

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

44questions
~6htotal time
Track your progressSign up free to work through all 44 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 12 questions + 2 drills · ~124 min
Top 5 Products Per MonthMedium
Practice

Rank completed product sales by month using joins, aggregation, date truncation, and ROW_NUMBER().

sqlCgi Nederland
OLTP vs OLAP Database DesignMedium

Explain OLTP vs OLAP designs, including schema shape, workload patterns, and when each is appropriate in a data platform.

financial dataperformanceData ModelingCgi Nederland
SCD Type 2 and LookupsMedium

Evaluates slowly changing dimension handling and data flow concepts in ETL.

Cgi Nederland
Group By in SQLMedium
Practice
Practice drill

Summarize quarterly work logs by team, including teams with no matching logs and separate completed and open hours.

null handlingJoinsGroup ByCgi Nederland
SQL Running Total with CTEsMedium
Practice
Practice drill

Calculate each client's chronological transaction running total using CTEs and window functions.

Window FunctionsData ManipulationCTEsCgi Nederland
More SQL & Data Manipulation questions with a free account
2
Coding3 questions · ~26 min
Flatten Nested Lists in PythonEasy
Practice

Flatten arbitrarily nested lists while preserving order using depth-first traversal.

RecursionStackArraysCgi Nederland
PySpark Data Transformation ImplementationMedium

Tests your practical PySpark skills for building reliable data transformations.

Hash TablesArraysSortingCgi Nederland
More Coding 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
Pipelines11 questions · ~96 min
Handling Pipeline Errors at ScaleHard

Approach for stabilizing an automated workflow that is failing broadly, with focus on orchestration, data quality, idempotency, and rollback.

IdempotencyBackfillingQualityCgi Nederland
Consistency Across Data SourcesMedium

Approach for keeping records aligned and trustworthy when multiple source systems feed the same pipeline.

InfrastructureQualityCgi Nederland
Choosing Batch vs Real TimeHard

Evaluate when a pipeline should use stream processing versus scheduled batch based on latency, cost, complexity, and data quality needs.

Stream ProcessingBatch ProcessingDependenciesCgi Nederland
More Pipelines questions with a free account
4
Behavioral & Leadership18 questions · ~157 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 44 questions plus 2 hands-on drills to finish this plan.