Capgemini Data Analyst interviews, as candidates describe them, mix resume and project walkthroughs with basic SQL, Python and BI questions, plus an HR conversation. Most reports describe 2-4 rounds and an easy-to-moderate difficulty.
$73K
Avg. Base Comp
$82K
Avg. Total Comp
2-4 rounds
Typical Rounds
Not reported
Process Length
Candidates describe the Capgemini Data Analyst interview as approachable but broad. The most consistent theme is that you need to explain your own projects in detail: your exact role, the tools you used, the challenges you hit and how you solved them. Several candidates were pressed on daily responsibilities or cross-questioned on a project's structure rather than given a high-level summary.
Technical questions are usually fundamentals. SQL comes up often, with reports of joins, second-highest and top-three salary rankings, anti-joins for customers with no orders, and the difference between a view and a materialized view. Python and Pandas questions include list versus tuple, reading a CSV and handling missing values, and one candidate was given short code snippets to read and explain. BI-focused candidates mention Power BI, DAX scenarios, Tableau, fact versus dimension tables, and one was asked how to design a dashboard. A few reports add general CS topics such as OOP, DBMS, sorting and simple coding tasks, so a light refresh is sensible.
The format varies. Some candidates describe an online aptitude, English and technical assessment before interviews, while others report a phone screen, a manager round or a client discussion, and an HR round covering fit, compensation and joining details. Total length varies by candidate, from results within a few days to calls spread over several weeks. Outcomes are mostly offers, though some candidates received none or declined, so go in ready to communicate clearly in English and give a short pitch for why you fit the role.
Synthesized from 29 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Capgemini process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Capgemini
Select the 2nd highest salary in the engineering department
| Question | |
|---|---|
| Top Three Salaries | |
| Largest Salary by Department | |
| Top 3 Users | |
| SELECTive Wine Connoisseur | |
| Size of Joins | |
| P-value to a Layman | |
| Google Maps Improvement | |
| Find Duplicate Numbers in a List | |
| Hurdles In Data Projects | |
| Digitizing Student Test Scores | |
| RAG Strict Source Control | |
| Count Transactions | |
| Merchant Dashboard Design | |
| Late Deliveries | |
| Implementing the Fibonacci Sequence in Three Different Methods | |
| Swap Variables | |
| Model Product Performance Degradation | |
| Data Preparation for Imbalanced Data | |
| Addressing Data Quality Issues | |
| Scalable Data Pipelines | |
| Testing Constraints | |
| Alternative Vendor Tradeoff | |
| Popular Products | |
| Client Solution Pushback | |
| Relational Migration | |
| Why Do You Want to Work With Us | |
| Your Strengths and Weaknesses | |
| Data Cleaning Experiences | |
| Rolling Bank Transactions |
Synthesized from candidate reports. Individual experiences may vary.
Several candidates report an initial online test combining aptitude, English and basic technical multiple-choice or coding questions, sometimes with game-style sections. Others describe a recruiter or phone screen instead, so the entry point may differ by hiring route.
Candidates repeatedly report that early conversations center on the resume. Expect to introduce yourself, walk through projects or internships, describe your personal contribution, and explain the challenges you faced. Some interviewers dig into project details.
Candidates report mostly fundamentals: SQL joins and rankings, Python and Pandas basics, and Power BI, Tableau or DAX questions for BI-leaning roles. Some also describe OOP, DBMS, or simple coding tasks. Difficulty is typically described as easy to moderate.
Some candidates describe a manager or client-facing conversation that goes deeper into projects, real-world scenarios and problem-solving. Whether this appears as a separate round probably depends on the team and the hiring route.
Candidates typically describe the final HR round as friendly, covering communication, career goals, availability, and sometimes compensation and joining formalities. Some mention a group exercise or post-offer training, though these were not universal.
