CGI Group Data Engineer Interview Questions

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

sqlCGI Group

Rank Genesys Cloud customers by completed revenue using aggregation, a CTE, and ROW_NUMBER().

Window FunctionsRankingAggregationsCGI Group

Design a streaming pipeline that keeps dashboard data fresh and accurate for operational reporting.

InfrastructureStream ProcessingOrchestrationCGI Group

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

Stream ProcessingBatch ProcessingDependenciesCGI Group

Tests intrinsic motivation for data engineering and whether the candidate turns continuous learning into practical impact.

CommunicationLeadershipOwnershipCGI Group

Evaluates ability to write efficient Python for large-scale data processing.

Hash TablesArraysSortingCGI Group