AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Capgemini
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Capgemini Data Analyst Interview Questions, Process, and Tips
Top Capgemini Data Analyst Interview Questions and Answers
- Q1. Ninja and His Secret Information Encoding Problem Ninja, a new member of the FBI, has acquired some 'SECRET_INFORMATION' that he needs to share with his team. To ensure ...read more
- Q2. Equilibrium Index Problem Statement Given an array Arr consisting of N integers, your task is to find the equilibrium index of the array. An index is considered as an eq ...read more
- Q3. How do you use field parameter in dynamic reporting
Capgemini Data Analyst Interview Experiences
53 interviews found
Anonymous
Selected
I applied via Naukri.com and was interviewed before Mar 2023. There were 2 interview rounds.
(1 Question)
- Q1. What are joins in sQL?
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column between them.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
(1 Question)
- Q1. Tell me about you?
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed before Sep 2022. There were 3 interview rounds.
It was online, we can do it easily if we study n prepare well
(1 Question)
- Q1. 1)so firstly she started asking about how am i? 2)then she made sure to ask me about my lunch whether i had or not ,then she continued with technical qstbs 3)Data types in c 4)Reserved words in programming...
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Dec 2021. There were 3 interview rounds.
Basics of Data structures
(1 Question)
- Q1. Asked about projects and about C++
Interview Preparation Tips
- Project
- C++
What people are saying about Capgemini
Selected
I was interviewed before Jan 2023.
English and general
Data Structure, Computers Network , java ,sql
(2 Questions)
- Q1. Even odd coding
- Q2. Sql query retrive data from database shorting
- Ans.
SQL query to retrieve data from a database and sort it
Use the SELECT statement to retrieve data
Use the ORDER BY clause to specify the sorting order
Specify the column(s) to sort by in the ORDER BY clause
Use ASC for ascending order and DESC for descending order
Example: SELECT * FROM table_name ORDER BY column_name ASC
Interview Preparation Tips
Skills evaluated in this interview
Capgemini interview questions for designations
I applied via Campus Placement and was interviewed before Oct 2022. There were 4 interview rounds.
Medium level questions based on profit/loss percentage etc
Englist story writing
(2 Questions)
- Q1. Questions related to sql and core subjects
- Q2. 2nd highest salary in a company
Get interview-ready with Top Capgemini Interview Questions
I applied via Referral and was interviewed in Mar 2022. There were 2 interview rounds.
(6 Questions)
- Q1. What are your strengths and weaknesses?
- Ans.
My strengths include strong analytical skills and attention to detail. My weaknesses include a tendency to overthink and a lack of experience with certain software tools.
Strength: Strong analytical skills
Strength: Attention to detail
Weakness: Overthinking
Weakness: Lack of experience with certain software tools
- Q2. Tell me about yourself.
- Ans.
I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.
I have a strong background in statistics and data analysis techniques.
I am proficient in using tools such as SQL, Python, and Tableau for data manipulation and visualization.
I have experience in conducting data quality checks and ensuring data integrity.
I have worked on projects involving predictive modeling a...
- Q3. What are you salary expectations
- Ans.
I am open to discussing salary based on the responsibilities and opportunities offered by the position.
I am flexible and open to negotiation.
I am more interested in the overall package and growth opportunities rather than just the salary.
I would like to know more about the responsibilities and expectations of the role before discussing specific numbers.
- Q4. What is your skills what is your gole
- Ans.
I have strong skills in data analysis and my goal is to leverage data to drive insights and make informed decisions.
Proficient in data analysis tools such as SQL, Python, and Excel
Experience in data cleaning, transformation, and visualization
Ability to analyze large datasets and identify patterns and trends
Strong problem-solving and critical thinking skills
Effective communication and presentation of data findings
Goal i...
- Q5. What is your skills what is your qualifications
- Ans.
I have strong skills and qualifications in data analysis.
Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau
Experience in cleaning and transforming large datasets for analysis
Ability to identify trends, patterns, and insights from data
Strong problem-solving and critical thinking skills
Excellent communication and presentation skills to convey complex findings to non-technical s
- Q6. What is your vellige
- Ans.
My vellige is the ability to analyze and interpret data to provide valuable insights and make informed decisions.
Proficient in data analysis techniques and tools
Strong statistical and mathematical skills
Experience in data visualization and reporting
Ability to identify patterns and trends in data
Effective communication and presentation skills
Interview Preparation Tips
- Data Structures
Data Analyst Jobs at Capgemini
I applied via Campus Placement and was interviewed in Oct 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. What is join,what is doubly linked list
- Ans.
Join is a SQL operation that combines rows from two or more tables based on a related column. Doubly linked list is a data structure that consists of a set of sequentially linked records called nodes.
Join is used to retrieve data from multiple tables based on a related column
There are different types of joins such as inner join, left join, right join, and full outer join
Doubly linked list allows traversal in both direc...
Interview Preparation Tips
Skills evaluated in this interview
I applied via campus placement at Kongu Engineering College, Erode and was interviewed before Feb 2022. There were 2 interview rounds.
All about data structure, pseudocodes and puzzle solving.
(2 Questions)
- Q1. Questions related to your resume and basic questions of c language.
- Q2. Oops,dbms,sql,basic of c language etc..
Interview Preparation Tips
Concentrate on basics.
I applied via Walk-in and was interviewed in Mar 2021. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Basic Questions of Tableau and SQL
- Q2. Fixed LOD in Tableau and SQL both ways
- Ans.
Fixed LOD is a level of detail expression that calculates a value for a specific dimension combination.
Fixed LOD is used to calculate a value for a specific dimension combination in Tableau and SQL.
It is fixed because it does not change with the level of aggregation.
Example: { FIXED [Category], [Region] : SUM([Sales]) } calculates the sum of sales for each category and region combination.
- Q3. Doughnut chart using two measures
- Ans.
A doughnut chart can be created using two measures by assigning one measure to the size and the other to the color.
Assign one measure to the size of the doughnut chart
Assign the other measure to the color of the doughnut chart
Examples: Sales by Region and Profit Margin by Region
Use a legend to differentiate between the two measures
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in Feb 2021. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Asked About current role and Questions on SQL like Procedures,Triggers Exception handling
- Q2. ETL questions based on Loading the data and error handling
- Q3. Shell Scripting questions based on Awk ,sed,grep commands
Interview Preparation Tips
Capgemini Interview FAQs
The duration of Capgemini Data Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Capgemini Interviews By Designations
- Capgemini Analyst Interview Questions
- Capgemini Consultant Interview Questions
- Capgemini Software Engineer Interview Questions
- Capgemini Senior Consultant Interview Questions
- Capgemini Associate Consultant Interview Questions
- Capgemini Software Developer Interview Questions
- Capgemini Senior Analyst Interview Questions
- Capgemini Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Capgemini Data Analyst Interview Process
based on 46 interviews
4 Interview rounds
- Technical Round
- Coding Test Round
- One-on-one Round
- Personal Interview1 Round
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Capgemini Data Analyst Reviews and Ratings
based on 149 reviews
Rating in categories
|
Consultant
55.2k
salaries
|  ₹5.2 L/yr - ₹17.5 L/yr |
|
Associate Consultant
50.8k
salaries
| ₹3 L/yr - ₹10 L/yr |
|
Senior Consultant
46.1k
salaries
| ₹7.5 L/yr - ₹24.5 L/yr |
|
Senior Analyst
20.6k
salaries
| ₹2 L/yr - ₹7.5 L/yr |
|
Senior Software Engineer
20.2k
salaries
| ₹3.5 L/yr - ₹12.1 L/yr |
Wipro
Accenture
Cognizant
TCS
- Home >
- Interviews >
- Capgemini Interview Questions >
- Capgemini Data Analyst Interview Questions
