ETL TESTING ONLINE TRAINING

ETL testing is one of the much in demand testing skills.Testing Data Integration projects is challenging due to high volumes and heterogeneous nature of data sources. It is a common practice for testing teams to copy records from source and target tables into an excel spreadsheet and manually compare the data for just a handful of records.

ETL Testing Online Training Course Content
  • Oracle Basics & Concepts
    • DBMS
    • RDBMS
    • DBMS vs RDBMS
    • Why Database Required
    • Different types of databases and difference
    • ASCII vs UNICODE
    • PL/SQL Basics
    • Oracle Architecture
    • Diff B/W Database & Files
    • OLTP
    • OLAP, ROLAP, MOLAP
    • METADATA
    • DDL,DML,DCL
    • Basic admin activities
    • Data types
    • Tables
    • SQL ,SUB QUERIES,CORELATED SUB QUERY
    • INNER QUERY,OUTER QUERY
    • Functions and types and importance
    • Joins and different types
    • Views n materialized views
    • Index
    • Constraints
    • Referential integrity
    • Partitioning
    • Performance tuning
    • Different types of techniques
    • DATABASE SCHEMA
  • DWH Concepts
    • What is DWH ?Why we require that?
    • DWH Architecture
    • DATA MART and TYPES
    • DM vs DWH
    • Data cleaning
    • Data scrubing
    • Data masking
    • Normalization
    • ODS
    • STG AREA
    • DSS
  • ETL Testing Course Contents
    • Diff B/w OLTP vs ODS,OLAP vs DSS
    • DIMENTION MODELING
    • DIMENSIONS
    • FACTS
    • AGGREGATES
    • DWH SCHEMA designing
    • STAR SCHEMA,SNOWFLAKE SCHEMA,GALAXY SCHEMA,FCS
    • SLOWLY CHANGING DIMENSIONS
    • SCD TYPE1,TYPE2,TYPE3
    • INITIAL LOAD
    • INCREMENTAL LOAD
    • FULL LOAD
    • CDC- change data capture
    • FAQ'S
  • Testing Concepts
    • Whitebox Testing
    • Blackbox Testing
    • Gray Box Testing
    • Regression Testing
    • Smoke Testing vs Sanity Testing
    • User Testing
    • Unit testing
    • Intigration testing
    • Module testing
    • System testing
    • UAT
  • ETL Testing Concepts
    • Introduction of ETL-Extract,Transform,Load
    • ETL TOOLS and Diff Types of ETL Tools
    • ETL architechture
    • ETL testing and why we require
    • Different ETL tools architechtures
    • SDLC and Methods/Models
    • STLC and Methods/Models
    • SDLC vs STLC
    • Reverse Engineering
    • QC(Quality Center and BugZilla)
    • Roles and Responsibilities
    • Minus,Duplicate,Count,Intersection,etc…
    • Detect Defects
    • Defects Logging and Reporting
    • How to prepare Queries very quickly with the help of mapping
    • Performance Tuning and Performance Testing,Report Testing,UI Testing
    • Quality and different standards that tester should follow,Why?
    • Testplan Preparation
    • Testcases Preparation
    • Preparation of Test data
    • Process Of ETL Testing
  • ETL Tool and Testing
    • Data Extract
    • Data Transform
    • Data Load
    • Import Source
    • Import Target
    • Mappings,Maplets
    • Workflows,Worklets
    • Transformations,Functionalities,Rules and Techniques
    • Import and Export
    • Coping and Rules
    • Queries Preparation based on Transformations
    • Importance of ETL Testing
    • Creating of Mappings,Sessions,Workflows
    • Running of Mappings,Sessions,Workflows
    • Analyzing of Mappings,Sessions,Workflows
    • Tasks and Types

Please Register with us