Genpact
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via LinkedIn and was interviewed in Mar 2021. There were 5 interview rounds.
posted on 23 Feb 2022
I applied via Recruitment Consulltant and was interviewed in Aug 2021. There were 3 interview rounds.
posted on 29 May 2021
Query to display duplicate records without using group by
Use self-join to compare records
Select records where the values match but the primary key is different
Example: SELECT a.* FROM table a, table b WHERE a.value = b.value AND a.id <> b.id
The 'FOR XML' command is used in SQL Server to generate XML output from a query result.
It allows transforming the result set of a query into XML format.
It can be used to generate XML documents for data exchange or integration purposes.
The 'FOR XML' command supports different modes like RAW, AUTO, EXPLICIT, and PATH.
It can be combined with other SQL Server features like joins, aggregations, and subqueries.
Example: SELEC
stuff() replaces a specified number of characters with another string, while substring() extracts a portion of a string.
stuff() is used to replace a specified number of characters in a string with another string.
substring() is used to extract a portion of a string based on the starting and ending index.
stuff() can be used to mask sensitive data in a string, such as credit card numbers.
substring() can be used to extract...
Transaction property in SSIS ensures all tasks in a package are completed or rolled back as a single unit.
Transaction property is used to ensure data consistency in a package
If a task fails, all previous tasks are rolled back
If all tasks complete successfully, they are committed as a single unit
Transaction property can be set at package or container level
Supported isolation levels are Serializable, Repeatable Read, Rea
The connection string can be passed on runtime using various methods.
One way is to use a configuration file and read the connection string from it.
Another way is to pass the connection string as a parameter to the application.
The connection string can also be stored in a database and retrieved at runtime.
Using environment variables is also a common method to pass connection strings.
Connection strings can be encrypted a...
posted on 10 Oct 2020
Query optimization can be done by analyzing query execution plans, indexing, partitioning, and rewriting queries.
Analyze query execution plans to identify bottlenecks and optimize them
Create indexes on frequently queried columns to improve performance
Partition large tables to distribute data and improve query performance
Rewrite queries to use efficient join and filter conditions
Use query hints to force specific executi...
I applied via Walk-in and was interviewed in Dec 2024. There were 5 interview rounds.
Given task Statics standard deviations Attrition Average of given table values and Given graph economi graph and poverty graph base on that need to gave answers 30 qustion and 60 min time duration
posted on 5 Feb 2025
Gangster Disciples (GD) is a gang, while Graphical Display (GD) refers to a visual representation of data.
Aptitude tests are used to assess a person's ability to perform specific tasks, think critically, and solve problems. They are commonly used in job recruitments, college admissions, and competitive exams.
### **Types of Aptitude Tests**
1. **Numerical Aptitude** – Assesses mathematical skills, including arithmetic, algebra, ratios, percentages, and data interpretation.
2. **Logical Reasoning** – Evaluates pattern recognition, sequences, and logical deductions.
3. **Verbal Ability** – Tests grammar, comprehension, vocabulary, and sentence formation.
4. **Abstract Reasoning** – Measures the ability to identify patterns, trends, and relationships among shapes or figures.
5. **Spatial Reasoning** – Tests the ability to visualize and manipulate objects in space.
6. **Mechanical Reasoning** – Assesses understanding of mechanical and physical concepts, often for technical roles.
7. **Situational Judgment Test (SJT)** – Evaluates decision-making and problem-solving in workplace scenarios.
### **Common Exam Patterns**
- Multiple-choice questions (MCQs)
- Timed sections
- Increasing difficulty level
- Negative marking (in some tests)
### **Preparation Tips**
✔️ **Practice Regularly** – Solve sample questions and previous papers.
✔️ **Time Management** – Work on speed and accuracy.
✔️ **Learn Shortcuts** – Use mental math tricks and reasoning techniques.
✔️ **Improve Reading Skills** – Enhance vocabulary and comprehension for verbal sections.
✔️ **Use Online Mock Tests** – Simulate real test conditions.
Would you like sample questions or specific test details for a job or exam?
Forecasting problem - Predict daily sku level sales
Bias is error due to overly simplistic assumptions, variance is error due to overly complex models.
Bias is the error introduced by approximating a real-world problem, leading to underfitting.
Variance is the error introduced by modeling the noise in the training data, leading to overfitting.
High bias can cause a model to miss relevant relationships between features and target variable.
High variance can cause a model to ...
Parametric models make strong assumptions about the form of the underlying data distribution, while non-parametric models do not.
Parametric models have a fixed number of parameters, while non-parametric models have a flexible number of parameters.
Parametric models are simpler and easier to interpret, while non-parametric models are more flexible and can capture complex patterns in data.
Examples of parametric models inc...
I was interviewed in Aug 2024.
I was interviewed in May 2024.
Maths and stats refer to the study of mathematical concepts and statistical methods for analyzing data.
Maths involves the study of numbers, quantities, shapes, and patterns.
Stats involves collecting, analyzing, interpreting, and presenting data.
Maths is used to solve equations, calculate probabilities, and model real-world phenomena.
Stats is used to make informed decisions, draw conclusions, and test hypotheses.
Both ma...
Confusion matrix what are your job rolls explain me Gradient boosting algorithm?
60 min hackerrank test,with one mysql medium difficulty question and one python medium/little hard level difficulty
based on 1 review
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