ETL Testing Course Training Cum Job Assistance | Marathahalli - Bangalore

DWH Concepts:
•WHAT IS DWH?
•DWH ARCHITECTURE
•OLTP vs OLAP
•DATA MART and TYPES
•DM vs DWH
•ODS
•Data Modeling
•Dimensional Modeling
•DWH SCHEMA designing(Star Schema, Snow flake schema)
•Overview of Dimension tables
•Overview of Fact tables
•Slowly Changing Dimension

ETL Testing Course Contents:

•Introduction of ETL-Extract, Transform, Load
•ETL Tools and Diff Types of ETL Tools
•ETL Architecture
•ETL Testing & Why we require
•Process of ETL Testing(Informatica)
•Testing if correct data is being extracted from source
•Performing Source to Target validations
•Data Mapping between Source and Target
•Testing Transformation logic accordance with Business Rules
•Constraint Testing
•INITIAL LOAD
•INCREMENTAL LOAD
•FULL LOAD
•FAQ’S
BI Testing:
•Introduction of BI testing
•BI Tools and Diff Types of BI Tools
•BI Architecture
•BI Testing & Why we require
•Process of BI Testing(OBIEE)
•BI Testing Responsibilities
•BI Performance Testing

Testing Concepts:
•Whitebox Testing
•Blackbox Testing
•Gray Box Testing
•Regression Testing
•Smoke Testing vs Sanity Testing
•User Testing
•Unit testing
•Integration testing
•Module testing
•System testing
•User Acceptance Testing(UAT)
•Quality center

Oracle Basics & Concepts:

•Basics of SQL (ex., DDL, DML etc)
•Joins
•SUB QUERIES, CORELATED SUB QUERY
•VIEWS n MATERIALIZED VIEWS
•INDEX
•CONSTRAINTS
•REFERENTIAL INTEGRITY
•Most uses SQL functions in Transformations


Contact us for more details
ELEGANT IT SERVICES
9 8 8 6 5 4 1264
Email: elegantitservice@gmail.com
Website: www.elegantitservices.com