Accenture Data Management Associate Interview Questions, Process, and Tips

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. How tfidf works in NLP
Ans. 
TF-IDF is a statistical measure used to evaluate the importance of a word in a document.
• TF-IDF stands for Term Frequency-Inverse Document Frequency

• It is used to weigh a word's importance in a document by considering its frequency in the document and across all documents

• The formula for TF-IDF is: TF-IDF = TF * IDF

• TF (Term Frequency) measures how frequently a term appears in a document

• IDF (Inverse Document Frequency) mea...read more
Answered by AI
Add your answer
Q2. What is the difference between group by and window function in sql
Ans. 
Group by is used to group data based on a column while window function is used to perform calculations on a specific window of data.
• Group by is used to aggregate data based on a specific column

• Window function is used to perform calculations on a specific window of data

• Group by is used with aggregate functions like sum, count, avg, etc.

• Window function is used with analytical functions like rank, lead, lag, etc.

• Group by ...read more
Answered by AI
Add your answer

Q1. Tell me about the project you worked on 4 years back
Ans. 
Developed a predictive model to forecast customer churn for a telecom company.
• Used machine learning algorithms like logistic regression and random forest.

• Preprocessed and cleaned the dataset by handling missing values and outliers.

• Performed feature engineering to create new variables for better model performance.

• Evaluated model performance using metrics like accuracy, precision, and recall.

• Implemented the model in prod
Answered by AI
Add your answer
Q2. Why are you leaving your current company
Ans. 
Seeking new challenges and opportunities for growth.
• Looking for a more challenging role that aligns with my career goals.

• Seeking a company that values innovation and encourages professional development.

• Want to work in a more collaborative and diverse team environment.

• Desire to explore new technologies and industries.

• Current company lacks opportunities for advancement or career growth.
Answered by AI
Add your answer

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