Capgemini
Global leader in partnering with companies to transform and manage their business by harnessing the power of technology.
4 Rounds
~21 Days
Medium
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Engineer
•
Coding
•
medium
Write a SQL query to find the nth highest salary for each department from an Employee table.
#Window Functions
#DENSE_RANK
#CTEs
Data Engineer
•
Coding
•
hard
Write a SQL query to identify users who have logged in for 3 or more consecutive days.
#Advanced SQL
#Self Joins
#LEAD/LAG
#Date Functions
Data Engineer
•
Coding
•
medium
Write a SQL MERGE statement to implement Slowly Changing Dimension (SCD) Type 2 logic for a customer dimension table.
#Data Warehousing
#SCD Type 2
#MERGE Statement
Data Engineer
•
Technical
•
easy
Explain the exact differences between RANK(), DENSE_RANK(), and ROW_NUMBER() with a practical example.
#Window Functions
#Data Ranking
Data Engineer
•
Technical
•
medium
You have a slow-running SQL query with multiple joins on large tables. Walk me through your step-by-step approach to optimize it.
#Performance Tuning
#Execution Plans
#Indexing
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.