Wipro Associate Consultant Data Analyst 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

General question around data engineering

Q1. Different apache tech and tools
Add your answer
Q2. What is snowflake
Add your answer
Q3. Coding questions on python
Add your answer

Q1. About location preference
Add your answer
Q2. Behavioural questions
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

We can that group discussion also

I give assignment when give any topics

Q1. Related to data entry operator
Add your answer
Q2. Any data related to company
Add your answer
Q3. I give my best in thiscompany
Ans. 
Yes i give to my best with tha company all issues to slove
Answered Anonymously
Add your answer
Q4. I do hard work to growth tha company
Ans. 
Yes i will do with tha company all issues to slove
Answered Anonymously
Add your answer
Q5. I completed my worktime to time
Ans. 
Yes i complete with tha company all issues to slove
Answered Anonymously
Add your answer

Q1. Data entry, marketing
Add your answer
Q2. Any questions , computer
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