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

CGI Analytics Engineer Interview Questions

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

7questions
~1htotal time
Track your progressSign up free to work through all 7 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 4 questions · ~32 min
Version Control for Code and DataEasy

Explain how to version pipeline code and datasets so teams can collaborate, reproduce results, and track changes safely.

Data QualityToolsversion controlCGI
Optimize a Pipeline BottleneckMedium

Explain how you identified and fixed a bottleneck in a data pipeline while preserving correctness and operational visibility.

data processingperformancebottleneck optimizationCGI
ETL vs ELT Trade-offsEasy

Compare ETL and ELT, and explain when ELT is the better pipeline pattern.

ETLELTData ModelingCGI
Data Quality in ETL PipelinesEasy
Recently asked

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityCGI
2
More topics3 questions · ~24 min
Optimizing Slow PostgreSQL Research QueriesMedium

Explain how you diagnosed and optimized a slow PostgreSQL query using execution plans, indexing, and query rewrites.

JoinsData WranglingAggregationsCGI
Prioritizing Conflicting Cross-Functional DeadlinesMedium

Tests prioritization under pressure, stakeholder management, and decision-making when multiple teams compete for limited analyst capacity.

Conflict Resolutiontime managementPrioritizationCGI
Explaining a Technical Concept ClearlyEasy

Tests communication, ownership, and stakeholder management when translating technical complexity into actionable business understanding.

Problem SolvingData Structurestechnical fundamentalsCGI

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Top Customers by Sales RevenueEasy
Practice
Recently asked
Practice drill

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

RankingGroup ByAggregationsHousecall ProEquifaxXYZ
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
Top 5 Products Per MonthMedium
Practice
Recently asked
Practice drill

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

sqlCGICgi NederlandCGI Group
The finish line: interview-readyComplete all 7 questions plus 3 hands-on drills to finish this plan.