Top 32
Prep plan
Updated weekly · Last refresh Oct 17

Capgemini Government Solutions Business Analyst Interview Questions

The questions to prepare for a Capgemini Government Solutions Business Analyst interview. Questions from real interview reports rank first. Updated daily.

32questions
~4htotal time
Track your progressSign up free to work through all 32 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 3 drills · ~102 min
Sorting Key-Value PairsMedium

Tests ability to reason about sorting and data structures for key-based ordering.

SortingData StructuresCapgemini Government Solutions
PDF Manipulation with PythonMedium

Assesses practical data handling and scripting skills for document processing.

pythonCapgemini Government Solutions
Palindrome Check LogicMedium

Tests problem-solving and correctness reasoning for a palindrome-check algorithm.

AlgorithmsCapgemini Government Solutions
Verilog Half AdderHard

Tests ability to translate digital logic into working hardware description code.

Capgemini Government Solutions
Truth Tables for Logic GatesMedium

Assesses understanding of digital logic and ability to reason about boolean outputs.

Capgemini Government Solutions
Second Highest Trader SalaryEasy
Practice
Practice drill

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingeClinicalWorksNNeenOpal CanadaInformatica
Optimize a Slow SQL QueryHard
Practice
Practice drill

Rewrite a slow PostgreSQL loan payment query to reduce scanned rows while preserving the required aggregated results.

database optimizationJoinsData WranglingAmeripriseEEltro Cyberchrome PrivateEnergyHub
Second Largest Salary QueryEasy
Practice
Practice drill

Use DENSE_RANK and a join to find the second-highest distinct salary among active CGS program employees.

sqlCapgemini Government SolutionsCapgemini FSSBUCognizant
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership21 questions · ~168 min
Walking Through Resume ProjectsEasy

Tests project ownership, prioritization, and communication by asking you to explain resume work with clear scope, decisions, and impact.

Stakeholder ManagementCommunicationOwnershipCapgemini Government Solutions
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
Describe Agile Delivery ExperienceEasy

Explain how you’ve applied Agile in practice, including Scrum ceremonies, backlog management, and stakeholder alignment.

Launch PlanningTrade-offsRoadmappingCapgemini Government Solutions
Documenting Evolving RequirementsMedium

Tests your approach to maintaining clarity and traceability as requirements change.

Scope ManagementProject ManagementCapgemini Government Solutions

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 32 questions plus 3 hands-on drills to finish this plan.