ETL Testing Online training

ETL Testing Training involves Extract, Transform & Load process in Data Warehousing. ETL refers to, “Extraction of data from different applications” developed & supported by different vendors, managed & operated by different persons hosted on different technologies “into Staging tables-Transform data from staging tables by applying a series of rules or functions – which may include Joining and Deduplication of data, filter and sort the data using specific attributes, Transposing data, make business calculations etc – to derive the data for loading into the destination system-Loading the data into the destination system, usually the data warehouse, which could further be used for business intelligence & reporting purposes.

• ETL Testing Training by Realtime Expert trainer
• ETL Testing Live Online Classes
• Free study material

• knowledge of Quality Assurance testing processes, the software development lifecycle,
• Windows operating systems, and Microsoft Office products
• Basic knowledge of Software testing and Sql

We guarantee learning at your convenience & pace.

• Instant Access:
  Get instant access to self-paced training after signup.
• Streaming video recording:
  Watch lessons any time at your schedule, free recording.
• Exercises:
  Practical exercises help you test what you are learning as you go.
• Free Demo:
  Sign up for free demo to check whether the course is right for you and interact with the faculty live.
• Experienced Trainers:
  We only hire the industry’s best trainers
• Live free interactive web sessions:
  Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course.
• Structured Curriculum Schedule:
  Progress with your complete daily interactive lessons and assignments.
• Faculty Mentoring:
  Turn in daily and weekly homework for personalized feedback from faculty.
• Virtual Office Hours:
  Live interaction with the faculty and other students around the world.
• Hands on Live Projects:
  Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.

ETL Testing Course Content

DWH: Data WareHousing 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
• hat is the 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, Waterfall model)

Challenges in DWH ETL Testing compare to other testing

• Incompatible and duplicate data.
• oss 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 Workflow activities involved

• Analyze and interpret business requirements/ workflows to Create
• estimations/li>
• 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 coordinate with the 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
• Joi
• Stored Procedure

Slowly Changing Dimension

• SCD Type1
• SCD Type2
• Date, Flag and Version
• SCD Type3

Workflow Manager

• Creating Reusable tasks
• Workflows, Worklets & Sessions
• Tasks
• Session
• Decision task
• Control Task
• Event wait task

Timer task

• Monitoring workflows and debugging errors
• Indirect Loading
• Constraint based load ordering
• Target Load plan
• Worklet
• 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.