US +1 9162441384 | UK +44 7545863371 | IN +91 9160021120

ETL Testing

Freelance Project/Job During the course/We provide Full Framework Code./Free Post Training Support/Free Placement Assistance.

ETL Testing Course Outline:

Module1: Data Warehousing Concepts
Module2: SCHEMA
Module3: Types of tables in data warehouse
Module4: SCD(Slowly changing dimension)
Module5: Database concepts and SQL (Structural query language)
Module6: Software development life cycle and testing life cycle
Module7: ETL Testing tasks
Module8: ETL Testing validations
Module9: Unix
Module10: ETL Process
Module11: Dataware Housing Life Cycle and ETL TestingApproach
Module12: Overview of ETL Tool
Module13: Data warehouse test execution
Module14: How to crack Testing Interview
Next Batch Starts in

Register For The Free Demo Or Training


Pay Online (Credit Card / Debit Card / Net-Banking)

Or pay by Paypal

Module1:

Data Warehousing Concepts

  • Dataware house architecture
  • Datamart
Read More Read Less
Module2:

SCHEMA

  • Star Schema
  • Snow Flake Schema
Read More Read Less
Module3:

Types of tables in data warehouse

  • Dimension table
  • Fact table
Read More Read Less
Module4:

SCD(Slowly changing dimension)

  • SCD TYPE1
  • SCD TYPE2
  • SCD TYPE3
Read More Read Less
Module5:

Database concepts and SQL (Structural query language)

  • DDL (Data definition language)
  • DML (Data manipulation language)
  • DQL (Data query language)
Read More Read Less
Module6:

Software development life cycle and testing life cycle

  • Agile Methodologies
  • Waterfall Model
Read More Read Less
Module7:

ETL Testing tasks

  • Spec analysis
  • Designing Test cases
  • Environment Preparation
  • Test Execution
Read More Read Less
Module8:

ETL Testing validations

  • Structure validation
  • COUNT Validation
  • TRANSFERMATION Logic Check
  • MINUS Query
  • Duplicate Check
  • Error logic Check
  • RI Validation(Referential integrity constraint check)
 
Read More Read Less
Module9:

Unix

  • Overview of UNIX and its role in ETL Process
  • Basic UNIX commands used in ETL Testing
Read More Read Less
Module10:

ETL Process

  • Data Extraction
  • Data transformation
  • Data loading process
Read More Read Less
Module11:

Dataware Housing Life Cycle and ETL TestingApproach

  • ETL Testing methodologies and test techniques
  • ETL Testing approach
  • Types of ETL Testing
  • Designing ETL Test cases
  • DW(ETL) Test environment preparation
Read More Read Less
Module12:

Overview of ETL Tool

  • Overview of UNIX and its role in ETL Process
  • Basic UNIX commands used in ETL Testing
Read More Read Less
Module13:

Data warehouse test execution

  • ETL Test execution (ETL Job execution)
  • Testing the requirements and functional design
  • How to apply transformation rules in ETL test execution
  • Data validation from source to target
  • Detect the bugs in ETL validations
  • Reporting the bugs
Read More Read Less
Module14:

How to crack Testing Interview

  • Resume preparation
  • Mock Interview
Read More Read Less