ETL Testing

Call Us: +91 95000 19355

etl testing

ETL testing is one of the most-required testing skills at present. ETL testing is also called as warehouse testing and it is used for many kinds of applications development choices. This course is accessible with customized syllabus patterns and will be trained by the professional trainers.

Oracle Basics & Concepts

  1. DBMS
  2. RDBMS
  3. DBMS vs RDBMS
  4. Why Database Required
  5. Different types of databases and difference
  6. ASCII vs UNICODE
  7. PL/SQL Basics
  8. Oracle Architecture
  9. Diff B/W Database & Files
  10. OLTP
  11. OLAP, ROLAP, MOLAP
  12. METADATA
  13. DDL,DML,DCL
  14. BASIC ADMIN ACTIVITIES
  15. DATATYPES
  16. TABLES
  17. SQL ,SUB QUERIES,CORELATED SUB QUERY
  18. INNER QUERY,OUTER QUERY
  19. FUNCTIONS AND TYPES AND IMPORTANCE
  20. JOINS AND DIFFERENT TYPES
  21. VIEWS n MATERIALIZED VIEWS
  22. INDEX
  23. CONSTRAINTS
  24. REFERENTIAL INTEGRITY
  25. PARTITIONING
  26. PERFORMANCE TUNING
  27. DIFFERENT TYPES OF TECHNIQES
  28. DATABASE SCHEMA

DWH Concepts

  1. WHAT IS DWH ?WHY WE REQUIRE THAT ?
  2. DWH ARCHITECTURE
  3. DATA MART and TYPES
  4. DM vs DWH
  5. DATA CLEANZING
  6. DATA SCRUBING
  7. DATA MASKING
  8. NORMALIZATION
  9. ODS
  10. STG AREA
  11. DSS

ETL Testing Course Contents

  1. Diff B/w OLTP vs ODS,OLAP vs DSS
  2. DIMENTION MODELING
  3. DIMENSIONS
  4. FACTS
  5. AGGREGATES
  6. DWH SCHEMA designing
  7. STAR SCHEMA,SNOWFLAKE SCHEMA,GALAXY SCHEMA,FCS
  8. SLOWLY CHANGING DIMENSIONS
  9. SCD TYPE1,TYPE2,TYPE3
  10. INITIAL LOAD
  11. INCREMENTAL LOAD
  12. FULL LOAD
  13. CDC- change data capture
  14. FAQ’S

ETL Testing Concepts

  1. Introduction of ETL-Extract,Transform,Load
  2. ETL TOOLS and Diff Types of ETL Tools
  3. ETL ARCHITECTURE
  4. ETL TESTING AND WHY WE REQUIRE
  5. DIFFERENT ETL TOOLS ARCHITECTURES
  6. SDLC and Methods/Models
  7. STLC and Methods/Models
  8. SDLC vs STLC
  9. Reverse Engineering
  10. QC(Quality Center and BugZilla)
  11. Roles and Responsibilities
  12. Minus,Duplicate,Count,Intersection,etc…
  13. Detect Defects
  14. Defects Logging and Reporting
  15. How to prepare Queries very quickly with the help of mapping
  16. Performance Tuning and Performance Testing,Report Testing,UI Testing
  17. Quality and different standards that tester should follow,Why?
  18. Testplan Preparation
  19. Testcases Preparation
  20. Preparation of Test data
  21. Process Of ETL Testing

Testing Concepts

  1. Whitebox Testing
  2. Blackbox Testing
  3. Gray Box Testing
  4. Regression Testing
  5. Smoke Testing vs Sanity Testing
  6. User Testing
  7. Unit testing
  8. Intigration testing
  9. Module testing
  10. System testing
  11. UAT

ETL Tool and Testing

 

  1. Data Extract
  2. Data Transform
  3. Data Load
  4. Import Source
  5. Import Target
  6. Mappings,Maplets
  7. Workflows,Worklets
  8. Transformations,Functionalities,Rules and Techniques
  9. Import and Export
  10. Coping and Rules
  11. Queries Preparation based on Transformations
  12. Importance of ETL Testing
  13. Creating of Mappings,Sessions,Workflows
  14. Running of Mappings,Sessions,Workflows
  15. Analyzing of Mappings,Sessions,Workflows
  16. Tasks and Types

Practice:

Testing scenarios, creation of test cases and scripts

Test case execution and defect tracking and reporting

Preparation of Test data

Practice ETL Testing with Real Time Scenarios and FAQ’s

Other Courses

Back to Top