Institute Address :

B1, 3rd Floor, Eureka Court,
Near Image Hospital, Ameerpet,
Hyderabad, India

Contact Details:

Phone No : 91+7207070872 / 9700446467
Email ID : onlinetrainingfromindia@gmail.com
onlinetraining@onlinetrainingfromindia.com

Online Training Enquiry Form

Security-Code reload security code

ETL Testing Online Training
Course Duration - 40hrs

DataWarehousing concepts:
  • DBMS and RDBMS
  • What is DataWareHousing 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
  • Intigration testing
  • Module testing
  • System testing
  • Uat
Practice sessions on ETL Testing
Online Training