CorptechIT provides Online Training by experienced IT professionals. Our faculties dedicated to complete your course as per the schedule given. We record the classes from your end to refer the classes once again whenever is required. ETL Testing Online Training being a really important module, we have taken precise steps in teaching a full-fledged ETL Testing Online Training course curriculum that covers all the concepts. Our customer support team and trainers will solve all your queries as and when required. ETL Testing Online Training has got the right training that can fulfill a candidate’s training expectations. We see to that the value and quality of our ETL Testing Online Training will not be compromised at all. We will market your resume in USA, UK, SINGAPORE, NEWZELAND, CANADA, AUSTRALIA, JAPAN, SWEDEN, SOUTH AFRICA. We clarify your questions during the training even after the course completion. After completion of training we will help you to assist you to get certified on ETL Testing . We will give you 100% Satisfaction.
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