ETL means Extract, Transform and Load. In this process, Data is extracted from different course databases and collected in a Data warehouse. Here, this data is processed and transformed in the format of the datawarehouse schema after which it is loaded into a separate datawarehouse database. This database makes data available for generating business intelligence reports, drawing insightful data interpretations and making business decisions. ETL Testing Course will teach you the tools, tables used to test the entire ETL process with the help of test cases and rules to make sure that desired results have been achieved without any data loss. In this course you will also gain a deep understanding of ETL Tools, Technologies and various RDBMS & Data Warehouse concepts.

We Covered ETL Testing Tools in Training :

iCEDQ

Data Gaps ETL Validator

QuerySurge

BiG EVALlytics

Integrate

Talend Open Studio

Informatica Data Validation

TestBench

DataQ

Apache Camel

SSISTester

QualiDI

Roles and Responsibilities of ETL Tester :

As a Data Test Engineer, you will be responsible for validating data sources, extracting data applications of transformation logic and uploading data in target tables. You will be responsible for designing, testing, and troubleshooting the client’s data storage system before it goes live. You must have strong technical capabilities and good knowledge of the coding languages commonly used in ETL development, such as Python, SQL and XML and Data warehousing Concepts. You should have a knowledge on Troubleshooting for bugs and errors and finding solutions of ETL Development. Familiarity with data warehouse architecture techniques like ODS, DM, EDW, M, and ROLAP is also needed. Extensive experience in solving complex technical problems and troubleshooting is must

Here are the key responsibilities of an ETL tester:

Test ETL software
Test ETL data warehouse components
Manages backend data-driven tests
Plan, design, and execute test layouts
Log the errors and implement solutions for fixing bugs and issues
Approve design specifications as per business requirements
Test data transfer
Write SQL queries for various situations
Check the test summary report

Syllabus of ETL Testing Training :

Module 1 : DWH Data Ware Housing Concepts

What is Data Warehouse?
Need of Data Warehouse
Introduction to OLTP, ETL and OLAP Systems
Difference between OLTP and OLAP
Data Warehouse Architecture
Data Marts
ODS[Operational Data Store]
Dimensional Modelling
Difference between relation and dimensional modelling
Star Schema and Snowflake Schema
What is fact table
What is Dimension table
Normalization and De-Normalization

Module 2 : ETL Testing

ETL architecture.
What is ETL and importance of ETL testing
How DWH ETL Testing is different from the Application Testing
SDLC/STLC in the ETL Projects (ex: V Model, Water fall model)

Module 3 : Challenges in DWH ETL Testing compare to other testing

Incompatible and duplicate data
Loss of data during ETL process
Testers have no privileges to execute ETL jobs by their own
Volume and complexity of data is very huge
Fault in business process and procedures
Trouble acquiring and building test data

Module 4 : ETL Testing Work flow activities involved

Analyze and interpret business requirements/ workflows to Create estimations
Approve requirements and prepare the Test plan for the system testing
Prepare the test cases with the help of design documents provided by the
developer team
Execute system testing and integration testing
Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)
How to detect the bugs in the ETL testing
How to report the bugs in the ETL testing
How to co-ordinate with developer team for resolving the defects

Module 5 : Types of ETL Testing
- Data completeness
- Data transformation
- Data quality
- Performance and scalability
- Integration testing
- User-acceptance testing
- SQL Queries for ETL Testing
- Incremental load testing
- Initial Load / Full load testing
Module 6 : Different ETL tools available in the market
- Informatica
- Ab Initio
- IBM Data stage
Module 7 : Power Center Components
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
- Power Center Admin Console
Module 8 : Informatica Concepts and Overview
- Informatica Architecture
Module 9 : Sources
- Working with relational Sources
- Working with Flat Files
Module 10 : Targets
- Working with Relational Targets
- Working with Flat file Targets
Module 11 : Transformations – Active and Passive Transformations
- Expression
- Lookup –Different types of lookup Caches
- Sequence Generator
- Filter
- Joiner
- Sorter
- Rank
- Router
- Aggregator
- Source Qualifer
- Update Strategy
- Normalizer
- Union
- Stored Procedure
- Slowly Changing Dimension
- SCD Type1
- SCD Type2 — Date, Flag and Version
- SCD Type3