Accenture ETL Tester Interview Questions, Process, and Tips

Q1. Etl tools and technologies
Add your answer
Q2. Types of scd dimensions
Ans. 
Slowly Changing Dimensions (SCD) include Type 1, Type 2, and Type 3 dimensions.
• Type 1: Overwrite existing data with new data, no history is kept.

• Type 2: Create a new record for each change, maintaining history.

• Type 3: Create a new attribute to store changes, keeping limited history.
Answered by AI
View 1 more answer

Q1. Tools used for ETL testing
Ans. 
Some tools used for ETL testing include Informatica, Talend, SSIS, and Apache Nifi.
• Informatica

• Talend

• SSIS (SQL Server Integration Services)

• Apache Nifi
Answered by AI
Add your answer

Q1. Advanced SQL for large data handling
Ans. 
Advanced SQL techniques for handling large datasets
• Use indexing to improve query performance

• Optimize queries by avoiding unnecessary joins and subqueries

• Utilize partitioning and clustering to manage large tables efficiently

• Consider using window functions for complex analytical queries
Answered by AI
Add your answer

Multiple choice questions

Q1. What is the difference between union and union all?
Ans. 
Union combines and removes duplicates, while union all combines without removing duplicates.
• Union removes duplicates from the result set, while union all does not.

• Union is slower than union all because it has to perform an additional step to remove duplicates.

• Union all is used when duplicates are desired in the result set.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM
Answered by AI
Add your answer
Q2. What is primary key?
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is unique

• It can be a single column or a combination of columns

• Primary key values cannot be NULL
Answered by AI
Add your answer

Before attending face to face interview we need clear online technical assessment. It's a objective type question mostly questions are related to unix, SQL, data warehousing,abinitio

Q1. Basic SQL queries like rank , denserank, joins, nvl, group by
Add your answer
Q2. Union union all difference
Ans. 
Union, Union All, and Difference are SQL set operators used to combine or compare data from multiple tables.
• Union combines the results of two or more SELECT statements and removes duplicates.

• Union All combines the results of two or more SELECT statements and includes duplicates.

• Difference (also known as Except) returns only the rows from the first SELECT statement that are not in the second SELECT statement.

• All three o...read more
Answered by AI
Add your answer
Q3. Fact dimension difference, database data warehouse difference
Add your answer

Q1. Mostly related to location and package negotiation
Add your answer