ETL TESTING

ETL Testing Training in Mumbai
Learn at Home with Wings Academy

Classroom and Online Courses by Certified Experts

Our Classroom and Online Training Program insist you to become a specialist at Advanced Industrial Technologies in a Month. Hands-on Learning with Live Project sessions. We are "One of the Best Classroom and Online Training Course Provider" in India with Placement Support.

About ETL Testing Training Course in Mumbai
ETL Testing training in Wings Academy, Mumbai provides an in-depth and comprehensive understanding of Data warehousing and business intelligence concepts through real-world
examples to use the ETL Tester, efficiently. Start learning with us Wings Academy ETL Testing Classroom & Online Training Course.

ETL testing is done before data is moved to production data warehouse systems.... ETL testing is to ensure that the data which has been loaded from a source to destination after transformation is accurate. It involves the verification of data at various stages, which is used between source and destination.

Syllabus of ETL Testing Course in Mumbai
DWH Data Ware Housing Concepts

  •  What is Data Warehouse?
  •  Need of Data Warehouse
  •  Introduction to OLTP, ETL and OLAP Systems
  •  Difference between OLTP and OLAP
  •  Data Warehouse Architecture
  •  Data Marts
  •  ODS [Operational Data Store]
  •  Dimensional Modelling
  •  Difference between relation and dimensional modelling
  •  Star Schema and Snowflake Schema
  •  What is fact table
  •  What is Dimension table
  •  Normalization and De-Normalization

ETL Testing

  •  ETL architecture.
  •  What is ETL and importance of ETL testing
  •  How DWH ETL Testing is different from the Application Testing
  •  SDLC/STLC in the ETL Projects (ex: V Model, Water fall model)

Challenges in DWH ETL Testing compare to other testing

  •  Incompatible and duplicate data
  •  Loss of data during ETL process
  •  Testers have no privileges to execute ETL jobs by their own
  •  Volume and complexity of data is very huge
  •  Fault in business process and procedures
  •  Trouble acquiring and building test data

ETL Testing Work flow activities involved

  •  Analyze and interpret business requirements/ workflows to Create estimations
  •  Approve requirements and prepare the Test plan for the system testing
  •  Prepare the test cases with the help of design documents provided by the
  •  developer team
  •  Execute system testing and integration testing
  •  Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)
  •  How to detect the bugs in the ETL testing
  •  How to report the bugs in the ETL testing
  •  How to co-ordinate with developer team for resolving the defects

Types of ETL Testing

  •  Data completeness
  •  Data transformation
  •  Data quality
  •  Performance and scalability
  •  Integration testing
  •  User-acceptance testing
  •  SQL Queries for ETL Testing
  •  Incremental load testing
  •  Initial Load / Full load testing

 Different ETL tools available in the market

  •  Informatica
  •  Ab Initio
  •  IBM Data stage

Power Center Components

  •  Designer
  •  Repository Manager
  •  Workflow Manager
  •  Workflow Monitor
  •  Power Center Admin Console

 Informatica Concepts and Overview

  •  Informatica Architecture

Sources

  •  Working with relational Sources
  •  Working with Flat Files

Targets

  •  Working with Relational Targets
  •  Working with Flat file Targets

Transformations – Active and Passive Transformations

  •  Expression
  •  Lookup –Different types of lookup Caches
  •  Sequence Generator
  •  Filter
  •  Joiner
  •  Sorter
  •  Rank
  •  Router
  •  Aggregator
  •  Source Qualifer
  •  Update Strategy
  •  Normalizer
  •  Union
  •  Stored Procedure
  •  Slowly Changing Dimension
  •  SCD Type1
  •  SCD Type2 — Date, Flag and Version
  •  SCD Type3

Workflow Manger

  •  Creating Reusable tasks
  •  Workflows, Worklets & Sessions
  •  Tasks
  •  Indirect Loading
  •  Constraint based load ordering
  •  Target Load plan
  •  Worklet ,Mapplet ,Resuable transformation
  •  Migration ?ML migration and Folder Copy
  •  Scheduling Workflow
  •  Parameter and variables
  •  XML Source, Target and Transformations

 Performance Tuning

  •  Pipeline Partition
  •  Dynamic Partition
  •  Pushdown optimization
  •  Preparation of Test Cases
  •  Executing Test case
  •  Preparing Sample data
  •  Data validation in Source and target
  •  Load and performance testing
  •  Unit testing Procedures
  •  Error handling procedures

About Experienced ETL Trainer

  •  Our ETL Training in Mumbai. Trainers are certified professionals with 7+ years of experience in their respective domain as well as they are currently working with Top MNCs.
  •  As all Trainers are ETL domain working professionals so they are having many live projects, trainers will use these projects during training sessions.
  •  All our Trainers are working with companies such as Cognizant, Dell, Infosys, IBM, L&T InfoTech, TCS, HCL Technologies, etc.
  •  Trainers are also help candidates to get placed in their respective company by Employee Referral / Internal Hiring process.
  •  Our trainers are industry-experts and subject specialists who have mastered on running applications providing Best ETL training to the students.
  •  We have received various prestigious awards for ETL Training in Mumbai from recognized IT organizations.