Top 41
Prep plan
Updated weekly · Last refresh Oct 17

Capgemini FSSBU Data Analyst Interview Questions

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

41questions
~6htotal time
Track your progressSign up free to work through all 41 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 1 drill · ~62 min
Second-Highest Transaction Amount QueryMedium
Practice

Find the second-highest distinct transaction amount using a subquery in PostgreSQL without LIMIT.

SubqueriesRankingsalaryCapgemini FSSBU
Understanding Primary Keys in DatabasesEasy

Explain the concept of a primary key and its importance in database design.

Capgemini FSSBU
Join Types in Transaction DataEasy

Explain INNER JOIN vs LEFT JOIN and describe a many-to-one relationship using card transaction data.

JoinsData Wranglingmany-to-oneCapgemini FSSBU
SQL and Java Project ExperienceMedium

Assesses your SQL and programming experience and how you applied it in project work.

javaprojectssqlCapgemini FSSBU
Group Transactions by AccountEasy
Practice

Aggregate transaction amounts by account and exclude accounts whose total exceeds $10,000.

Group ByHavingAggregationsCapgemini FSSBU
Normalization: 3NF vs BCNFMedium

Tests relational modeling knowledge and the ability to reason about normalization constraints.

normalizationdata integrityData ModelingCapgemini FSSBU
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
2
Behavioral & Leadership34 questions · ~292 min
Translating Analysis Into StrategyMedium

Tests whether you can turn complex analysis into clear business recommendations and influence non-technical stakeholders to act.

impactCommunicationquantitative problem solvingCapgemini FSSBU
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~9 min
The finish line: interview-readyComplete all 41 questions plus 1 hands-on drill to finish this plan.