ETL Testing Course in Bangalore

i) Introduction to Data Warehouse
ii) Purpose of Data Warehouse
iii) What is ETL
iv) Overview of ETL Operations
v) ETL architecture
vi) Data Mart
vii) Types of Data Mart
viii) Data Mart vs Data Warehouse
ix) Dimension Table
x) Types of Dimension Table
xi) Fact Table
xii) Types of fact Table

i) OLAP and OLTP
ii) Data Modelling and Types of Data Modelling.
iii) Star schema and Snow-flake schema
iv) Normalization and De-Normalization
v) Slowly Changing Dimension(SCD) and Types of SCDs
vi) Real time scenarios of SCD
vii) Surrogate Key

i) History of SQL
ii) Introduction to SQL with Oracle Database
iii) DBMS vs RDBMS
iv) Data Definition Language(DDL)
v) Data Manipulation Language(DML)
vi) Transaction Control Language (TCL)
vii) Data Control Language(DCL)
viii) Data Types
ix) Aggregate Function
x) Character Function
xi) Date Function
xii) Where Clause, Having Clause and Group by Clause
xiii) Logical Operator and Comparison Operator

i) Constraints
ii) Case Statements
iii) Rank and Dense Rank
iv) Pseudo Columns
v) Set Operators
vi) Joins and Types of Joins
vii) Sub queries
viii) What is VIEW and real time scenario of VIEWix) Useful SQL query for Data Validation
x) Uses of SQL function in transformation

i) Introduction
ii) Informatica components
iii) Power Centre Designer
iv) Power Centre Workflow Manager
v) Power Centre Workflow Monitor
vi) Mapping
vii) Workflow
viii) Sessions
ix) Aggregate Transformation

i) Filter Transformation
ii) Expression Transformation
iii) Router Transformation
iv) Joiner Transformation
v) Sequence Generator Transformation
vi) Lookup Expression Transformation
vii) ETL Test Environment
viii) ETL Tester Strategy
ix) ETL testing Methodology
x) ETL Testing Techniques
xi) ETL Functional Testing
xii) ETL Performance Testing
xiii) SCDs
xiv) SCD Type1, Type2, Type3 Testing
xv) Initial Load and Incremental
xvi) Surrogate Key and Uses
xvii)Testing Surrogate Key
xviii)Testing Technical Attributes and Flags
xix) Testing Flat File Data
xx) Testing between different Source and
xxi) Testing of Constraints

i) ETL integration Testing
ii) ETL Regression Testing
iii) ETL System Testing
iv) UAT Testing
v) Designing the Test Cases
vi) Challenges in DWH testing
vii) Data Base Testing vs ETL/DWH Testing
viii) STM and BRD Documents
ix) Data quality Rules
x) Testing with different Transformations

i) Introduction to Scheduling Tools
ii) How to Schedule the JOB
iii) How to Run the JOB
iv) Verifying the Log files in Scheduling Tools

i) Introduction to JIRA
ii) Stories and Epic
iii) Creating Sub Tasks and Assigning the stories
iv) Assigning the Bugs / Bugs Tracking
v) Movement of stories: To-do, In Progress, Done