ETL Testing

ETL stands for Extract-Transform-Load and it is a process of how data is loaded from the source system to the data warehouse. Data is extracted from an OLTP database, transformed to match the data warehouse schema and loaded into the data warehouse database.

What Will I Learn?

  • Understand the concepts of Business Intelligence Data warehousing
  • Get to know what is ETL Testing, QA Lifecycle and RDBMS Concepts
  • Gain an in-depth understanding of Data Warehouse WorkFlow and comparison between Database Testing and Data Warehouse Testing
  • Understand different ETL Testing scenarios like Constraint Testing, Source to Target Testing, Business Rules Testing, Negative Scenarios Testing, Dependency Testing, Error Handling Testing
  • Perform data Checks using SQL and understand the scope of BI Testing