Wipro Data Engineer 3 Interview Questions and Answers

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. Explain your project structure ?
Ans. 
My project structure follows a modular approach with separate folders for data ingestion, processing, and storage.
• Separate folders for data ingestion, processing, and storage

• Use of version control for tracking changes

• Documentation for each module and process

• Unit tests for data pipelines

• Logging and monitoring for tracking data flow
Answered by AI
Add your answer
Q2. What is mean by dag ?
Ans. 
DAG stands for Directed Acyclic Graph, a data structure used to represent dependencies between tasks in a workflow.
• DAG is a collection of nodes connected by directed edges, where each edge represents a dependency between tasks.

• It is acyclic, meaning there are no cycles or loops in the graph.

• DAGs are commonly used in data processing pipelines to ensure tasks are executed in the correct order.

• Example: In a DAG representi...read more
Answered by AI
Add your answer

Q1. Tell. me about youself
Add your answer
Q2. Sql question , pyspark questions
Add your answer

1. Questions on spark basica
2. Sql coding questions
3. Java or scala basics

Q1. About my work experience About my job nature
Add your answer
Q2. How many years of job experience.proof about my character given by previous office as conduct certificate.
Add your answer
Q3. How will I do my job. I will work with gratitude
Add your answer
Q4. Do I have experience in this job I am having basic knowledge as I think it is enough to my work.
Add your answer
Q5. How about my character? I am dedicated worker
Add your answer
Q6. What about my nature? I am a reserve type.i speak less work more.
Add your answer
Q7. No comments I will prove by doing job .
Add your answer

I am basically commerce oriented student.i know basic typing,ms office like ms word and ms excel.and I am having tally certificate from college.

Q1. Tell me about yourself?
Ans. My name is Namrata. I completed my bsc in PCM
Answered Anonymously
View 1 more answer
Q2. What are your skills?
Ans. Ms office, word excel powerpoint, Internet. Leadership, solving problems etc
Answered Anonymously
Add your answer
Q3. About the job profile
Add your answer

Logical Reasoning Quants English and SQL medium level

Q1. Questions on your projects and past experience.
Add your answer

Q1. Tell me about yourself. Why this role? Why should we hire you?
Add your answer

Q1. What is your Qualification
Add your answer
Q2. What's your expectation regarding your Salary
Add your answer
Q3. What is your family background
Add your answer
Q4. How old are you are you twenty years old
Add your answer
Q5. What is your highest qualification
Add your answer
Q6. Is your brother working
Add your answer
Q7. If so Work From Home
Add your answer