ETL (Extract, Transform, Load) testing is an essential part of data warehousing to ensure the accuracy, completeness, and consistency of data in the data warehouse. In this course you will learn Source-to-target mapping validation where you can compare the source data after applying the transformation rules with the target data after ETL processing and Data reconciliation to validate the completeness and accuracy of data after ETL processing.
By comparing the source data after applying the transformation rules with the target data, we can ensure that the transformation logic is applied correctly and there are no data loss or data truncation issues.
• In the end of the this section I am glad to inform you that you are aware now about:
•What is ETL
•What is ETL test
•What is ETL test tools
•How to create a test case
•When to test by eyeballing
•When to test by SQL query
•How to test transformation logic
•How to make a formula that can help you test faster
•How to test records counts by SQL query
•How to test null values by SQL query
•How to test duplicate values by SQL query
•How to test completeness for huge amount of data
Who should follow this course?
Students that want to learn the basics of Source-to-target mapping validation.
Business Analysts and Data Analysts that would like to learn more about Data reconciliation.
Software test Engineers and Managers considering to apply data quality standards within their organization
Requirements
Basic knowledge of SQL ( This course use DBeaver as s a free and open-source SQL client and database management tool).
Database setup (PostgreSQL, Oracle, SQL Server etc.) is recommended.
The course consists of the following modules:
Introduction
What is ETL/ELT Testing and Data Quality Management?
Understand the Mapping document
frame the source and target queries
Perform the data validation.
In this course, you will learn two easy techniques how to paint fireworks with watercolours.
Improving software development productivity. Practical techniques. First steps.
Smart Home Tech Tour for Smart Home Automation Project
Experienced information system analyst, software and robot process automation developer with a demonstrated history of working in ICT sector. Worked with multiple information technology project teams and business partners with a Master of Science ( Distinction grade by UK grade rate) focused in TECHNOLOGY MANAGEMENT from Staffordshire University. Good development/coding skill with Good understanding of business processes and Strong analytical and problem-solving skills.
Experienced information system analyst, software and robot process automation developer with a demonstrated history of working in ICT sector. Worked with multiple information technology project teams and business partners with a Master of Science ( Distinction grade by UK grade rate) focused in TECHNOLOGY MANAGEMENT from Staffordshire University. Good development/coding skill with Good understanding of business processes and Strong analytical and problem-solving skills.
