Genpact
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Approached by Company and was interviewed before May 2021. There were 4 interview rounds.
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.
The source row will be treated as an update, but the target object will be deleted.
The session level property 'Treat source row as Update' will be applied to the source row.
The target object will be deleted regardless of the update status of the source row.
This can result in data loss if the source row contains important information.
Dimension tables are used in data warehousing to provide descriptive information about the data in fact tables.
Slowly changing dimensions
Junk dimensions
Degenerate dimensions
Role-playing dimensions
Bridge dimensions
We used a relational schema in our previous project as it was suitable for the data structure and allowed for efficient querying.
Relational schema was used as it allowed for efficient querying of data
The data structure was suitable for a relational schema
We were able to easily join tables to retrieve necessary data
Examples include using SQL to query a database with multiple tables
Normalization was used to reduce data r
Joiner combines data from multiple sources based on a common key, while Lookup retrieves data from a reference table based on a matching key.
Joiner is used to combine data from two or more sources based on a common key column.
Lookup is used to retrieve data from a reference table based on a matching key column.
Joiner can perform inner, outer, left, and right joins, while Lookup can only perform an inner join.
Joiner can...
We used Git for version control in our previous project.
We created a Git repository for the project.
All team members were added as collaborators to the repository.
We followed the Git flow branching model.
We used pull requests for code review and merging.
We used tags to mark important releases.
We regularly pushed our changes to the remote repository.
We used Git commands like commit, push, pull, merge, and rebase.
We used...
I have worked on SCD Type 2 before.
SCD Type 2 is used to track historical changes in data.
It creates a new record for each change and maintains a history of changes.
It includes start and end dates for each record.
Example: Tracking changes in employee salary over time.
I am a dedicated and experienced consultant with a strong background in problem-solving and client management.
Over 5 years of experience in consulting roles
Skilled in analyzing data and providing strategic recommendations
Proven track record of successfully managing client relationships
Strong communication and presentation skills
Certified in relevant consulting methodologies
Passionate about problem-solving and helping clients achieve their goals.
Enjoy analyzing complex issues and providing strategic solutions
Excited about collaborating with diverse teams and clients
Previous experience in consulting roles, such as improving operational efficiency for a manufacturing company
What people are saying about Genpact
Genpact interview questions for designations
I applied via Approached by Company and was interviewed in Mar 2024. There were 2 interview rounds.
Get interview-ready with Top Genpact Interview Questions
has_many through is used for a many-to-many relationship with an intermediate model, while has_and_belongs_to_many is a simpler many-to-many relationship without an intermediate model.
has_many through allows additional attributes to be stored in the join table, providing more flexibility and functionality
has_and_belongs_to_many does not have a separate model for the join table, making it simpler but less flexible
has_ma...
super is a keyword used to access methods and properties of a superclass, while super() is used to call the constructor of a superclass.
super is used to access methods and properties of a superclass in a subclass.
super() is used to call the constructor of a superclass from a subclass constructor.
super can be used to access overridden methods or properties in the superclass.
super() must be the first statement in a subcl
Associations in Ruby on Rails allow you to connect models and establish relationships between them.
Associations are defined using methods like has_many, belongs_to, has_one, and has_and_belongs_to_many.
They help in simplifying database queries and managing data relationships.
For example, a User model can have many posts, so you would define a has_many association in the User model.
Callbacks in Rails are methods that are called at certain moments of an object's life cycle.
Callbacks allow you to trigger logic before or after an object is saved, updated, or destroyed.
Examples of callbacks include before_save, after_create, and before_destroy.
Callbacks can be used to perform validations, set default values, or trigger other actions based on certain events.
DBMS related question asked with mcqs also
I am using the Extract, Transform, Load (ETL) methodology and implementing it via Syniti.
I am extracting data from various sources such as databases, files, and applications.
I am transforming the data to meet the requirements of the target system or database.
I am loading the transformed data into the target system using Syniti's data integration tools.
For example, I may be using Syniti Data Replication to replicate dat
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There were 3 interview rounds.
Few questions of SQL and Power BI
Alteryx and some behavioural Questions
I want to join Genpact because of its reputation for providing excellent consulting services and opportunities for professional growth.
Genpact is known for its expertise in consulting services
I am impressed by the company's track record of success
I believe Genpact offers great opportunities for professional development
I am seeking a competitive salary based on my experience, skills, and the responsibilities of the role.
Research the average salary range for consultants in your industry and location
Consider your years of experience, education, and certifications when determining your salary expectations
Be prepared to negotiate and discuss benefits and bonuses in addition to base salary
Easy and simple . Mostly from basic maths
Topic is given to you and u have to discuss
Some of the top questions asked at the Genpact Consultant interview -
The duration of Genpact Consultant interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 46 interviews
4 Interview rounds
based on 497 reviews
Rating in categories
Process Developer
36.3k
salaries
| ₹1 L/yr - ₹6.8 L/yr |
Process Associate
28.1k
salaries
| ₹0.9 L/yr - ₹6.5 L/yr |
Assistant Manager
19.9k
salaries
| ₹5 L/yr - ₹14 L/yr |
Management Trainee
19.4k
salaries
| ₹1.6 L/yr - ₹8.5 L/yr |
Manager
7.4k
salaries
| ₹5.7 L/yr - ₹24 L/yr |
Accenture
Capgemini
TCS
Cognizant