Follow Us:

ETL Testing Training in Chennai

Course Duration

40 Hours
Sign in with Facebook Sign in with Facebook

About ETL Testing

  • Production Validation Testing (testing data before moving into production). Sometimes called “table balancing” or “production reconciliation,” this type of ETL testing is done on data as it is being moved into production systems. The data in your production systems has to be right in order to support your business decision making. Informatica Data Validation Option provides the ETL testing automation and management capabilities to ensure that your production systems are not compromised by the data update process.
  • Source to Target Testing (data is transformed). This type of ETL testing validates that the data values after a transformation are the expected data values. The Informatica Data Validation Option has a large set of pre-built operators to build this type of ETL testing with no programming skills required.
  • Application Upgrades (same-to-same ETL testing). This type of ETL testing validates that the data coming from an older application or repository is exactly the same as the data in the new application or repository. Must of this type of ETL testing can be automatically generated, saving substantial test development time.
  • 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.