ETL Testing Course

Get Certified In ETL Testing

Make Your Career In ETL Testing

ETL Testing Course in mumbai and navi mumbai

ETL Testing

  • Introduction to Oracle
  • Basic Concepts in SQL
  • Data Types
  • Select statement usage
  • Joins
  • Sub Queries
  • FAQs
  • Data Warehouse Concepts, Design
  • Need of Data Warehouse
  • Introduction to OLTP, ETL and OLAP Systems
  • Data Warehousing Architecture
  • Dimensional Modelling
  • Data Marts and ODS
  • Star Schema and Snowflake Schema
  • SCD (slowly changing dimension)
  • Types of Fact and Dimension Tables
  • FAQs
  • Diff B/w OLTP vs. ODS,OLAP vs. DSS
  • Dimension Modelling
  • Dimensions
  • Facts
  • Aggregates
  • DWH SCHEMA designing
  • STAR Schema, SNOWFLAKE Schema
  • Slowly Changing Dimensions
  • SCD TYPE1,TYPE2,TYPE3
  • Initial Load
  • Incremental Load
  • Full Load
  • CDC- change data capture
  • FAQ’S
  • Introduction of ETL-Extract,Transform,Load
  • ETL Tools and diff types of ETL Tools
  • ETL Architecture
  • ETL testing and need of ETL Testing
  • SDLC and Methods/Models
  • SDLC vs. STLC
  • 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?
  • Test plan Preparation
  • Test cases Preparation
  • Preparation of Test data
  • Process of ETL Testing

Quick Contact


NEWS!!!


Latest Testing Updates!!!

New Courses

Data Analytics
with R and Python
WeekEnd Timings: 9.30 A.M. To 1.30 P.M.

ISTQB Exam Center

BOOK YOUR SCHEDULE

Selenium WeekEnd Batches

Morning Batches : 9.30 A.M. to 1.30 P.M.
Evening Batches : 3.00 P.M. to 6.00 P.M.