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

Capgemini Business Analyst Interview Questions

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

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

Tests correct SQL filtering semantics for row-level vs group-level conditions.

Capgemini
Database Constraints and Joins ScenariosMedium
Recently asked

Assesses your ability to map schema constraints and join choices to practical cases.

Joinsdatabase conceptsCapgemini
SQL Basics and Data ModelingMedium
Recently asked

Assesses understanding of SQL concepts and how they relate to database systems.

sql basicsCapgemini
Ingestion Joins and PySpark DataFramesMedium
Practice
Recently asked
Practice drill

Return all columns from one table plus one column from another, and compare INNER JOIN with FULL JOIN.

pysparkJoinssqlCapgemini
SQL Transformations and RankingMedium
Practice
Recently asked
Practice drill

Return the top 3 non-null scores and handle ties using ranking logic.

Clusteringcomplex queriessqlCapgemini
SQL Query OptimizationMedium
Practice
Practice drill

Optimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.

Performance Tuningdatabase optimizationindexesDDroisysCapgeminiNomura
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership13 questions · ~104 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
Explain RAG and LLM WorkHard
Recently asked

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

llmCapgemini
Dashboards You CreatedMedium
Recently asked

Evaluates ability to translate requirements into metrics and dashboard outputs.

dashboardsdata visualizationCapgemini

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