Dataford
Top 22
Prep plan
Updated weekly · Last refresh Aug 30

Genpact Data Analyst Interview Questions

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

22questions
~3htotal time
Track your progressSign up free to work through all 22 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 2 drills · ~63 min
Top 3 Sales Per MonthEasy
Practice

Rank Genpact sales representatives by monthly revenue and return the top three using aggregation and ROW_NUMBER().

sql queriesGenpact
Derived Query vs CTEMedium

Tests understanding of SQL query constructs and tradeoffs between derived tables and CTEs.

SubqueriesperformanceCTEsGenpact
Inner vs Left Join with NullsMedium

Tests join semantics and correct handling of nulls to avoid data loss or miscounts.

null handlingJoinssqlGenpact
Optimize Slow Multi-Join QueryHard

Tests query tuning skills for performance issues involving joins, aggregations, and large-scale data.

Performance TuningJoinsAggregationsGenpact
SQL Joins and GroupingHard

Evaluates SQL proficiency and the ability to transform relational data into insights.

sql queriesGenpact
SQL Join and Revenue AggregationEasy
Practice
Practice drill

Calculate total revenue per customer using GROUP BY, SUM, and descending output ordering.

JoinsGroup ByAggregationsGenpact
Second Highest Trader SalaryEasy
Practice
Practice drill

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

SubqueriesRankingSortingeClinicalWorksInformaticaSpectraforce Technologies

Sign up to see every question

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

Get my prep plan
2
Behavioral & Leadership17 questions · ~145 min
Resume Project With Business ImpactEasy

Tests ownership and data-driven communication through a concrete example of analysis that led to measurable business impact.

impactresumesuccess storyGenpact
Clarifying Vague Reporting RequirementsEasy

Tests stakeholder management and communication in ambiguous reporting requests, with emphasis on turning vague business asks into clear deliverables.

Stakeholder ManagementCommunicationrequirementsGenpact
Unexpected Data Trend PivotMedium

Tests data-driven leadership: spotting a surprising signal, validating it, and influencing stakeholders to pivot strategy.

Decision Makingimpactbusiness strategyGenpact
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 22 questions plus 2 hands-on drills to finish this plan.