ETL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ETL Interview Questions

Questions Answers Views Company eMail

What are the three tiers in etl?

1117

What are dimensions?

1071

What are the steps involved in etl process?

1042

What is initial load and what is full load?

993

Explain different types of partitioning?

1046

List few etl bugs?

952

What are three tier systems in etl?

1071

What are your responsibilities as an etl tester?

1170

What is grain of fact?

988

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

1013

What do you understand by the term ‘transformation’?

1049

Explain the key challenges that you face while performing etl testing.

1020

Mention few test cases and explain them?

935

Explain etl mapping sheets?

1083

What is tracing level and what are the types?

973

Post New ETL Questions

Un-Answered Questions { ETL }

what is the main role of FI on business

2112

How to fine tune mappings?

951

What is partitioning? Explain about round-robin, hash partitioning.

974

What is virtual Data Warehousing?

987

How can we use external procedural logic in informatica?

928

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2287

Mention few test cases and explain them?

935

how to load the data to fact table?

2715

how do u really know that paging to disk is happening while u are using a lookup transform?

1995

What are the types of Data Warehouse applications?

1032

how would u estimate the size of Lookup transform data and index cache?

2139

What are the ETL Testing Operations?

1059

what are the concerns of OLTP and DSS systems?

1966

Compare etl & elt?

1017

Explain about the data integration suite features?

959

For More Un-Answered { ETL } Questions Click Here