BrainShare provides ETL Testing Online Training or In-class course by excellent experienced IT professionals who has more then 12+ Years of real time experience. Our trainers has good training experience so that best quality output will be delivered. All our faculty is dedicated so that we can complete your course as per the schedule given. We also allow you to record the classes from your end so that you can refer the classes once again when ever is required. we provide classes through online by using world class interactive system. We also give interview support & Technical support. We trouble shoot your problems while you are working. We address your questions during the Online SAP ETL Testing even after the course completion. After completion of your course we will help you to clear your interviews and also assist you to get certified on ETL Testing. We will give you 100% Satisfaction and We provide best quality real time online training.

Data Warehousing Concepts

•   Data warehousing Architecture (Concepts and Design).
•   Introduction to OLTP, ETL and OLAP Systems.
•   Dimensional Data Modeling
•   Data Marts and ODS
•   Fundamental roles of

• dimension and fact tables, 
• hierarchies and summary/Aggregated Tables.

•   Star Schema and Snowflake Schema
•   Introduction to OLAP Technologies (ROLAP, MOLAP, DOLAP and HOLAP)
•   Software development life cycle

ETL Testing

•   What is use of ETL testing?
•   Responsibilities of ETL Tester.
•   Testing methodologies and Type of Testing

•   White box Testing.
•   Black box Testing.
•   Regression Testing.
•   Integration Testing
•   Performance Testing
•   User Acceptance Testing
•   ETL Testing / Work Flow Process.

• Design the Test Plans / Test Cases
• Testing through Database Queries
• Defect Tracking and Report
• Performance Tuning.

Oracle SQL Concepts

•   Basic Concepts in SQL (DDL,DML and TCS Statements).
•   Writing SQL Queries with various functions
•   Working and various Joins.
•   Working on Sub Queries.
•   Performance Tuning Tips & Tricks and more …….

OLAP Tool

•   Concepts of OLAP Tools
•   Overview of ROLAP, MOLAP, DOLAP and HOLAP
•    Business Objects Reporting Tool

Case Studies