Menu
ETL stands for Extract Transform and Load
ETL Testing Service
In the ETL process, data is extracted from the source system and convert into a format that can be examined and stored into a data warehouse or any other system. ETL is an alternate but a related approach which is designed to push processing down to database to improve the performance.
Extract
Extract is the process of fetching (reading) the information from the database or shared path. At this stage, data is collected from multiple or different types of sources (table or files).
Transform
Transform is the process of converting the extracted data from its previous form into the required form. Data can be placed into another database. Transformation can occur by using rules or lookup tables or by combining the data with other data.
Load
Load is the process of writing the data into the target database
Type for ETL Testing
⦁ New Data Warehouse Testing
⦁ Production Validation Testing
⦁ Source to Target Testing (Validation).
⦁ Application Upgrade.
⦁ Metadata Testing
⦁ Data Accuracy Testing
⦁ Data Transformation Testing
⦁ Data Quality Testing
⦁ Incremental ETL Testing
⦁ GUI/Navigation Testing
⦁ Migration Testing
⦁ Report Testing
ETL Test Scenarios and Test Cases:
⦁ Mapping doc validation
⦁ Data Validation.
⦁ Constraint Validation
⦁ Data Consistency Issues
⦁ Completeness Issues
⦁ Correctness Issues
⦁ Transformation
⦁ Data Quality
⦁ Null Validate
⦁ Duplicate Check
⦁ Data Cleanness
⦁ Automation testing.
Operations performed in ETL Testing:
⦁ Validation of data movement from source to the target system.
⦁ Data count verification in the source and target system.
⦁ ETL testing verifies the transformation, extraction as per requirement and expectation.
⦁ ETL testing verifies if table relations join and keys are preservers during the transformation.
Testing Methodology:
Agile testing methodology
Domain knowledge:
Banking, Insurance, Mortgage and Wealth.
Tools:
ETL testing tool: Informatica
Database: Oracle, MYSQL, DB2, Redshift.
Test management tool: JIRA and HP-ALM
BI reporting tools: Cognos, Tableau
Automation tool: Java, Selenium.