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 Scientist
•
Coding
•
medium
Write a SQL query using window functions to calculate the 7-day rolling average of sales for each product category.
#SQL
#Window Functions
#Data Aggregation
Data Scientist
•
Coding
•
medium
Write a SQL query to find the second highest salary by department without using the LIMIT keyword.
#SQL
#Subqueries
#Window Functions
Data Scientist
•
Coding
•
hard
Write a SQL query to find users who have logged into an application on 3 consecutive days.
#SQL
#Advanced Window Functions
#Date Manipulation
Data Scientist
•
Technical
•
easy
Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() with a practical example.
#SQL
#Window Functions
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.