Capgemini Associate Data Engineer Interview Questions and Answers for Freshers

Q1. What is scd type 2?
Ans. 
SCD type 2 is a method used in data warehousing to track historical changes by creating a new record for each change.
• SCD type 2 stands for Slowly Changing Dimension type 2

• It involves creating a new record in the dimension table whenever there is a change in the data

• The old record is marked as inactive and the new record is marked as current

• It allows for historical tracking of changes in data over time

• Example: If a cust...read more
Answered by AI
Add your answer
Q2. Pyspark question read CSV from folder and add column in each csv file and write it to different location.
Add your answer

Q1. What is L1 and L2 Regularization?
Ans. 
L1 and L2 regularization are techniques used in machine learning to prevent overfitting by adding penalty terms to the cost function.
• L1 regularization adds the absolute values of the coefficients as penalty term to the cost function.

• L2 regularization adds the squared values of the coefficients as penalty term to the cost function.

• L1 regularization can lead to sparse models by forcing some coefficients to be exactly zer...read more
Answered by AI
View 1 more answer

Q1. What is data entry? How to do data entry?
Ans. 
Data entry is the process of entering, updating, or verifying data in a computer system or database.
• Data entry involves inputting alphanumeric data into a computer system.

• Accuracy and speed are important in data entry.

• Common tools used in data entry include keyboards, scanners, and data entry software.

• Examples of data entry tasks include entering customer information, updating inventory records, and transcribing handwr
Answered by AI
View 2 more answers
Q2. What is your passion?
Add your answer
Q3. What kind of work you hava to work in thise office
Add your answer
Q4. How to like thise company
Add your answer

A="bala",b="Babu";
Print=A+b
O/p:
balababu

Python is a computer programming language use to build up software and websites designed by Rossum appear in 20 Feb 1991
1.Numpy is a python libraries working with arrays.
2.pandas is used to read the data sets.
3.matplotlib libraries for visualisation.
4.mission learning is divided into two parts.
*Supervised learning
*Unsupervised learning
5.deep learning is used to create artificial neurons.
6.advance excel is used for graphs and calculate the whole members at same time lot of useful things that have.
7mysql is mainly used for store the data.

Python, numpy, pandas, mission learning, deep learning, basic statistics, advance excel, MySQL

Python, numpy, pandas, mission learning, deep learning, basic statistics, advance excel, MySQL

Q1. Why we use mission learning Mission learning used for analysis the data's and we can able to predict and we add some additional algorithm it's mainly used for prediction and AI.
Ans. 
Mission learning is used for data analysis and prediction with additional algorithms for AI.
• Mission learning is a subset of machine learning that focuses on predicting outcomes based on data analysis.

• It involves using algorithms to learn patterns and make predictions based on new data.

• Examples include image recognition, natural language processing, and recommendation systems.
Answered by AI
Add your answer
Q2. Deep learning uses: Deep learning Mainly used for creating artificial neurons in the neural network. Deep learning is very aid about the mission how to work and artificial intelligence helps also
Add your answer
Q3. Statistics: Statistics is used for mathamatics operation and it helps to prediction. Example: We started to calculate how many persons live in between 20to25 age. That time statistics is very help to reduc...read more
Add your answer

I don't know idea about group discussion

Basic DP, Array Questions

Q1. Resume Walkthrough and Discussion, Medium level coding questions
Add your answer

Q1. Discussion with Manager
Add your answer

Q1. Normal HR round
Add your answer

Q1. Tell me your self
Ans. 
I am a detail-oriented individual with strong data entry skills and experience in various industries.
• I have worked as a data entry operator for 2 years at XYZ company

• I am proficient in Microsoft Excel and have experience in data analysis

• I have excellent typing speed and accuracy

• I am a quick learner and can adapt to new software and systems easily
Answered by AI
View 1 more answer
Q2. About your family members
Add your answer
Q3. About our company
Add your answer
Q4. Freshers or experienced
Add your answer

Q1. What are hyperparameters in random forest
Ans. 
Hyperparameters in random forest are parameters that are set before the learning process begins.
• Hyperparameters control the behavior of the random forest algorithm.

• They are set by the data scientist and are not learned from the data.

• Examples of hyperparameters in random forest include the number of trees, the maximum depth of trees, and the number of features considered at each split.
Answered by AI
Add your answer
Q2. How to do QnA system with LLM
Ans. 
A QnA system with LLM is a system that uses the Language Model for Information Retrieval and Question Answering.
• Preprocess the input question and convert it into a format suitable for the LLM model.

• Fine-tune the LLM model on a dataset of question-answer pairs.

• Use the fine-tuned model to generate answers for new questions.

• Evaluate the performance of the QnA system using metrics like precision, recall, and F1 score.

• Itera...read more
Answered by AI
Add your answer
Q3. How to do unit testing
Ans. 
Unit testing is a process of testing individual units of code to ensure they function correctly.
• Write test cases for each unit of code

• Test inputs, outputs, and edge cases

• Use testing frameworks like JUnit or pytest

• Automate tests to run regularly

• Ensure tests are independent, isolated, and repeatable
Answered by AI
Add your answer

Question related to maths basic and some basic blood relations questions

Q1. All the questions we asked based on the Resume
Add your answer
Q2. Basic question of program like pattern matching prime number
Add your answer