Capgemini Interview Questions, Process, and Tips for Freshers

Q1. Explain pandas in real time scenario.
Ans. 
Pandas is a powerful Python library for data manipulation and analysis, ideal for handling structured data.
• Data Cleaning: Remove duplicates and handle missing values. Example: df.drop_duplicates() or df.fillna(0).

• Data Transformation: Reshape data using pivot tables. Example: df.pivot_table(values='sales', index='date', columns='product').

• Data Aggregation: Group data for summary statistics. Example: df.groupby('category...read more
Answered by AI
Add your answer
Q2. Explain oops concepts in detail
Ans. 
OOP concepts include encapsulation, inheritance, polymorphism, and abstraction, forming the foundation of object-oriented programming.
• Encapsulation: Bundling data and methods that operate on the data within a single unit (class). Example: A class 'Car' with attributes like 'color' and methods like 'drive()'.

• Inheritance: Mechanism where a new class derives properties and behavior from an existing class. Example: 'Electr...read more
Answered by AI
Add your answer

Q1. Basic OOPS concept which is mandatory to keep up to date
Add your answer
Q2. Some Sql quetions and arrays and list concept
Add your answer

First part was mostly easy aptitude questions with some medium level ones. Second part had easy coding questions based on loops and conditional statements.

Q1. Each person was given a topic to write an essay
Add your answer

Q1. Cognitive and memory based timed and untimed puzzles and games were given
Add your answer

Two easy coding questions were given to solve both based on strings and hash map.

Q1. Online interview took place after a few days. For 20 minutes technical questions were on my projects, internship and basic data structure like queues and arrays.
Add your answer

Q1. What is windows function bigquery
Ans. 
Window functions in BigQuery are used to perform calculations across a set of table rows related to the current row.
• Window functions allow you to perform calculations on a set of rows related to the current row

• They are used with the OVER() clause in SQL queries

• Common window functions include ROW_NUMBER(), RANK(), and NTILE()

• They can be used to calculate moving averages, cumulative sums, and more
Answered by AI
Add your answer
Q2. What types on nosql databases in gcp
Ans. 
Types of NoSQL databases in GCP include Firestore, Bigtable, and Datastore.
• Firestore is a flexible, scalable database for mobile, web, and server development.

• Bigtable is a high-performance NoSQL database service for large analytical and operational workloads.

• Datastore is a highly scalable NoSQL database for web and mobile applications.
Answered by AI
Add your answer
Q3. Write code to find max number of product by customer
Ans. 
Code to find max number of product by customer
• Iterate through each customer's purchases

• Keep track of the count of each product for each customer

• Find the product with the maximum count for each customer
Answered by AI
Add your answer
Q4. Read dataframe python and pyspark
Add your answer
Q5. Create dataframe
Ans. 
Creating a dataframe in GCP Data Engineer
• Use the pandas library to create a dataframe

• Provide data in the form of a dictionary or list of lists

• Specify column names if needed
Answered by AI
Add your answer

Q1. Why react is faster, default parameters, can you call async function in useEffect
Ans. 
React is faster due to virtual DOM, default parameters provide fallback values, async functions can be called in useEffect
• React is faster than traditional DOM manipulation because it uses a virtual DOM to minimize actual DOM updates

• Default parameters in JavaScript allow you to specify default values for function parameters if no value is provided

• Async functions can be called in useEffect hook in React to perform asynch
Answered by AI
View 1 more answer
Q2. ES6 features, react hooks
Add your answer

The test is very easy and prepare well

In two coding questions, solve atleast one to get high packages

Q1. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Statistics and experience working with large datasets

• I am proficient in statistical software such as R and Python

• I have a proven track record of delivering actionable insights to drive business decisions
Answered by AI
Add your answer
Q2. Project expalantaion
Add your answer
Q3. How do you handle deadlines
Ans. 
I prioritize tasks, set realistic timelines, communicate any challenges, and adjust as needed to meet deadlines.
• Prioritize tasks based on urgency and importance

• Set realistic timelines for each task

• Communicate any challenges or delays to stakeholders

• Adjust and re-prioritize tasks as needed to meet deadlines
Answered by AI
Add your answer