Top 42
Prep plan
Updated weekly · Last refresh Aug 30

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 weekly.

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

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

SubqueriesRankingsalaryCapgemini 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
Understanding Primary Keys in DatabasesEasy

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

Capgemini FSSBU
Normalization: 3NF vs BCNFMedium

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

normalizationdata integrityData ModelingCapgemini FSSBU
SQL and Java Project ExperienceMedium

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

javaprojectssqlCapgemini FSSBU
Second Highest Trader SalaryEasy
Practice
Practice drill

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

SubqueriesRankingSortingeClinicalWorksInformaticaSpectraforce Technologies
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.

sqlTiger AnalyticsCognizantAntra
2
Behavioral & Leadership36 questions · ~298 min
Adapting to a New ToolEasy

Tests learning agility and ownership when adopting unfamiliar tools or techniques under real project pressure.

learning agilityToolsadaptabilityCapgemini FSSBU
Ensuring Data Accuracy at ScaleEasy

Tests ownership of data quality at scale, including validation process, risk communication, and accuracy under operational pressure.

processattention to detailQualityCapgemini FSSBU
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 42 questions plus 2 hands-on drills to finish this plan.