ETL- Extract Transform-Load is all about validating the data and the process in which data is transferred from Source to a Target System.
Similar to other types of testing, ETL also follows the same basic principles of testing.
As an ETL tester, one should know the following:
- Basic knowledge on database concepts
- Data validation
- Data Completeness
- The transformation logic used on the extracted data.
- Data Integrity
- SQL Queries
- System Performance testing
- ETL Concepts
- DWH knowledge
ETL testing is a broad process and requires good analytical skills resulting which ETL testers are in high demand in many QA testing companies.