Dataford
Top 50
Prep plan
Updated weekly · Last refresh Aug 30

CGI Consultant Interview Questions

The questions to prepare for a CGI Consultant interview. Questions from real interview reports rank first. Updated weekly.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 14 questions · ~112 min
Ensure Quality Control in DeliveryMedium

Explain how you build quality control into delivery so releases meet standards without slowing execution.

Launch PlanningSuccess CriteriaRisk AssessmentCGI
Clarify Ambiguous Project RequirementsMedium

Explain how you turn vague requirements into aligned scope, clear decisions, and shared understanding for the team.

ClarityDealing With AmbiguityProject ManagementCGI
More Execution questions with a free account
2
Strategy5 questions · ~40 min
Tell Me About YourselfEasy

Tests your ability to deliver a clear, relevant introduction tailored to the role at Aqr.

Competitive AnalysisGo-to-MarketCGI
StrategyHard

Evaluates strategic thinking and ability to build a business case for CGI’s growth.

business strategyCGI
More Strategy 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 & Leadership27 questions · ~216 min
More Behavioral & Leadership questions with a free account
4
More topics4 questions · ~32 min
Roadmap With Competing PrioritiesMedium

Evaluates how you measure outcomes and adoption when driving change.

Change ManagementCGI
Big Data Tools and SkillsHard

Evaluates your practical experience with common data engineering technologies.

pysparksqlawsCGI
Motivation for the Consultant RoleEasy

Tests your fit and drive for consulting work and impact in a media organization like Condé Nast.

User NeedsValue PropositionCGI
SQL JoinsMedium

Assesses SQL fundamentals needed for data integration and analysis tasks.

JoinssqlCGI
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Top 5 Products Per MonthMedium
Practice
Practice drill

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

sqlCGICgi NederlandCGI Group
Top Customers by Sales RevenueEasy
Practice
Practice drill

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

RankingGroup ByAggregationsHousecall ProEquifaxXYZ
Top Earners via Table JoinMedium
Practice
Practice drill

Rank Motorola Solutions employees by total earnings using a LEFT JOIN, aggregation, COALESCE, and ROW_NUMBER.

JoinssqlMotorola SolutionsMotorola
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.