ETL Testing Training

ETL Testing Training in Bangalore

DSMINFOTECH is a software training institute located in Bangalore that offers training in ETL (Extract, Transform, Load) testing. The training covers the basics of ETL testing, as well as advanced topics, to help students become proficient in testing data integration and migration processes.

Some of the topics covered in the ETL testing course at DSMINFOTECH include:

  1. Introduction to ETL testing
  2. Understanding the data warehousing concepts
  3. Testing the extraction, transformation, and loading of data
  4. Data validation and verification techniques
  5. Working with various ETL tools
  6. Debugging and error handling in ETL processes
  7. Best practices for ETL testing

DSMINFOTECH has experienced trainers who use a combination of lectures, hands-on labs, and real-world case studies to help students understand the concepts and apply them in practical scenarios. The course duration, fees, and other details may vary, so it is best to check with DSMINFOTECH directly for the latest information.

Get In Touch

ETL Testing Course Syllabus

 
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
  • DATATYPES
  • 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 TECHNIQES
  • DATABASE SCHEMA
DWH Concepts
  • WHAT IS DWH ?WHY WE REQUIRE THAT ?
  • DWH ARCHITECTURE
  • DATA MART and TYPES
  • DM vs DWH
  • DATA CLEANZING
  • DATA SCRUBING
  • DATA MASKING
  • NORMALIZATION
  • ODS
  • STG AREA
  • DSS
  • 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
ETL Testing Concepts
  • Introduction of ETL-Extract, Transform, Load
  • ETL TOOLS and Diff Types of ETL Tools
  • ETL ARCHITECTURE
  • ETL TESTING AND WHY WE REQUIRE
  • DIFFERENT ETL TOOLS ARCHITECTURES
  • 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
  • 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
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 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
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

    To Get Complete Course Information