Add office photos
Employer? Claim Account for FREE
Genpact
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Genpact Consultant Interview Questions, Process, and Tips
Updated
23 Nov 2024
Top Genpact Consultant Interview Questions and Answers
- Q1. What happens if Treat source row property as "Update" at session level but at target object "Delete" is checked?
- Q2. What schema type was used in your previous project? And explain why it was used?
- Q3. Which SCD type you worked on before and explain on that?
58 Genpact Consultant Interview Experiences
153 questions found
Sort by:
Popular
Anonymous
I applied via Approached by Company and was interviewed before May 2021.
4 Interview Rounds
1
Coding Test Round
Online questions were based on scenarios to write SQL queries. Also got few questions on Python as well for which I had only limited knowledge.
2
Technical Round (8 Questions)
- Q1. I'm listing some of the questions here which the interviewers (2 panel resources) asked me regarding Informatica ETL, Oracle DB and I might have missed some of ...read more Add Answer
- Q2. What happens if Treat source row property as "Update" at session level but at target object "Delete" is checked? View Answers (1)
- Q3. What are the different types of dimension tables? View Answers (1)
- Q4. What schema type was used in your previous project? And explain why it was used? View Answers (1)
- Q5. Difference between Joiner and Lookup transformations? View Answers (1)
- Q6. Scenario: I have records in a flat file ending with ; character at the end of each them. How to load these records into DB based on this character? What propert...read more Add Answer
- Q7. How version control happened in your previous project? View Answers (1)
- Q8. Which SCD type you worked on before and explain on that? View Answers (1)
3
One-on-one Round (1 Question)
- Q1. This round was taken by the project manager on a phone call. He asked me few basic fundamental questions related to my skills and the things which I worked on i...read more Add Answer
4
HR Round (1 Question)
- Q1. Just F2F discussion with HR finalising on the compensation structure, learning opportunities and the organisational benefits as an employee. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - If you're an experienced person, be confident about the things which you handled in previous project and be precise on to the point. Don't elaborate too much as the interviewers might build up questions based on that. Be strong in your technical areas of expertise. Expect scenario based questions related to your skills.
Skills evaluated in this interview
Interview experience
Bad
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
One-on-one Round (1 Question)
- Q1. Behavioral question Add Answer
2
Technical Round (2 Questions)
- Q1. Tell me about yourself View Answers (1)
- Q2. Why interested in this role View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Ghosters
Get interview-ready with top interview questions
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
One-on-one Round (1 Question)
- Q1. Explain your project structure Add Answer
2
Behavioral Round (1 Question)
- Q1. How to motivate team? Add Answer
What people are saying about Genpact
View All
an associate
1w
Should I accept the offer or any other advice ?
I was working as an Associate in a medical billing company with a CTC of 3.75 LPA. I’ve received an offer from Genpact in the same field (medical billing/insurance claims) with a salary of 4.5 LPA, but the shift is from 5:30 p.m. to 2:30 a.m., which is not ideal for me but I can still manage.
I’m 25 and have 2 years of work experience and have been without a job for 3 months for the CAT exam (unfortunately, no hopes there).
I’m really confused about what direction to take with my career. Should I accept the Genpact offer, or is it better to keep looking for other opportunities? Any advice or guidance would be greatly appreciated!
Got a question about Genpact?
Ask anonymously on communities.
Vaishnavi Naidu
Interview experience
Poor
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. OS concepts - scheduling, multithreading Add Answer
- Q2. Ds- joins, basic queries Add Answer
Genpact interview questions for designations
Interview experience
Excellent
Difficulty level
Moderate
Duration
More than 8 weeks
Result
Selected
I applied via Approached by Company and was interviewed in Mar 2024.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Related to process and explain Add Answer
- Q2. Excel skills and communication Add Answer
2
HR Round (2 Questions)
- Q1. Salary discussion Add Answer
- Q2. About benifits and cab facility Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Do not join in Genpact
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
One-on-one Round (5 Questions)
- Q1. Fibonacci series Add Answer
- Q2. Difference between has many through and habtm View Answers (1)
- Q3. Difference between super and super() View Answers (1)
- Q4. Associations in ruby on rails View Answers (1)
- Q5. What is callback in rails View Answers (1)
Skills evaluated in this interview
Consultant Jobs at Genpact
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Coding Test Round
DBMS related question asked with mcqs also
2
One-on-one Round (2 Questions)
- Q1. Do you know bout SLDC Add Answer
- Q2. Questions regarding the projects that I had done Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Just be confident and answer with cinfidence
Geetanjali Bisht
Interview experience
Good
Difficulty level
-
Duration
-
Result
Not Selected
1 Interview Round
1
One-on-one Round (1 Question)
- Q1. Which loading methodology I am using and how you are implementing via syniti. View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - We should well versed with Syniti tool means small action role also can ask in interview.
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Recruitment Consulltant and was interviewed in Mar 2024.
3 Interview Rounds
1
Coding Test Round
Few questions of SQL and Power BI
2
Coding Test Round
Alteryx and some behavioural Questions
3
HR Round (2 Questions)
- Q1. Why do want to join Genpact? View Answers (1)
- Q2. How much salary are you seeking? View Answers (1)
Interview Preparation Tips
Topics to prepare for Genpact Consultant interview:
- SQL
- Tableau
- Alteryx
- Python
- Power Bi
Navneet
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Aptitude Test Round
Easy and simple . Mostly from basic maths
2
Group Discussion Round
Topic is given to you and u have to discuss
3
One-on-one Round (1 Question)
- Q1. Why you want to join Genpact? Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Company Website and was interviewed before Aug 2023.
4 Interview Rounds
1
Aptitude Test Round
Logical and situation based
2
Technical Round (1 Question)
- Q1. Previous roles responsibility View Answers (1)
3
Technical Round (1 Question)
- Q1. Questions on type of industry I worked in Add Answer
4
Technical Round (2 Questions)
- Q1. Location confirmation Add Answer
- Q2. Commuication check Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be calm and focus on company's core structure and prepare the skills required for the job you applied in the company
Genpact Interview FAQs
How many rounds are there in Genpact Consultant interview?
Genpact interview process usually has 2-3 rounds. The most common rounds in the Genpact interview process are Technical, One-on-one Round and HR.
How to prepare for Genpact Consultant interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Genpact. The most common topics and skills that interviewers at Genpact expect are SQL, Javascript, Troubleshooting, Production Support and Agile Coaching.
What are the top questions asked in Genpact Consultant interview?
Some of the top questions asked at the Genpact Consultant interview -
How long is the Genpact Consultant interview process?
The duration of Genpact Consultant interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Genpact Interviews By Designations
- Genpact Process Associate Interview Questions
- Genpact Process Developer Interview Questions
- Genpact Management Trainee Interview Questions
- Genpact Assistant Manager Interview Questions
- Genpact Business Analyst Interview Questions
- Genpact Consultant Interview Questions
- Genpact Senior Associate Interview Questions
- Genpact Accountant Interview Questions
- Show more
Interview Questions for Popular Designations
- Associate Consultant Interview Questions
- Senior Consultant Interview Questions
- Senior Associate Consultant Interview Questions
- Lead Consultant Interview Questions
- Technical Consultant Interview Questions
- SAP Abap Consultant Interview Questions
- AST Consultant Interview Questions
- SAP Fico Consultant Interview Questions
- Show more
Interview Process at Genpact Consultant
based on 23 interviews in last 1 year
2 Interview rounds
- Technical Round 1
- Technical Round 2
View more
People are getting interviews through
based on 45 Genpact interviews
Job Portal
Campus Placement
Referral
Recruitment Consultant
Company Website
40%
16%
13%
7%
4%
20% candidates got the interview through other sources.
High
Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.
Consultant Interview Questions from Similar Companies
Fast track your campus placements
12%
less
than the average Consultant Salary in India
View more details
Genpact Consultant Reviews and Ratings
based on 459 reviews
Rating in categories
|
Process Developer
36.3k
salaries
|  ₹1 L/yr - ₹6.8 L/yr |
|
Process Associate
28.2k
salaries
| ₹0.9 L/yr - ₹6.5 L/yr |
|
Assistant Manager
20k
salaries
| ₹4.8 L/yr - ₹14 L/yr |
|
Management Trainee
19.2k
salaries
| ₹1.6 L/yr - ₹8.5 L/yr |
|
Manager
7.5k
salaries
| ₹7 L/yr - ₹24 L/yr |
Explore more salaries
Compare Genpact with
Accenture
Compare
Capgemini
Compare
TCS
Compare
Cognizant
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Genpact Interview Questions >
- Genpact Consultant Interview Questions
Share an Interview