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

Capgemini Business Analyst Interview Questions

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

38questions
~5htotal time
Track your progressSign up free to work through all 38 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 19 questions + 3 drills · ~182 min
SQL Find DuplicatesMedium
Recently asked

Evaluates SQL skills for detecting duplicates and optimizing query performance.

databasequery optimizationsqlCapgemini
Fetch Duplicates and Optimize JoinsMedium
Recently asked

Tests ability to write duplicate-detection SQL and optimize multi-table joins.

databasesqloptimizationCapgemini
DBMS vs NoSQL Use CasesMedium
Recently asked

Assesses understanding of relational vs NoSQL tradeoffs and when to apply each.

nosqldatabase conceptsCapgemini
Window Functions for DuplicatesMedium
Practice
Recently asked
Practice drill

Use window functions to flag duplicate worklogs and calculate project running totals with prior and next hour comparisons.

Window FunctionsData ManipulationsqlCapgemini
SQL Join and Group By PracticeHard
Practice
Practice drill

Join SAT data, aggregate monthly center performance, and compare average scores with LAG.

JoinsGroup BysqlThe College Board
Second-Highest Salary SQLMedium
Practice
Practice drill

Find the second-highest salary and department statistics using DENSE_RANK, LEFT JOIN, GROUP BY, and aggregate functions.

JoinsGroup Bysqlairtel
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership14 questions · ~112 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~40 min
Story Points and Sprint CeremoniesMedium
Recently asked

Assesses understanding of Agile planning concepts and collaboration practices.

AgileCapgemini
Measure Delivery SuccessMedium
Recently asked

Tests your approach to defining metrics, tracking progress, and ensuring outcomes.

Capgemini
GenAI and Agentic AIHard
Recently asked

Assesses understanding of modern AI concepts relevant to enterprise solutions.

GenAICapgemini
Dashboards You CreatedMedium
Recently asked

Evaluates ability to translate requirements into metrics and dashboard outputs.

dashboardsdata visualizationCapgemini
Explain RAG and LLM WorkHard
Recently asked

Evaluates technical depth and ability to reason through design choices in GenAI projects.

llmCapgemini

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 38 questions plus 3 hands-on drills to finish this plan.