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

CGI Data Engineer Interview Questions

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

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 13 questions + 1 drill · ~121 min
Top 5 Products Per MonthMedium
Practice
Recently asked

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

sqlCGI
Top Customers by Sales RevenueEasy
Practice
Recently asked

Use GROUP BY and SUM to rank the top 10 customers by total revenue from a single sales table.

RankingGroup ByAggregationsCGI
Left Join ExampleEasy
Recently asked

Tests basic SQL join knowledge and correct usage.

JoinssqlCGI
BI Tools Trade-offsEasy
Practice
Recently asked
Practice drill

Aggregate BI tool feedback to show each tool's good sides, bad sides, review count, and average rating.

analytics toolsbi toolsAggregationsCGICgi Nederland
More SQL & Data Manipulation questions with a free account
2
Pipelines18 questions · ~153 min
Partitioning vs Bucketing at ScaleMedium
Recently asked

Design a Hive/Spark pipeline for Meta-scale event tables and explain when to use partitioning vs bucketing for performance and maintainability.

CGI
Choose Delta for Lakehouse PipelinesEasy
Recently asked

Design a Databricks lakehouse pipeline and defend choosing Delta Lake over Iceberg and Hudi for mixed batch and streaming workloads.

CGI
Backfill Without Duplicate RecordsHard
Recently asked

Approach for rerunning failed pipeline ranges and correcting data safely with idempotent writes and quality checks.

IdempotencyBackfillingQualityCGI
More Pipelines 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
Coding3 questions · ~26 min
PySpark Deduplication With ConflictsMedium
Recently asked

Tests ability to design correct deduplication logic across multi-source ingestion in PySpark.

Hash TablesArraysSortingCGI
Python or PySpark TransformationEasy
Recently asked

Tests practical coding ability for data transformations in Python or PySpark.

Hash TablesArraysStringsCGI
More Coding questions with a free account
4
Behavioral & Leadership16 questions · ~136 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 50 questions plus 1 hands-on drill to finish this plan.