i
Capgemini
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
I applied via Naukri.com and was interviewed in Aug 2022. There were 2 interview rounds.
Data normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
It involves breaking down a table into smaller tables and defining relationships between them.
Normalization helps to eliminate data inconsistencies and anomalies.
There are different levels of normalization, with each level having specific rules to follow.
For example, first normal form (1NF) requires that e...
Query optimization techniques and types of schemas
Query optimization techniques include indexing, query rewriting, and partitioning
Schemas include user-defined, system-defined, and temporary schemas
User-defined schemas are created by users to organize database objects
System-defined schemas are created by the database management system
Temporary schemas are used for temporary storage of data
Differences between schemas in
I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.
Dense Rank and Rank are SQL functions used to assign a rank to each row in a result set based on a specified criteria.
Dense Rank assigns unique ranks to each row, leaving no gaps in the ranking sequence.
Rank assigns ranks to each row, leaving gaps in the ranking sequence.
Both functions can be used with the OVER clause to partition the result set and order the ranking based on specific columns.
Dense Rank and Rank are co...
What people are saying about Capgemini
I applied via Referral and was interviewed before Aug 2021. There was 1 interview round.
Use SELECT DISTINCT statement to find unique values in a table.
Use SELECT DISTINCT column_name FROM table_name
DISTINCT keyword returns only unique values
Can be used with multiple columns
Can be combined with other SQL statements like WHERE and ORDER BY
To troubleshoot a stored procedure, check for syntax errors, run the procedure with test data, and use debugging tools.
Check for syntax errors in the stored procedure code
Run the procedure with test data to identify any logical errors
Use debugging tools like SQL Server Profiler or Visual Studio Debugger to step through the code and identify issues
Check for any database connectivity issues or permission errors
Review the...
Capgemini interview questions for designations
I appeared for an interview before Sep 2016.
I appeared for an interview in Mar 2017.
Oops concepts in Java
Encapsulation - hiding implementation details
Inheritance - reusing code and creating parent-child relationships
Polymorphism - multiple forms of a method or object
Abstraction - creating abstract classes and interfaces
Example: Encapsulation - using private variables and public methods
Example: Inheritance - creating a subclass that inherits from a superclass
Example: Polymorphism - using method overloa...
Altering columns in databases involves modifying the structure of a table by adding, deleting or modifying columns.
Use ALTER TABLE statement to modify columns
Add new columns using ADD COLUMN
Delete columns using DROP COLUMN
Modify columns using MODIFY COLUMN
Changing column data type may result in data loss
Reversing a number in Java
Convert the number to a string
Use StringBuilder to reverse the string
Convert the reversed string back to a number
To extract words from a line in Java, split the line using whitespace as delimiter.
Use the split() method of String class
Pass the whitespace regex as argument to split() method
Iterate over the resulting array to get individual words
Single Ops tool is a software that helps businesses manage their operations from a single platform.
It streamlines processes and improves efficiency
It can include features like scheduling, inventory management, and invoicing
Examples include ServiceTitan, Jobber, and Housecall Pro
I am a dedicated and hardworking individual with a passion for learning and growth.
I have a background in marketing and have worked in the industry for 5 years.
I am currently pursuing a Master's degree in Business Administration to further my skills and knowledge.
I am a team player and enjoy collaborating with others to achieve common goals.
I appeared for an interview in Jul 2017.
I appeared for an interview in Apr 2017.
Firmware is a type of software that is embedded in hardware devices to control their functionality.
Firmware is a combination of hardware and software.
It is used to control the behavior of hardware devices.
Firmware is typically stored in non-volatile memory, such as ROM or flash memory.
Examples of devices that use firmware include routers, printers, and digital cameras.
I am a passionate software developer with experience in building web applications and solving complex problems.
Experienced in programming languages such as Java, JavaScript, and Python
Familiar with front-end technologies like HTML, CSS, and React
Strong problem-solving skills and ability to work in a team environment
Previous projects include developing a customer management system for a small business
I appeared for an interview before May 2016.
Developed a web application for tracking personal expenses
Used HTML, CSS, and JavaScript for front-end development
Implemented Node.js and MongoDB for back-end functionality
Included features for adding, categorizing, and analyzing expenses
I actively participate in team building activities and collaborate with colleagues on various initiatives outside of work projects.
Organizing team lunches or outings to build camaraderie
Participating in charity events or volunteer work as a team
Collaborating on internal initiatives such as diversity and inclusion programs
Attending industry conferences or workshops together
I will explain the reasons for the delay and present a plan to mitigate it.
Communicate the reasons for the delay clearly and honestly
Present a plan to mitigate the delay and ensure timely delivery
Provide regular updates on the progress of the project
Offer alternative solutions or compromises if necessary
Ensure that the client understands the impact of the delay on the project
Maintain a professional and respectful attit
based on 2 interviews
1 Interview rounds
based on 10 reviews
Rating in categories
Consultant
55.4k
salaries
| ₹5.2 L/yr - ₹18 L/yr |
Associate Consultant
50.7k
salaries
| ₹3 L/yr - ₹11.8 L/yr |
Senior Consultant
46.5k
salaries
| ₹7.5 L/yr - ₹24.8 L/yr |
Senior Analyst
20.8k
salaries
| ₹2.2 L/yr - ₹9 L/yr |
Senior Software Engineer
20.4k
salaries
| ₹3.5 L/yr - ₹12.5 L/yr |
Wipro
Accenture
Cognizant
TCS