Top 24
Prep plan
Updated weekly · Last refresh Nov 12

Genpact Data Engineer Interview Questions

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

24questions
~4htotal time
Track your progressSign up free to work through all 24 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 2 drills · ~76 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
Recently asked
Practice drill

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

Window FunctionsJoinsData ManipulationGenpact
SQL: Top 3 Products Each MonthMedium
Practice
Recently asked
Practice drill

Rank products by monthly sales and return the top three products for each month.

Window FunctionsDate FunctionsJoinsGenpactEmersonGEP
More SQL & Data Manipulation questions with a free account
2
Coding3 questions · ~28 min
Python Decorators and Timing WrapperMedium

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

functionsdecoratorspythonGenpact
Create a Nonmutating Shallow Dictionary MergeEasy
Practice

Merge two dictionaries into a new dictionary, with values from the second dictionary overriding duplicate keys.

pythonGenpact
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 · ~47 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 · ~84 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~9 min
Production Exception Handling in PythonMedium

Tests reliability practices for production data engineering workflows.

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