Accenture Data Quality 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

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.

The test will be conducted in a interview process

Group discussion is a communicate in a people

Q1. Hr face to face commutation
Add your answer
Q2. Self introduction and
Add your answer

Q1. It is the individual interview
Add your answer
Q2. Personal questions only
Add your answer