Capgemini

Capgemini

Global leader in partnering with companies to transform and manage their business by harnessing the power of technology.

4 Rounds ~21 Days Medium
Start Mock Interview

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 • 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
Practice
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
Practice
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
Practice
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
Practice
Data Engineer • Technical • easy

Explain the exact differences between RANK(), DENSE_RANK(), and ROW_NUMBER() with a practical example.

#Window Functions #Data Ranking
Practice
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
Practice
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
Practice
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
Practice
Data Scientist • Technical • easy

Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() with a practical example.

#SQL #Window Functions
Practice
Full Stack Engineer • Technical • medium

Write a SQL query to find the second highest salary of an employee from an Employee table.

#SQL #Subqueries
Practice
Machine Learning Engineer • Coding • medium

Write a SQL query to find the second highest salary within each department.

#SQL #Window Functions #Ranking
Practice
Machine Learning Engineer • Coding • medium

Write a SQL query to calculate the 7-day rolling average of daily sales for a retail client.

#SQL #Window Functions #Time Series
Practice
Product Manager • Coding • easy

Write a SQL query to find the top 5 clients by total revenue generated in the last quarter.

#SQL #Aggregation #Sorting #Date Functions
Practice
Product Manager • Coding • hard

Write a SQL query to calculate the month-over-month retention rate of users on a SaaS platform.

#SQL #Self Joins #Cohort Analysis #Window Functions
Practice
Product Manager • Coding • medium

Write a SQL query to identify users who have logged in more than 3 times in the past 7 days but haven't made a purchase.

#SQL #Filtering #Subqueries #Joins
Practice
Software Engineer • Technical • medium

Write a SQL query to find the nth highest salary of an employee from an Employee table.

#SQL #Window Functions #Subqueries
Practice

Difficulty Radar

Based on recent AI-sourced data.

Meet Your Interviewers

The "Standard" Interviewer

Senior Engineer

Focuses on core competencies, system constraints, and clear communication.

Simulate

Unwritten Rules

Think Out Loud

Always explain your thought process before writing code or drawing architecture.

Practice Now