With this course you can build ETL Tested Enterprise Data Warehouse functional logic that contains multi-dimensional data from various sources. The course also focuses on how to present the information as per different user requirements. A comprehensive course , it also covers the basics of Data Warehouse conceptual details and the QA testing methodologies followed in order to ensure error free data warehouse applications
COURSE CONTENT :
DATA WAREHOUSE CONCEPTUAL

• Data Warehouse : Essential Use
• Data Warehouse Architecture
• Data warehouse Life Cycle
• Fact and Dimension Table
• Data Warehouse Vs.OLTP
• Data Input through Acquisition Techniques
• Data revolution as per business logic
• Data mining
• Data Mart functioning in detail
• Design and build Database
• Schema Overview : Star, Snow Flake, Fact Constellation

ETL TESTING PERSPECTIVE SOFTWARE DEVELOPMENT LIFE CYCLE

• SDLC Overview, Models and Methodologies
• Databases and Types
• Explore Data document
• BQuick Check on Transformation Management
• Informatica Tool Overview

SLOWLY CHANGING DIMENSION MANAGEMENT

• SCD definition wise
• SCD with Type 1 to Type 6
• SCD Dealing Techniques

SQL IN ACCORDANCE WITH ETL TESTING

• SQL Basic Knowledge
• ETL Environment Architecture with Tool Set
• Build Functional Specifications of White Box and Black box Testing
• Work on Testing that Transform Data through invoked Rules
• Querying to extract Data and types of Querying

ETL TESTING FOR ERROR FREE DATA WARE HOUSE

• ETL Testing basic Conceptual Knowledge
• ETL Testing Quality to abide by and Standards to follow
• ETL Role Responsibilities in Real-time
• ETL Testing Methodologies : Black, Grey and White Box
• Design ETL Testing flow
• Work on creating ETL Test Plans
• Work on Writing ETL Test Cases
• Work on Reporting ETL Testing Bug Management
• Build Queries that identify Database bugs
• ETL Testing for Performance Optimization
• Best Practices