ETL Testing Online Training in Ameerpet

ETL Testing Online Training in Ameerpet


Srihitha Technologies providesĀ ETL Testing Online Training in Ameerpet by real time Experts. For more information aboutĀ ETL Testing online training in Ameerpet call 9885144200 / 9394799566.

There are several software tools that can be used to support the process, but sometimes specific software programs need to be coded to achieve the objective. In such case ETL (Extract, Transform and Load) is a process in data warehousing responsible for pulling data out of the source systems and placing it into a data warehouse. ETL is a set of computer programs or processes that capture the appropriate data from the routine or operational systems, clean it up, and store it a standard and consistent format.

DataWarehousing concepts:

  • DBMS and RDBMS
  • What is DataWareHousing and necessity of it?
  • Data warehousing architecture
  • 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