Course will be at corporate level.
ETL Testing – BI Testing- DWH Testing-Datawarehouse Testing
I am providing this real time training which will help the students to gain experience in ETL Testing, rather than just knowledge . Training will be at corporate level.
I have experience of 13+ years in the industry. I worked as a Test manager, Business Analyst, project manager in ETL and BI Testing.
I Worked with the companies like ITC Infotech, Honeywell, Accenture, TCS.
I have very good success rate in getting a break for the Manual Testers in ETL Testing and many students/Freshers with gap who are looking for a break in software after graduation are highly successful in getting into MNCs after our training
After this training the student will scale up to 3 to 7+ years experience level and will be able to directly work on projects.
• ETL Testing using Informatica PowerCenter
• 1. Data Warehousing Concepts
o � Data Warehouse Concepts, Design.
o � Need of Data Warehouse.
o � Introduction to OLTP, ETL and OLAP Systems.
o � Data Warehousing Architecture.
o � Dimensional Modeling.
o � Data Marts and ODS.
o � Star Schema and Snowflake Schema.
o � SCD (slowly changing dimension).
o � Types of Fact and Dimension Tables.
o � DWH Realtime Concepts.
• 2. SQL Concepts
o � Introduction to Oracle.
o � Basic Concepts in SQL.
o � Data Types.
o � Select statement usage.
o � Joins.
o � Sub Queries.
• 3. ETL Testing - Introduction
o � Introduction to ETL.
o � ETL Architecture.
o � What is the use of testing?
o � What is quality & standards?
o � Responsibilities of ETL Tester.
o � Sub Queries.
• 4. ETL Testing - Procedure
o � Steps in DWH Testing
o � Prerequisites of DWH Testing.
o � Levels of DWH Testing
o � The Data Warehousing process
o � Coverage of ETL Testing
o � How DWH Testing is Different from Application Testing?
o � Challenges in DWH Testing
• 5. Testing Methodologies.
o � ETL Testing WorkFlow Process.
o � How to Prepare the ETL Test Plan.
o � How to design the Testcases in ETLTesting.
o � How to report the Bugs in ETL Testing.
o � ETL Testing Responsibilities.
o � How to detect the bugs through database queries.
o � ETL Performance Testing
• Resume Preparation and How to Accept and handle the work after joining the company
• 6. Reports
o � Overview
� Reports Testing Process
Jayanagar, JP Nagar, Banashankri, Bannergatta Road, Koramangala, Bommanahalli, Koramangala.
Jayanagar JP Nagar Silk Board Koramangala bommanahalli banashankari btm vijayanagar vidyanagar