Top 25
Prep plan
Updated weekly · Last refresh Sep 23

Genpact Data Engineer Interview Questions

The questions to prepare for a Genpact Data Engineer interview. Questions from real interview reports rank first. Updated daily.

25questions
~4htotal time
Track your progressSign up free to work through all 25 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 2 drills · ~80 min
Second Highest Trader SalaryEasy
Practice

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

SubqueriesRankingSortingGenpact
Ranking Trial Results with Window FunctionsEasy

Explain how RANK(), DENSE_RANK(), and ROW_NUMBER() differ when ordering tied clinical trial results.

Window FunctionsRankingData WranglingGenpact
OLTP vs OLAP Database DesignMedium

Explain OLTP vs OLAP designs, including schema shape, workload patterns, and when each is appropriate in a data platform.

financial dataperformanceData ModelingGenpact
Window Functions for Top UnitsMedium
Practice
Practice drill

Rank business units within each Genpact client by total billable revenue and return the top two performers.

Window FunctionsJoinsData ManipulationGenpact
7-Day Rolling Active UsersMedium
Practice
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
More SQL & Data Manipulation questions with a free account
2
Coding4 questions · ~40 min
First Non-Repeating CharacterEasy
Practice

Find the first non-repeating character in a string using frequency counting and a second pass in O(n) time.

Hash TablesStringsSearchingGenpact
Python Decorators and Timing WrapperMedium

Explain how Python decorators wrap functions and implement a custom decorator that logs execution time.

functionsdecoratorspythonGenpact
More Coding questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Pipelines5 questions · ~50 min
Handle PySpark Data SkewMedium

Approach for detecting and mitigating skew in PySpark pipelines using partitioning, join strategies, and runtime monitoring.

Data Qualitypysparkdata skewnessGenpact
Spark Caching vs PersistenceMedium

Tests performance optimization choices in Spark for large-scale data processing.

performancecachingsparkGenpact
More Pipelines questions with a free account
4
Behavioral & Leadership9 questions · ~90 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~10 min
Production Exception Handling in PythonMedium

Tests reliability practices for production data engineering workflows.

production failureprocesspython serviceGenpact
The finish line: interview-readyComplete all 25 questions plus 2 hands-on drills to finish this plan.