Capgemini Senior Data Analyst Interview Questions and Answers

Q1. Tell me about Spark architecture
Ans. 
Spark architecture is a distributed computing framework that consists of a cluster manager and worker nodes.
• Spark architecture includes a driver program, cluster manager, and worker nodes.

• The driver program is responsible for dividing the Spark application into tasks and scheduling them on the worker nodes.

• Worker nodes execute the tasks and return the results to the driver program.

• Spark can run on various cluster manag...read more
Answered by AI
Add your answer

Q1. Various sql queries and questions were asked
Add your answer

Q1. Tell me about yourself
Ans. 
Experienced data analyst with a background in statistics and programming.
• Over 5 years of experience in analyzing and interpreting complex data sets

• Proficient in statistical analysis tools such as R and Python

• Strong background in data visualization techniques

• Excellent communication skills for presenting findings to stakeholders
Answered by AI
Add your answer

Q1. About ETL performance and mapping
Add your answer
Q2. About SQL advanced Query
Add your answer

Hacker rank test mostly on sql

Q1. Focused on Statistical analysis and sql. More sql questions on window functions
Add your answer
Q2. Sql joins and aggregation functions
Add your answer