ETL Testing Training Module

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.
  • Duration

    40 Hours

    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.

    You have gone through all the training and reading material, since you decided to choose your career. This might have given you initial understanding about the procedures and techniques and you are even able to pass your certification as well ...

    Best - SAP training center in London.