Genpact Interview Questions

Genpact Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(54)
Data Structures & Algorithms
(51)
SQL
(26)
Probability
(18)
Data Modeling
(13)

Genpact Interview Questions

Practice for the Genpact interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

You are working with the sales team of an e-commerce store to analyze their monthly performance.

They give you the sales table that tracks every purchase made on the store. The table contains the columns id (purchase id), product_id, date (purchase date), and price.

Write a SQL query to compute the cumulative sum of sales for each product, sorted by product_id and date.

Note: The cumulative sum for a product on a given date is the sum of the price of all purchases of the product that happened on that date and on all previous dates.

Example:

Input:

sales table

Column Type
id INTEGER
product_id INTEGER
date DATE
price FLOAT

Output:

Column Type
product_id INTEGER
date DATE
cumulative_sum FLOAT
Statistics
Medium
Data Structures & Algorithms
Easy
Loading pricing options

View all Genpact questions

Challenge

Check your skills...
How prepared are you for working at Genpact?

Genpact Salaries by Position

Product Manager*
$260K
Product Manager
Median: $260K
Mean (Average): $260K
Data points: 1
$129K
$145K
Software Engineer
Median: $138K
Mean (Average): $137K
Data points: 4
Data Analyst*
$80K
Data Analyst
Median: $80K
Mean (Average): $80K
Data points: 1
$60K
$88K
Business Analyst
Median: $62K
Mean (Average): $69K
Data points: 57

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Product Manager role pays the most with a $260,000 base salary while the Business Analyst role on average pays the least with a $68,866 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.