Follow Us:

ETL Testing Training in Chennai


Course Duration

40 Hours Sign in with Facebook Sign in with Facebook

Course Contents

ETL Testing
    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.
  • Oracle Concepts:
  • Introduction to Oracle.
  • Basic Concepts in SQL.
  • Data Types.
  • Select statement usage.
  • Joins.
  • Sub Queries.
  • Performance Tuning Tips & Tricks.
  • FAQ’s.
  • ETL Testing - Introduction:
  • Introduction to ETL.
  • ETL Architecture.
  • What is use of testing.
  • What is quality & standards.
  • Responsibilities of a ETL Tester.
  • Datastage Architecture.
  • Software development life cycle:
  • Waterfall model
  • V-model
  • Agile model & methodology
  • Testing methodologies:
  • Whiteboxtesting.
  • Blackboxtesting.
  • RegressionTesting.
  • ETLTestingWorkFlowProcess.
  • HowtoPreparetheETLTestPlan.
  • HowtodesigntheTestcasesinETLTesting.
  • HowtoreportingtheBugsinETLTesting.
  • ETLTestingResponsibilities.
  • Howtodetectthebugsthroughdatabasequeries.
  • ETLPerformingTesting&PerformingTuning.
  • Other Advantages:
  • Real-time Scenarios.
  • Deployment Process.
  • Project Experience.
  • Resume Preparation.
  • Mock Interviews.
  • FAQ’s.
  • Job Assistance.
Register Now

You will Learn How To :

Course Benefits :

Register Now

Please use the form below to make your career excellent.