ETL Testing Course

by Vibrant Technologies & Computers

Module

Title

Contents

Module 1:

Data Warehousing Concepts:

Data Warehouse Concepts, Design. Need of Data Warehouse. Introduction to OLTP, ETL and OLAP Systems. Data Warehousing Architecture. Dimensional Modeling. Data Marts and ODS. Star Schema and Snowflake Schema. SCD (slowly changing dimension). Types of Fact and Dimension Tables. FAQ's.n

Module 2:

Oracle Concepts:

Introduction to Oracle. Basic Concepts in SQL. Data Types. Select statement usage. Joins. Sub Queries. Performance Tuning Tips & Tricks. FAQ's.

Module 3:

ETL Testing - Introduction:

Introduction to ETL. ETL Architecture. What is use of testing. What is quality & standards. Responsibilities of a ETL Tester. Datastage Architecture.

Module 4:

Software development life cycle:

Waterfall model V-model Agile model & methodology

Module 5:

Testing methodologies:

Whiteboxtesting. Blackboxtesting. RegressionTesting. ETLTestingWorkFlowProcess. HowtoPreparetheETLTestPlan. HowtodesigntheTestcasesinETLTesting. HowtoreportingtheBugsinETLTesting. ETLTestingResponsibilities. Howtodetectthebugsthroughdatabasequeries. ETLPerformingTesting&PerformingTuning

Module 6:

Other Advantages:

Real-time Scenarios. Deployment Process. Project Experience. Resume Preparation. Mock Interviews. FAQ's. Job Assistance.