ETL TESTING


                                                  ETL testingETL TESTING TRAINING

MODULE 1: BASIC KNOWLEDGE ON DWH AND ETL TESTING.

  1. What is DWH?
  2. DWH Architecture
  3. What is ETL Testing?
  4. How ETL is different from other Testing?
  5. What needed for ETL Testing?

MODULE 2:MANUAL TESTING CONCEPTS

  1. STLC
  2. Unit Testing, Functional Testing, Integration Testing, System Testing, Re Testing, Regression Testing
  3. Test Strategy, Test Plan, Test Scenario and Test Case
  4. Defect Life Cycle

MODULE 3: DATABASE CONCEPTS

  1. i) Different types of language’s in SQL  ii)  Data Definition Language (DDL)
    1. INTEGRITY CONSTRAINTS
      1. UNIQUE KEY
      2. NOT NULL
      3. CHECK
      4. PRIMARY KEY
      5. FOREIGN KEY
      6. COMPOSITE PRIMARY KEY
      7. COMPOSITE UNIQUE KEY
        1. CREATE
        2. ALTER
          1. ADD
          2. MODIFY
          3. DROP
          4. RENAME
        • TRUNCATE
        1. DROP
        1. Data Manipulation Language (DML)
          1. INSERT
          2. UPDATE
        • DELETE
        1. Transaction Control Language (TCL)
          1. COMMITT
          2. ROLLBACK
        • SAVE POINT
        1. Data Control Language (DCL)
          1. GRANT
          2. REVOKE
        2. Data Query Language (DQL) or Data Retrieval Language (DRL)

         

    1. WHERE, GROUP BY, HAVING and ORDER BY clauses and GROUP functions.
    2. Analytical Functions
    3. DECODE and CASE conditional statements
    4. Sub Queries and CO-Related Sub queries
    5. JOINS
      1. INNER JOINOR EQUI JOIN
      2. OUTER JOIN
        1. LEFT OUTER
        2. RIGHT OUTER
        3. FULL OUTER

    SETT OPERATORS

  1. UNION
  2. UNION ALL
  3. INTERSECT
  4. MINUS
  5. Normalization and De-normalization
  6. VIEWS

MODULE 4:Data warehousing Concepts

  1. What is Data warehouse? Why DWH? DWH characteristics
  2. Why Data warehouse and why not database?
  3. DWH Architecture
  4. DWH approaches
    1. TOP DOWN
    2. BUTTOM UP
  5. What is Data Mart?
    1. Independent DataMart
    2. Dependent DataMart
  6. Data Mart Vs DWH
  7. Dimension, Fact, Dimension Table, Fact Table
  8. What is Surrogate Key?
  9. Types of Fact tables
    1. Additive
    2. Semi additive
    3. Non Additive (Fact Less fact table)
  10. DWH schemas
    1. STAR schema
    2. SNOWFLAKE schema
  11. Slowly Changing Dimensions (SCD), and types of SCD’s
    1. SCD 1
    2. SCD 2
    3. SCD 3
  12. OLTP Vs OLAP
  13. What is Business Intelligence?

MODULE 5: ETL Concepts

  1. What is ETL?
  2. What is Data Acquisition, whatData Acquisition contains?
    1. Data Extraction
    2. Data Transformation
      1. Data Merging
      2. Data Cleansing
      3. Data Scrubbing
      4. Data Aggregation
      5. Data Loading
  1. Source System, Staging Area, Target System
  2. Types Data Loads
    1. Initial Load
    2. Incremental Load
    3. Full Load

MODULE 6:ETL Testing

  1. ETL Tester Roles & Responsibilities
  2. Types of Documents
  3. How to deriving Test scenario’s from Functional Specification (FS)
  4. How to derive test cases from FS and TS
  5. How to Prepare the source queries from Mapping document
  6. What we validate in ETL Testing and how we validate, various validation techniques?
  7. Reporting Bugs

MODULE 7: Test Management Tool

  1. Uploading Requirements
  2. Uploading/Preparing Test Cases and Mapping Test Cases to Requirements
  3. Test Case Execution
  4. Defect Reporting, Mapping Defect to Test Cases
  5. Test Summary Reports

MODULE 8: -ETL Tool(MSBI, SSIS)

  1. What is MSBI

SSIS, SSRS, SSAS

Different types of sources

Different types of destinations

Control flow

Data flow transformations

Working with flat files

Working with excel files

Working with OLEDB

Others :

  1. ETL testing activities
  2. Resume preparation Tips
  3. Interview Tips & Mock Interviews