ETL and Report Testing Course

Data Warehousing concepts:

• DBMS and RDBMS

• What is Data Warehousing and necessity of it?

• Data warehousing architecture

• OLAP, ROLAP, MOLAP

• Data mining

• Meta data

• Tables, views

• Constraints

• Fact and Dimensional Tables

• Partitioning of tables

• Concepts of Referential Integrity

• Concepts of Modelling

• Database Schema

• Concepts of normalization

• Concepts of Slowly Changing Dimensions

• Concepts of Data Mart

• Full and Incremental extraction Process

• Change Data capture

SQL Concepts:

• DDL, DML commands

• All the basic functions (Character Functions, Conversion Functions,
  Advanced functions, Mathematical Functions and Date Functions)

• Joins

• Practice SQLs for some sample test scenarios

ETL testing:

• What is ETL and importance of ETL testing??

• Creating, running and analysing sessions/workflows in Informatica

• Preparation of Test strategy, Test plan and estimations

• Testing scenarios, creation of test cases and scripts

• Test case execution and defect tracking and reporting

Report Testing:

• Validation of the report data with DB and UI testing

• Preparation of Test data

Levels of testing

• Unit testing

• Integration testing

• Module testing

• System testing

• Uat

Practice sessions on ETL Testing