ETL
DW/BI/ETL Testing Training Course is designed for both entry-level and advanced Programmers. The course includes topics related to the foundation of Data Warehouse with the concepts, Dimensional Modeling and important aspects of Dimensions, Facts and Slowly Changing Dimensions along with the DW/BI/ETL set up, Database Testing Vs Data Warehouse Testing, Data Warehouse Workflow and Case Study, Data Checks using SQL, Scope of BI testing and as a bonus you will also get the steps to set up the environment with the most popular ETL tool Informatica to perform all the activities on your personal computer to get first hand practical knowledge.
Requirements:
- Basic RDBMS Concepts
- ETL Fundamentals
- Data Warehouse Concepts
Who this course is for:
- BI/ETL Developers
- Testers who want to get job on ETL Testing, to get more salary and also who want to get job quickly.
- IT professionals with very basic knowledge on Database concepts
- Project Managers, Database Professionals, Mainframe Professionals, SQL Developers
- Introduction to ETL Development & Industry Standards
- ETL Tool Implementation & Testing Concepts
- Mapping Design
- Active Transformations
- Passive Transformation
- Testing Techniques in ETL
- SCDs (Slowly Changing Dimensions)
- SCD1 Implementation and Testing
- SCD2 Implementation and Testing
- Data Marts,Tables & Schemas
- Common ETL Development Scenarios
- Analytic Functions
- UNIX Commands Used in Informatica
- Informatica Powercenter