United way of Atlanta
Now H2kinfosys proudly announcing that we started a partnership with "United way of Greater Atlanta" organization to help homeless veterans on IT training.
Our Students Review
H2kinfosys - Best IT Online Training
Rated 4.7/5 based on 988 reviews
Vibha & BigHelp
"We're very happy for being a part of Vibha & Big Help Organizations."
We have donated part of sales towards to education to poor child.
QA DEMO on Every
TUE & THU @ 8 PM EST
Every Tuesday & Thursday @ 9:45 pm EST.
Make A PaymentIf you agree to our Terms & Conditions and Refund Policy, then only proceed with payment.
Advanced ETL Testing Online Training | ETL Testing Training In USA
100% Job Oriented - Instructor Led - Face 2 Face - True Live Online IT Trainings
For everyone - Any part of the World
Advanced ETL Testing
Online Training Course Catalog
Basic ETL Testing course is aimed to make aspirants acquainted with various features of ETL Testing and is a first step to the exciting world of data-warehousing given the fact that data is growing enormously in modern times and with more and more data, it means more and more data-warehousing projects ,consequently it will have more and more job opportunities.
As a next step to delve deep into real life data-warehousing project work and have greater command and confidence while working in ETL testing projects,we have come up with Advanced ETL Testing Course which will drill down further into ETL testing concepts.
The main driving factor in designing this course was the need to have a course which will be extension of Basic ETL Testing course and would enrich ETL testers with advanced technical skills to perform exceptionally well in any project.
Major Highlights this course are :-
- More hands-on exercise for students so that they can gain expertise in Buidling Test case, Executing them and preparing Test Plan.
- More scenario questions will be discussed in terms of specific problems encountered while working in actual data-warehousing project.
- SQL being one of the most important topic will be covered in greater details.
- Complete Hands-On on Advanced level SQL knowledge involving complex SQL queries.
- Advanced level knowledge on ETL tools specifically Informatica in terms of their detailed features.
- Details on various transformations used in Informatica and how we can build and implement ETL logic.
Advanced ETL Testing Course Training with Mock Interviews
- Course Highlights
- Skill Test/Certification
Topic wise Advanced ETL Testing Course Details:Session -1
- Introduction to Data ware house, purpose of DWH with examples
- DWH Architecture
- OLTP System vs OLAP System
- What is a fact table?
- What is a dimension table?
- Fact vs. Dimension
- What is star schema?
- What is snow flake schema?
- Process flow in ETL Testing
- Total SDLC of ETL testing
- Testing tools used for ETL testing
- How we will be planning ETL testing, explain how to generate testing reports
- DWH Tools (Different types of dwh tools)
- Types of data bases used in ETL testing
- Explaining about data mapping document
- Writing test cases for mapping documents
- Extensive handson test case preparation and test cases execution scenario 1
- Extensive handson test case preparation and test cases execution scenario 2
- Basic and Advanced SQLs
- Aggregate function in SQLs
- Various Joins like Inner Join,Left Outer Join,Right Outer Join,Full Outer Join
- Correlated Queries
- Overview of Informatica Architecture
- Introduction to Informatica PowerCenter Mapping Designer,Workflow Manager,Workflow Monitor,Repository Manager
- Details on mapping,session and worflow
- Details on Source Analyzer,Target Designer,Mapping Designer and Mapplet Designer
- Will show some informatica mapping already developed and explain how to trouble shoot them
- Basic level UNIX Commands used
Will update soon...!
Mr. Santosh: Masters in Computers
Will update soon...!