We offering ETL Testing Online Training USA quite a lot of features. Our faculty has Real Time experience in IT industry. We offer Best ETL Testing Online Training at your comfortable timings from your home with flexible schedules. Student can select regular fast track and weekend ETL Testing Classes. Each trainer regularly assessed to candidates given the best quality of ETL Testing in Online Training. Demos are conducted by every day and you can choose flexible timings according to your requirement.
We provide free demo on ETL Testing Online Training Classes and course materials an in-depth knowledge of ETL Testing which focuses on real time scenarios. Recorded sessions are provided after each class. We arrange regular and weekend ETL Testing Training for employees and students. Resume build as per corporate standards according to the job description and we will market your resume for top companies. We provide ETL Testing Online Training and project support across the World like USA, UK, South Africa, Malaysia, Singapore, Australia and Japan.
ETL Testing Online Training Course Content
Prerequisites
- Software Testing Life Cycle
- Software Development Life Cycle
- Manual Testing Experience is Plus
- Usage of HP quality Center
- Defect Life Cycle
Data warehousing Concepts
- What is Data Ware House?
- Difference between OLTP and Data warehousing
Data Acquisition
- Data Extraction
- Data Transformation
- Data loading
DataBase Design
- Star Schema
- Snow Flake Schema
SCD (slowly changing dimension)
- Type-1 SCD
- Type-2 SCD
- Type-3 SCD
Basic Concepts in SQL in Oracle
- SELECT
- Single Row Functions
- Aggregate Functions
- JOINS
- SUBQUERYS
- SET Operators
- Analytical Functions
- DDL, DML, Views (High level Concepts)
Different Types of Testing Techniques in ETL
- Minus querying
- Count Querying
ETL Testing Concepts
Introduction
- What is use of ETL TESTING?
- Responsibilities of an ETL Tester
Testing methodologies
- Smoke Testing
- Functional Testing
- System Testing
- ETL Testing Work Flow Process
- How to Prepare the ETL Test Plan
- How to design the Test cases in ETL Testing.
- How to reporting the Bugs in ETL Testing?
- ETL Testing Responsibilities
- How to detect the bugs through database queries
- ETL Performing Testing & Performing Tuning
Documentation for ETL Testing Projects
ETL Testing with Informatica PowerCenter
- SAMPLE Loading from source to target
- SORTER Transformation
- FILTER Transformation
- ROUTER Transformation
- EXPRESSION Transformation
- JOINER Transformation
- UNION Transformation
- AGGREAGATOR Transformation
- RANK Transformation
- STORED PROCEDURE Transformation
- SEQUENCE GENERATOR Transformation
- Flat File
- Look up Transformation
- SCD type 1
- SCD Type 2
- SCD Type 3
- Update Strategy
- XML Source Qualifier
- Types of load (Full, incremental, Refresh)
BI Testing with OBIEE
- BI Test cases
- Data validation with OBIEE
- UI Testing with OBIEE
Different Tools
- SQL Developer
- Informatica PowerCenter Client Tools
- OBIEE Reporting Tool