All for Joomla All for Webmasters

ETL Testing with Informatica and Datastage

ETL Testing with Informatica and Datastage

This course is expected to take one and half months with total 12 classes, each class is having three-four hours training. It can take lesser time if the number of hours per day is increased.

About the Course


32 Hours class room program  - 6 Weekends. 

Prerequisites: Manual Testers should go wtih this course

After the classes:

Attendees should have an exprience to work indivisually on ETL Testing and able to cover interview questions.

Who get this training?

  • Any graduate/post graduate or students in final stages of graduation and looking career in ETl Testing
  • Manual Testers


ETL Testing with Basic Informatica and DataStage

Module 1

• Informatica Installation.
• Basics of Dataware house training.
• Data Mart and Data Modeling.
• Star Schema and Snow Flake Schema.
• Types of Facts and Fact Tables.
• Types of Dimensions.

Module 2

• Basics of Unix Commands.
• Basic Unix Shell scripting.

Module 3

• Basics of SQL .
• Basic of open source database.
• Basic Concepts In Sql (Select, Update, Insert and Delete)
• What are the similarities between ETL tools and SQL
• Why to use ETL Tools and SQL together?

Module 4

• Introduction to ETL and DW Concepts:
• What is Data Warehousing?
• Differences between OLTP and Data Warehousing
• Why we need two separate solution for real time and warehousing
• Data Acquisition
How to extract data from several sources and load into same target table
How to perform transformation logics on data
How to load data into final target table
• Data Marts
• Need and usage of data marts and types of data marts
• • Dependent DM
• • Independent DM

 Module 5

• Types of Tables:
• Fact Table
• Dimension table
• Schemas:
• Star Schema
• Snowflake Schema
• Fact Constellation Schema
• SCD ( Slowly Changing Dimensions )
• Different types of SCD’s which developer develops and a tester has to test as per different types of data needs of clients

Module 6

• Practical exercises on SCD
• Types:
• ETL Tool Implementation and Testing Concepts:
• How to design frequently used testing queries to validate the data in source and target for both of the reasons Data Quality and Correctness to ensure that expected data came into the final and mediator target tables or not.
• Overview Of Etl Tool Architecture
• How ETL tool works and what is the basic need of ETL tools in the market,

Module 7

• How ETL Tools work at back end
• Different ETL Tools in the market
• What types of tasks tester performs on ETL for testing purpose
• Informatica PowerCenter (Leading tool in the market)
• Coding and testing process in different transformation rules:
• SAMPLE Loading from source to target
• SORTER Transformation
• FILTER Transformation
• EXPRESSION Transformation
• JOINER Transformation
• UNION Transformation
• AGGREAGATOR Transformation
• SQL Transformation

Module 8

• Testing Techniques in ETL
• MINUS Query
• COUNT Query
• UNION Query
• JOIN Query
• Informatica PowerCenter

Module 9

• How developers work on PowerCenter
• Different components of PowerCenter
• Tasks developed in different components
• Data Stage

Module 10

• What is Data Stage
• Differences between Informatica PowerCenter and DataStage
• Components of DataStage
• Differences between ETL development process in Informatica and DataStage