Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Capgemini Team. If you also belong to the team, you can get access from here

Capgemini Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Capgemini Data Analyst Intern Interview Questions and Answers

Updated 2 Apr 2024

8 Interview questions

A Data Analyst Intern was asked
Q. What is a HashMap in Java?
Ans. 

Hash map is a data structure that stores key-value pairs and allows fast retrieval of values based on keys.

  • Hash map uses hashing to store and retrieve values based on keys

  • It allows null values and null keys

  • It is not synchronized and not thread-safe

  • Example: HashMap<String, Integer> map = new HashMap<>();

  • map.put("apple", 1); int value = map.get("apple");

A Data Analyst Intern was asked
Q. What is the difference between a primary key and a candidate key?
Ans. 

Primary key uniquely identifies a record while candidate key can also uniquely identify a record but may not be chosen as primary key.

  • Primary key is a column or set of columns that uniquely identifies each record in a table

  • Candidate key is a column or set of columns that can also uniquely identify each record in a table

  • A table can have multiple candidate keys but only one primary key

  • Primary key cannot have null va...

Data Analyst Intern Interview Questions Asked at Other Companies

Q1. Water Jug Problem Statement You have two water jugs with capaciti ... read more
Q2. Insertion Sort in a Linked List Given a singly linked list with ' ... read more
Q3. What is the difference between loc and iloc in data science, and ... read more
Q4. Can you explain the different types of keys in a database and the ... read more
asked in Uber
Q5. You have a 5L jar and a 3L jar. How can you measure out exactly 4 ... read more
A Data Analyst Intern was asked
Q. How does memory management work in Java?
Ans. 

Memory management in Java involves automatic garbage collection and manual memory allocation.

  • Java uses automatic garbage collection to free up memory

  • Developers can manually allocate memory using the 'new' keyword

  • Java also has a 'finalize' method to clean up resources before garbage collection

  • Memory leaks can occur if objects are not properly released

A Data Analyst Intern was asked
Q. What is the difference between a super key and a foreign key?
Ans. 

Super key is a set of attributes that uniquely identifies a record, while foreign key is a reference to a primary key in another table.

  • Super key is a combination of one or more attributes that uniquely identifies a record in a table.

  • Foreign key is a field in a table that refers to the primary key of another table.

  • Super key can have additional attributes that are not necessary for uniqueness.

  • Foreign key establishes...

What people are saying about Capgemini

View All
thrivingsnapdragon
1w
works at
Accenture
Need feedback regarding One Finance BU at Capgemini
I am planning to join the One Finance Transformation team under Group IT at Capgemini. Can you please provide some insights if it is a good option to join in terms of learning, career progression and monetary benefits? Thanks.
Got a question about Capgemini?
Ask anonymously on communities.
A Data Analyst Intern was asked
Q. List all languages available in SQL.
Ans. 

List of SQL languages

  • MySQL

  • Oracle

  • PostgreSQL

  • Microsoft SQL Server

  • SQLite

A Data Analyst Intern was asked
Q. List all languages in Sql and explain
Ans. 

List of SQL languages and their brief explanation

  • SQL (Structured Query Language) is a standard language for managing relational databases

  • T-SQL (Transact-SQL) is a proprietary extension of SQL used by Microsoft SQL Server

  • PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's proprietary extension of SQL

  • MySQL is an open-source relational database management system that uses SQL

  • PostgreSQL is a...

A Data Analyst Intern was asked
Q. Memory management and hash map in java
Ans. 

Memory management and hash map are important concepts in Java programming.

  • Memory management is the process of allocating and deallocating memory in a program.

  • Java uses automatic memory management through garbage collection.

  • Hash map is a data structure that stores key-value pairs and uses hashing to retrieve values efficiently.

  • Java's HashMap class implements the Map interface and provides constant-time performance ...

Are these interview questions helpful?
🔥 Asked by recruiter 3 times
A Data Analyst Intern was asked
Q. Oops concepts in java
Ans. 

Oops concepts are fundamental to Java programming and include inheritance, polymorphism, encapsulation, and abstraction.

  • Inheritance allows a class to inherit properties and methods from a parent class.

  • Polymorphism allows objects to take on multiple forms and behave differently based on their context.

  • Encapsulation hides the implementation details of a class and only exposes necessary information.

  • Abstraction focuses...

Capgemini Data Analyst Intern Interview Experiences

3 interviews found

Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
-
Round 1 - Coding Test 

They will ask you to code some basic coding question.

Round 2 - Technical 

(1 Question)

  • Q1. They will ask you some basic questions in sql, java

I applied via Campus Placement and was interviewed in Mar 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Pseudo code, verbal, gaming 

(1 Question)

  • Q1. Questions will be related to ds, pseudo code and logical reasoning
Round 3 - Technical 

(6 Questions)

  • Q1. Tell me about yourself
  • Q2. Exceptional handling in java
  • Ans. 

    Exceptional handling in Java is a mechanism to handle runtime errors and prevent program crashes.

    • Java provides try-catch blocks to handle exceptions

    • Multiple catch blocks can be used to handle different types of exceptions

    • Finally block is used to execute code regardless of whether an exception is thrown or not

  • Answered by AI
  • Q3. Primary key, unique key, candidate key in sql
  • Q4. Oops concepts in java
  • Ans. 

    Oops concepts are fundamental to Java programming and include inheritance, polymorphism, encapsulation, and abstraction.

    • Inheritance allows a class to inherit properties and methods from a parent class.

    • Polymorphism allows objects to take on multiple forms and behave differently based on their context.

    • Encapsulation hides the implementation details of a class and only exposes necessary information.

    • Abstraction focuses on t...

  • Answered by AI
  • Q5. Memory management and hash map in java
  • Ans. 

    Memory management and hash map are important concepts in Java programming.

    • Memory management is the process of allocating and deallocating memory in a program.

    • Java uses automatic memory management through garbage collection.

    • Hash map is a data structure that stores key-value pairs and uses hashing to retrieve values efficiently.

    • Java's HashMap class implements the Map interface and provides constant-time performance for b...

  • Answered by AI
  • Q6. List all languages in sql
  • Ans. 

    List of SQL languages

    • MySQL

    • Oracle

    • PostgreSQL

    • Microsoft SQL Server

    • SQLite

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Capgemini Data Analyst Intern interview:
  • Pseudo code
  • Data Structures
  • Any programming language
  • MySQL
Interview preparation tips for other job seekers - Technical assessment consists of four rounds data structure and pseudo code, logical ability, gaming and finally behavioral questions each round is an elimination round
Once clearing it we get mail regarding tr round
Interviewer asked questions related to skills I mentioned in resume
Don't lie in resume
They can easily find out
After 20 days i got message that i got selected
Go through capgemini technical assessment video in YouTube
To get better understanding

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Oct 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Psudo code round, verbal, gaming 

(1 Question)

  • Q1. Question from pseudo code, ds and grammar are asked
Round 3 - Technical 

(8 Questions)

  • Q1. Tell me about yourself
  • Q2. Exception handling in java
  • Ans. 

    Exception handling in Java allows for the handling of errors and exceptions that may occur during program execution.

    • Java provides try-catch blocks to handle exceptions.

    • The try block contains the code that may throw an exception.

    • The catch block catches and handles the thrown exception.

    • Multiple catch blocks can be used to handle different types of exceptions.

    • The finally block is optional and is executed regardless of whe...

  • Answered by AI
  • Q3. Memory management in java
  • Ans. 

    Memory management in Java involves automatic garbage collection and manual memory allocation.

    • Java uses automatic garbage collection to free up memory

    • Developers can manually allocate memory using the 'new' keyword

    • Java also has a 'finalize' method to clean up resources before garbage collection

    • Memory leaks can occur if objects are not properly released

  • Answered by AI
  • Q4. What is Hash map in java
  • Ans. 

    Hash map is a data structure that stores key-value pairs and allows fast retrieval of values based on keys.

    • Hash map uses hashing to store and retrieve values based on keys

    • It allows null values and null keys

    • It is not synchronized and not thread-safe

    • Example: HashMap<String, Integer> map = new HashMap<>();

    • map.put("apple", 1); int value = map.get("apple");

  • Answered by AI
  • Q5. Primary key and candidate key difference
  • Ans. 

    Primary key uniquely identifies a record while candidate key can also uniquely identify a record but may not be chosen as primary key.

    • Primary key is a column or set of columns that uniquely identifies each record in a table

    • Candidate key is a column or set of columns that can also uniquely identify each record in a table

    • A table can have multiple candidate keys but only one primary key

    • Primary key cannot have null values ...

  • Answered by AI
  • Q6. Super key and foreign key difference
  • Ans. 

    Super key is a set of attributes that uniquely identifies a record, while foreign key is a reference to a primary key in another table.

    • Super key is a combination of one or more attributes that uniquely identifies a record in a table.

    • Foreign key is a field in a table that refers to the primary key of another table.

    • Super key can have additional attributes that are not necessary for uniqueness.

    • Foreign key establishes a re...

  • Answered by AI
  • Q7. List all languages in Sql and explain
  • Ans. 

    List of SQL languages and their brief explanation

    • SQL (Structured Query Language) is a standard language for managing relational databases

    • T-SQL (Transact-SQL) is a proprietary extension of SQL used by Microsoft SQL Server

    • PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's proprietary extension of SQL

    • MySQL is an open-source relational database management system that uses SQL

    • PostgreSQL is an ope...

  • Answered by AI
  • Q8. And some questions related to project

Interview Preparation Tips

Topics to prepare for Capgemini Data Analyst Intern interview:
  • SQL Server
  • Java
  • Python
Interview preparation tips for other job seekers - My interview process :
First I registered myself in the link provided by the college and then I got mail for attending technical assessment, It consists of four rounds namely Data Structure& Pseudo Code, logical ability,gaming round and finally Behavioral questions round each round is elimination after clearing all those rounds.I was assigned to attend my technical interview after clearing that I got a message in Capgemini what's up saying ,I am selected to be a part of Capgemini Technology Service India Limited .
Don't lie in resume
Before attending any exam see related videos in YouTube to perform better

Skills evaluated in this interview

Interview questions from similar companies

I applied via Job Fair and was interviewed before Feb 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 
Round 2 - One-on-one 

(1 Question)

  • Q1. Basic accounting methods and journals

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident About what you are saying

What people are saying about Capgemini

View All
thrivingsnapdragon
1w
works at
Accenture
Need feedback regarding One Finance BU at Capgemini
I am planning to join the One Finance Transformation team under Group IT at Capgemini. Can you please provide some insights if it is a good option to join in terms of learning, career progression and monetary benefits? Thanks.
Got a question about Capgemini?
Ask anonymously on communities.

Analyst Interview Questions & Answers

TCS user image Anonymous

posted on 18 Apr 2021

I applied via Referral and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Background
  • Q2. Expertise

Interview Preparation Tips

Interview preparation tips for other job seekers - Be to the point and list swot

I appeared for an interview in Jun 2016.

Interview Questionnaire 

3 Questions

  • Q1. General hr questions
  • Q2. About technology used earlier
  • Q3. Included work profile and negotiations

Data Analyst Interview Questions & Answers

TCS user image Mahuya Khan Basak

posted on 12 Nov 2017

I appeared for an interview before Nov 2016.

Interview Preparation Tips

Round: Test
Experience: Only Written
Duration: 1 hour 45 minutes
Total Questions: 100

Skills: Proficiency In English, Basic concepts of computer, Commerce background with 50%
Are these interview questions helpful?

Analyst Interview Questions & Answers

TCS user image Priya Prabhu

posted on 24 Sep 2015

Interview Questionnaire 

1 Question

  • Q1. Tell me about your project
  • Ans. 

    I worked on a project analyzing customer data to identify trends and improve marketing strategies.

    • Used data analysis techniques to identify patterns and correlations in customer behavior

    • Developed predictive models to forecast customer preferences and optimize marketing campaigns

    • Collaborated with cross-functional teams to implement data-driven strategies and measure their impact

    • Conducted A/B testing to evaluate the effe...

  • Answered by AI

Interview Preparation Tips

Round: Technical Interview
Experience: comfortable
Tips: study the project well, final year project as well as the mini projects done in the semesters

General Tips: study the project details, basic core languages of your stream
Skill Tips: study the project details very well
Skills: Ability To Deliver On A Project
College Name: Vidyalankar Institute Of Technology

Analyst Interview Questions & Answers

TCS user image Anonymous

posted on 13 May 2018

Interview Preparation Tips

Round: Test
Experience: Aptitude

Round: Group Discussion
Experience: They will observe way of talking, way of making points to concerns etc

Analyst Interview Questions & Answers

TCS user image Anonymous

posted on 26 Mar 2015

Interview Questionnaire 

16 Questions

  • Q1. Tell me about yourself?
  • Ans. 

    I am a detail-oriented analyst with a strong background in data analysis and problem-solving, passionate about driving insights from data.

    • Educational Background: I hold a degree in Statistics, which provided me with a solid foundation in data analysis techniques.

    • Professional Experience: I have over 3 years of experience working as a data analyst at XYZ Corp, where I improved reporting efficiency by 30%.

    • Technical Skills...

  • Answered by AI
  • Q2. Are you 100% honest ?
  • Ans. 

    I strive for honesty, but like everyone, I may not always be 100% truthful in every situation.

    • Honesty is important in my work, but I recognize that context matters.

    • For example, I might withhold certain details to protect someone's feelings.

    • In data analysis, I present findings accurately, but interpretations can vary.

    • I believe in transparency, yet I also understand the need for discretion.

  • Answered by AI
  • Q3. What are ur favorite subjects?
  • Q4. What do you mean by Multithreading in java?
  • Ans. 

    Multithreading in Java refers to the concurrent execution of two or more parts of a program for maximum utilization of CPU.

    • Multithreading allows multiple threads to run concurrently within a single program.

    • It improves the performance of the program by utilizing the CPU more efficiently.

    • Java provides built-in support for multithreading through the java.lang.Thread class.

    • Multithreading can be used for tasks such as backg...

  • Answered by AI
  • Q5. What are the different CpU scheduling policies? who does the cpu scheduling?
  • Ans. 

    CPU scheduling policies include FCFS, SJF, Round Robin, Priority, and Multilevel Queue. The operating system does the scheduling.

    • FCFS (First Come First Serve)

    • SJF (Shortest Job First)

    • Round Robin

    • Priority

    • Multilevel Queue

    • Operating system does scheduling

  • Answered by AI
  • Q6. What is Jvm? who manages the thread Jvm or OS?
  • Ans. 

    Jvm is Java Virtual Machine. It manages threads on its own.

    • Jvm is a virtual machine that executes Java bytecode.

    • It provides a runtime environment for Java programs.

    • Jvm manages threads on its own using its own thread scheduler.

    • Jvm is platform-independent and provides a layer of abstraction between the Java code and the underlying operating system.

    • Examples of popular JVM implementations include Oracle's HotSpot and OpenJ...

  • Answered by AI
  • Q7. Semaphore?synchronisation in java? Mutex?
  • Q8. Explain tree traversals technique with example??
  • Ans. 

    Tree traversal is a technique to visit all nodes of a tree in a specific order.

    • There are three types of tree traversals: inorder, preorder, and postorder.

    • Inorder traversal visits the left subtree, then the root, and then the right subtree.

    • Preorder traversal visits the root, then the left subtree, and then the right subtree.

    • Postorder traversal visits the left subtree, then the right subtree, and then the root.

    • For exampl...

  • Answered by AI
  • Q9. What is the difference between arraylist and vector? how to traverse a vector?
  • Ans. 

    ArrayList and Vector are both dynamic arrays, but Vector is synchronized and slower. Traversing a Vector is similar to an ArrayList.

    • ArrayList is not synchronized, while Vector is synchronized.

    • ArrayList is faster than Vector, but Vector is thread-safe.

    • To traverse a Vector, we can use a for loop or an iterator, similar to an ArrayList.

    • Example: Vector v = new Vector<>(); for(String s : v) { //do something }

  • Answered by AI
  • Q10. Why TCS?
  • Ans. 

    TCS is a leading global IT services company with a strong reputation and diverse opportunities for growth.

    • TCS has a strong reputation in the IT industry

    • TCS offers diverse opportunities for growth and learning

    • TCS has a global presence and works with top clients

    • TCS has a strong focus on innovation and technology

    • TCS provides a supportive and inclusive work environment

  • Answered by AI
  • Q11. Any five tata group companies other than TCS?
  • Q12. What is the Tata‘s product used in every house?
  • Ans. 

    Tata Salt is the product used in every house.

    • Tata Salt is a brand of salt produced by Tata Chemicals.

    • It is the market leader in India with a 27% market share.

    • Tata Salt has been fortified with iodine to help address iodine deficiency in India.

    • It is available in various sizes and packaging options to suit different needs.

    • Tata Salt has won several awards for its quality and innovation.

  • Answered by AI
  • Q13. What‘s your hobby and passion?
  • Ans. 

    My hobby and passion is photography.

    • I love capturing moments and telling stories through my photographs.

    • I enjoy exploring different techniques and experimenting with composition.

    • Photography allows me to express my creativity and view the world from unique perspectives.

    • I have participated in several photography competitions and my work has been featured in local exhibitions.

    • Some of my favorite subjects to photograph are...

  • Answered by AI
  • Q14. In your views who should be the captain of Indian cricket team?
  • Ans. 

    Rohit Sharma's experience and leadership skills make him an ideal captain for the Indian cricket team.

    • Rohit Sharma has a proven track record as captain in IPL, leading Mumbai Indians to multiple titles.

    • His calm demeanor under pressure helps in making strategic decisions during crucial matches.

    • Rohit's ability to adapt his batting style according to the situation is crucial for leading by example.

    • He has a good rapport wi...

  • Answered by AI
  • Q15. What are the qualities of a good leader ?
  • Ans. 

    A good leader possesses qualities such as strong communication skills, empathy, integrity, and the ability to inspire and motivate others.

    • Strong communication skills: A good leader is able to effectively convey their ideas and instructions to their team members.

    • Empathy: A good leader understands and considers the feelings and perspectives of their team members, fostering a positive and supportive work environment.

    • Integ...

  • Answered by AI
  • Q16. Worst situation you have ever faced in your life ?
  • Ans. 

    Being stranded in a foreign country with no money or means to communicate

    • Lost my wallet with all my money and identification

    • Couldn't speak the local language to ask for help

    • Had to rely on the kindness of strangers for assistance

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: There were no technical questions. Only quantitative questions was there. Questions were not very tough.
Tips: Just have a look at RS Aggarwal book or any other aptitude book , you will easily get through it.
Duration: 80 minutes

Round: Other Interview
Experience: There were different panels , having three persons in each panel. It was basically HR , TECh, MR interview altogether. Even some of the students were called for one to one tech interview and later they were called for hr and mr round.

Skills: JAVA, C/C++
College Name: NA

Skills evaluated in this interview

Capgemini Interview FAQs

How many rounds are there in Capgemini Data Analyst Intern interview?
Capgemini interview process usually has 2-3 rounds. The most common rounds in the Capgemini interview process are Technical, Resume Shortlist and Coding Test.
What are the top questions asked in Capgemini Data Analyst Intern interview?

Some of the top questions asked at the Capgemini Data Analyst Intern interview -

  1. List all languages in Sql and expl...read more
  2. What is Hash map in j...read more
  3. Super key and foreign key differe...read more

Tell us how to improve this page.

Overall Interview Experience Rating

4/5

based on 1 interview experience

Difficulty level

Easy 100%

Duration

2-4 weeks 100%
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.6
 • 11.1k Interviews
Accenture Interview Questions
3.7
 • 8.7k Interviews
Infosys Interview Questions
3.6
 • 7.9k Interviews
Wipro Interview Questions
3.7
 • 6.1k Interviews
Cognizant Interview Questions
3.7
 • 5.9k Interviews
Tech Mahindra Interview Questions
3.5
 • 4.1k Interviews
HCLTech Interview Questions
3.5
 • 4.1k Interviews
Genpact Interview Questions
3.7
 • 3.4k Interviews
IBM Interview Questions
3.9
 • 2.5k Interviews
DXC Technology Interview Questions
3.6
 • 842 Interviews
View all
Capgemini Data Analyst Intern Salary
based on 6 salaries
₹1.8 L/yr - ₹5.4 L/yr
24% less than the average Data Analyst Intern Salary in India
View more details
Consultant
58.6k salaries
unlock blur

₹8.9 L/yr - ₹16.5 L/yr

Associate Consultant
51.2k salaries
unlock blur

₹4.5 L/yr - ₹10 L/yr

Senior Consultant
50k salaries
unlock blur

₹12.4 L/yr - ₹21 L/yr

Senior Analyst
22.1k salaries
unlock blur

₹3.1 L/yr - ₹7.5 L/yr

Senior Software Engineer
21.6k salaries
unlock blur

₹4.7 L/yr - ₹12.9 L/yr

Explore more salaries
Compare Capgemini with

Wipro

3.7
Compare

Accenture

3.7
Compare

Cognizant

3.7
Compare

TCS

3.6
Compare
write
Share an Interview