ETL Testing

Topics covered

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.

Call : vijay : cell : 0-9440089341

Email : moc.snoitulosdnimartceps|ofni#moc.snoitulosdnimartceps|ofni

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License