Capgemini Analyst Interview Questions and Answers

It comprised of 3 sections
1st section
MCQ round:DSA(bitwise operators), DBMS, Networking.
2nd Section
Essay writing (200 words)
3rd Section
Gaming based cognitive ability test.

Then qualified students had to give SVAR test.

Q1. Can you describe your major project
Ans. 
Developed a data analysis tool to track customer behavior and improve marketing strategies.
• Utilized Python and SQL to extract and analyze customer data

• Implemented machine learning algorithms to predict customer preferences

• Collaborated with marketing team to implement targeted campaigns based on analysis

• Generated reports and visualizations to present findings to stakeholders
Answered by AI
Add your answer
Q2. Explain the concept of inheritance along with other basic Object-Oriented Programming (OOP) concepts?
Ans. 
Inheritance is a concept in OOP where a class can inherit attributes and methods from another class.
• Inheritance allows for code reusability and promotes the concept of 'is-a' relationship.

• A subclass can inherit from a superclass, gaining access to its attributes and methods.

• Example: Class 'Animal' can be a superclass, and classes like 'Dog' and 'Cat' can inherit from it.
Answered by AI
Add your answer

Very basic aptitude test

Divided into two categories. cleared the 4.2LPA slab but not selected for 7.5LPA. If selected need to give another test

Q1. Questions completely on resume
Add your answer
Q2. Explaining basic python data-types(list,tuples,etc)
Ans. 
Python has several built-in data types, including lists, tuples, sets, and dictionaries, each serving different purposes.
• List: Mutable, ordered collection. Example: my_list = [1, 2, 3]

• Tuple: Immutable, ordered collection. Example: my_tuple = (1, 2, 3)

• Set: Unordered collection of unique elements. Example: my_set = {1, 2, 3}

• Dictionary: Key-value pairs, unordered. Example: my_dict = {'a': 1, 'b': 2}
Answered by AI
Add your answer
Q3. HR questions like why capegemini, what will you do if u get other offers, are u comfortable with night shift and relocation, etc
Add your answer

Q1. What are the properties of ACID in Database Management Systems (DBMS)?
Ans. 
ACID properties ensure data integrity in DBMS by defining rules for transactions.
• Atomicity: Transactions are either fully completed or fully aborted.

• Consistency: Data must be in a valid state before and after transactions.

• Isolation: Transactions should be independent of each other.

• Durability: Once a transaction is committed, changes are permanent.

• Example: If a bank transfer fails midway, the entire transaction is rolle...read more
Answered by AI
Add your answer
Q2. What are constraints in SQL ?
Ans. 
Constraints in SQL are rules that are enforced on data columns to ensure data integrity and accuracy.
• Constraints ensure that data in a column meets certain criteria, such as uniqueness, not null, or foreign key relationships.

• Examples of constraints include PRIMARY KEY, UNIQUE, NOT NULL, CHECK, and FOREIGN KEY.

• Constraints help maintain data integrity by preventing invalid data from being inserted into tables.
Answered by AI
Add your answer

Duration 3 hours in total. 3 rounds in 3 hours each round is elimination

Didnt give the coding test as i didnt get the email

Q1. Why do you want to join Capgemini
Ans. 
I want to join Capgemini for its innovative culture, diverse opportunities, and commitment to professional growth and sustainability.
• Capgemini's focus on innovation aligns with my passion for technology and digital transformation.

• The company's diverse portfolio allows me to work on various projects, enhancing my skills and experience.

• Capgemini's commitment to sustainability resonates with my values, as I believe in con...read more
Answered by AI
Add your answer
Q2. Explain your resume and the projects mentioned in your resume
Add your answer