ETL Testing Course Content



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 Modeling
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 analyzing 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

Enquiry Form                         

CONTACT US

  1. 10521 Shadow Ridge Ln Apt 203,
  2. Louisville KY-40241
  3. Contact No : 606 909 4722
  4. Email : contact@coloursit.com

TESTIMONIALS

  I am Pleased to compliment your organization for your efficiency and professionalism.     
– Kranthi Ch
MD, Siri IT Solutions



  I am Pleased to compliment your organization for your efficiency and professionalism.     
– Sreedhar J
Manager, Siri IT Solutions

Copyright 2014 Colours IT Consulting | All Rights Reserved.