ETL Testing

ETL Testing

Businesses of today must work with data that has been extracted in various formats from various sources. This makes ETL testing even more crucial. It is necessary to verify the data extraction, transformation, and loading processes and to correct any irregularities that are discovered. Thus, the ETL and Data Warehouse domains have a requirement for testers. With the help of this online ETL testing course, you’ll be prepared to land a solid job at some of the top corporations on the planet.

marketing-product-manager-holding-marketing-promotion-plan.jpg

KEY FEATURES

100% Job Support
100% Practical Training
Live Project Experience

SEARCH ENGINE OPTIMIZATIONS CURRICULUM

  • Software Testing Life Cycle
  • Software Development Life Cycle
  • Manual Testing Experience is Plus
  • Usage of HP quality Center
  • Defect Life Cycle
  • What is Data Ware House?
  • Difference between OLTP and Data warehousing

 

 
  • Data Extraction
  • Transformation
  • Data loading
  • Star Schema
  • Snow Flake Schema
  • Type-1 SCD
  • Type-2 SCD
  • Type-3 SCD
  • SELECT
  • Single Row Functions
  • Aggregate Functions
  • JOINS
  • SUBQUERYS
  • SET Operators
  • Analytical Functions
  • DDL, DML, Views (High level Concepts)
  • Minus querying
  • Count Querying
  • Introduction
    • What is use of ETL TESTING?
    • Responsibilities of an ETL Tester
  • Testing methodologies
    • Smoke Testing
    • Functional Testing
    • System Testing
    • ETL Testing Work Flow Process
    • How to Prepare the ETL Test Plan
    • How to reporting the Bugs in ETL Testing?
    • ETL Testing Responsibilities
    • How to design the Test cases in ETL Testing.
    • How to detect the bugs through database queries
    • ETL Performing Testing & Performing Tuning
  • ETL Testing with Informatica PowerCenter
    • SAMPLE Loading from source to target
    • SORTER Transformation
    • FILTER Transformation
    • ROUTER Transformation
    • EXPRESSION Transformation
    • JOINER Transformation
    • UNION Transformation
    • AGGREAGATOR Transformation
    • RANK Transformation
    • STORED PROCEDURE Transformation
    • SEQUENCE GENERATOR Transformation
    • Flat File
    • Look up Transformation
    • Slowly Changing Dimension Type 1
    • SCD Type 2
    • SCD Type 3
    • Update Strategy
    • XML Source Qualifier
    • Types of load (Full, incremental, Refresh)
  • BI Testing with OBIEE
    • BI Test cases
    • Data validation with OBIEE
    • UI Testing with OBIEE
  • Different Tools
    • SQL Developer
    • Informatica PowerCenter Client Tools
    • OBIEE Reporting Tool
  •  
Scroll to top