ETL Testing Training in Chennai

Course Duration

40 Hours

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.

You will Learn How To :

Course Benefits :

Please use the form below to make your career excellent.

Enter your name here...

Enter your email here...

Enter your contact no here...