i
Capgemini
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Functions return a value, while procedures do not.
Functions must return a value, while procedures do not necessarily return a value.
Functions can be called in SQL statements, while procedures cannot be called in SQL statements directly.
Functions can be used in expressions, while procedures cannot be used in expressions.
Functions are used to compute and return a value, while procedures are used to perform an action.
Exam...
There are two types of triggers in SQL: Row-level triggers and Statement-level triggers.
Row-level triggers are fired for each row affected by the triggering statement.
Statement-level triggers are fired once for each triggering statement, regardless of the number of rows affected.
Examples: BEFORE INSERT trigger (row-level), AFTER UPDATE trigger (statement-level)
Various tools used for business analysis include SWOT analysis, PESTLE analysis, Porter's Five Forces, and BPMN.
SWOT analysis helps identify strengths, weaknesses, opportunities, and threats.
PESTLE analysis examines political, economic, social, technological, legal, and environmental factors.
Porter's Five Forces analyzes industry competition, bargaining power of suppliers and buyers, threat of substitutes, and threat o...
By analyzing client's current processes and identifying areas for improvement, I will propose solutions that add value by increasing efficiency and reducing costs.
Conduct thorough analysis of client's current processes
Identify areas for improvement and inefficiencies
Propose solutions to increase efficiency and reduce costs
Present the value added proposal to the client for approval
What people are saying about Capgemini
Capgemini interview questions for popular designations
I appeared for an interview in Feb 2025, where I was asked the following questions.
SAP BODS is a data integration and transformation tool for managing data workflows and ETL processes.
Data Integration: BODS connects to various data sources like databases, flat files, and applications.
Data Transformation: It allows for complex data transformations using graphical tools and scripting.
Job Scheduling: BODS provides scheduling capabilities to automate data workflows.
Data Quality: It includes features for ...
Get interview-ready with Top Capgemini Interview Questions
I applied via Company Website and was interviewed in Aug 2024. There was 1 interview round.
I appeared for an interview in Mar 2024.
Metrics are tracked using a combination of automated tools, manual data collection, and regular reporting.
Utilize automated monitoring tools to track key performance indicators in real-time
Collect data manually through surveys, interviews, and observations to gather qualitative feedback
Generate regular reports to analyze trends, identify areas for improvement, and make data-driven decisions
Implement a balanced scorecar...
I was quite difficult
I appeared for an interview before Mar 2024.
Data pages are essential components in data management, enabling efficient storage and retrieval of information.
Data pages store structured data in a database, allowing for quick access and manipulation.
They help in organizing data into manageable units, improving performance and scalability.
For example, in a relational database, a data page might contain multiple rows of a table.
Data pages can be cached in memory to s...
Yes, you can change a database table name in Pega and update references accordingly.
Use the Pega Database Table Management feature to rename the table.
Update the Data Model in Pega to reflect the new table name.
Modify any Data Pages, Reports, or Activities that reference the old table name.
Example: If the old table name was 'CustomerData', change it to 'ClientData' and update all references.
Test the application thoroug...
Online aptitude test
I don't remember the topic, but it was easy
Some of the top questions asked at the Capgemini interview for experienced candidates -
The duration of Capgemini interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 1k interviews
Interview experience
based on 43.6k reviews
Rating in categories
Consultant
56k
salaries
| ₹5.2 L/yr - ₹18 L/yr |
Associate Consultant
50.7k
salaries
| ₹2.9 L/yr - ₹12 L/yr |
Senior Consultant
47.3k
salaries
| ₹7.5 L/yr - ₹25 L/yr |
Senior Analyst
21.1k
salaries
| ₹2.2 L/yr - ₹9 L/yr |
Senior Software Engineer
20.6k
salaries
| ₹3.5 L/yr - ₹12.9 L/yr |
Wipro
Accenture
Cognizant
TCS