ETL Testing Online Training Course Content: 1. Data Ware Housing Concepts: - What is Data Ware Housing
- Difference between OLTP and Data Ware Housing.
2.Data Acquistion: - Data Extraction
- Data Transormation
- Data Loading
3. Data Marts: Dependent Data Mart 4. Data Base Design: - Star Schema
- Snow Flake Schema
- Fact constellation Schema
- Advanced calculations explanation
5. SCD(slowly changing dimension): - Type-1 SCD
- Type-2SCD
- Type-3 SCD.
6 Basic Concepts in SQL: - Overview of ETL Tool Architetecture
- White Box and Black BOX Testing Functionality on Different Transformation Rules
7. Data Ware House Life Cycle Different Types of Testing Techniques in ETL: - Minus Queuing
- Count Queuing
8. ETL Testing Concepts and Introduction: - Minus Queuing :What is use of testing
- What is quality & standard Responsibilities of a ETL Tester
| 9. Software development life cycle - Waterfall model
- Agile model & methodology
- Prototype model
- XSpiral model
10.Testing methodologies: - White box testing
- Black box testing
- Grey box 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 in Data Stage, Informatica, Abinitio etc;
- How to detect the bugs through database queries
- ETL Performing Testing & Performing Tuning
11. Projects Projects on Different Domains(Banking , Health Care, Telecom , Insurance): · Projects on Different Domains(Banking , Health Care, Telecom , Insurance) | 