Welcome To Eazygurus

ETL Testing

ETL Testing Online Training


    Course Name        :   ETL TESTING
    Duration                 :  25 hrs

    Course Contents:

    Section A: Data warehouse and ETL Concepts

    • Database Concepts and SQL
    • Queries:Joins, Simple, Complex and Co-related queries
    • What is Data warehouse
    • Characteristics of the Data warehouse
    • OLTP Vs OLAP
    • Dimension Table Vs Fact Table
    • Types of Source Files
    • Advantages of Dataware House
    • Meta Data
    • Dataware House Vs Data Mart
    • Data Extraction
    • Data Transformation(Different Transformation rules)
    • Data Loading
    • SCD (Type-1,Type-2 and Type-3)
    • Introduction of ETL Tool
    • Overview of ETL Tool Architecture
    • ETL Tool Environment
    • Approaches of DW or ETL
    • Database Designs(Star Schema, Snowflake Schema etc)

    Section B:  Data warehouse (ETL) Testing Process

    • Software development life cycle and Testing Life Cycle
    • Data Warehouse(ETL) Test or Work Flow Process
    • ETL Testing Work Flow Process
    • ETL Testing Introduction
    • What is use of testing?
    • What is quality & standards?
    • Responsibilities of a ETL Tester
    • Risks and Challenges of ETL Testing

    Section C: Data warehouse (ETL) Test Preparation

    • Understanding of Source files and Target
    • ELT Testing methodologies and Test Techinques
    • ETL Test approach
    • Types of Testing
    • ETL Testing Work Flow Process
    • How to Prepare ETL Test Plan
    • How to design Test cases in ETL Testing.
    • DW(ETL) Test Environment Setup

    Section D: Data warehouse (ETL) Test Execution and Results and Report

    • How to perform DW (ETL) Testing.
    • Testing the Requirements and Functional Design
    • Different phases in DW(ETL) Testing
    • Data validation in Source and Target
    • How to apply Transformation rules in ETL Test execution.
    • How to reporting the Bugs in ETL Testing
    • How to detect the bugs through database queries
    • ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
    • Automation for ETL Test Execution.
    • Tools: SQL and TOAD
    • How to Report DW(ETL) Test Execution Status: Daily Vs Weekly

     Key Benefits:

    • Exposure to real time scenarios.
    • Job oriented training program.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A
    • Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    • week, 6 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.