i
Capgemini
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
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 20 Apr 2021
I applied via LinkedIn and was interviewed in Mar 2021. There were 5 interview rounds.
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?
I was interviewed in Oct 2024.
Transfer learning involves using pre-trained models on a different task, while fine-tuning involves further training a pre-trained model on a specific task.
Transfer learning uses knowledge gained from one task to improve learning on a different task.
Fine-tuning involves adjusting the parameters of a pre-trained model to better fit a specific task.
Transfer learning is faster and requires less data compared to training a...
I applied via Approached by Company and was interviewed in Aug 2024. There were 2 interview rounds.
*****, arjumpudi satyanarayana
Python is a high-level programming language known for its simplicity and readability.
Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.
It emphasizes code readability and uses indentation for block delimiters.
Python has a large standard library and a vibrant community of developers.
Example: print('Hello, World!')
Example: import pandas as pd
Code problems refer to issues or errors in the code that need to be identified and fixed.
Code problems can include syntax errors, logical errors, or performance issues.
Examples of code problems include missing semicolons, incorrect variable assignments, or inefficient algorithms.
Identifying and resolving code problems is a key skill for data scientists to ensure accurate and efficient data analysis.
Python code is a programming language used for data analysis, machine learning, and scientific computing.
Python code is written in a text editor or an integrated development environment (IDE)
Python code is executed using a Python interpreter
Python code can be used for data manipulation, visualization, and modeling
The project is a machine learning model to predict customer churn for a telecommunications company.
Developing predictive models using machine learning algorithms
Analyzing customer data to identify patterns and trends
Evaluating model performance and making recommendations for reducing customer churn
The question seems to be incomplete or misspelled.
It is possible that the interviewer made a mistake while asking the question.
Ask for clarification or context to provide a relevant answer.
posted on 27 Dec 2024
I applied via Company Website and was interviewed in Nov 2024. There were 4 interview rounds.
Quantitavtive logical verbal puzzles reasoning arithmetic
DSA array string loops function and algorithms
Communication leadership teamwork
Fundamental of ai ml and also about nural network
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...
Consultant
55.2k
salaries
| ₹5.1 L/yr - ₹17.6 L/yr |
Associate Consultant
50.9k
salaries
| ₹3 L/yr - ₹11.8 L/yr |
Senior Consultant
46.1k
salaries
| ₹7.5 L/yr - ₹25 L/yr |
Senior Analyst
20.8k
salaries
| ₹2 L/yr - ₹9 L/yr |
Senior Software Engineer
20.1k
salaries
| ₹3.5 L/yr - ₹12.4 L/yr |
Wipro
Accenture
Cognizant
TCS