Details
- IT professionals
- Manual & Automation Tester’s
- Basic knowledge of SQL
- Database Developers/Administrators
KEY FEATURES
- 100% Job Assistance & Assurity.
- Learn from the basics advance level of ETL testing concepts.
- Personal attention given to each & every participant during the training program.
- Live Projects to practice.
- Batches with limited seats.
- Weekend batches as per your suitability.
- Project assistance to get practical approach.
- Two training centers for your convenience: Kothrud and Wakad
- If you are located in Kothrud or nearby areas like Karve Nagar, Warje-Malwadi, Bhusari Colony, Shivaji Nagar etc. then our branch in located a short distance away from you i.e. Vanaz Corner, Kothrud.
- If you are located in Pimpri Chinchwad or nearby areas like Pimple Saudagar, Wakad, Chinchwad, Balewadi, Sangvi, Dapodi etc. then you can visit our branch in Wakad near Kalewadi Phata.
Outline
ETL Testing Course Content:
- Data warehouse and ETL Concepts
- Database Concepts and SQL
- Queries: Joins, Simple, Complex and Co-related queries
- What is Dataware House?
- Characteristics of the Dataware House
- OLTP Vs OLAP
- Dimension Table Vs Fact Table
- Types of Source Files
- Advantages of Dataware House
- Meta Data
- Dataware House Vs Data Mart
- Data Extraction
- Data Transformation (Different Transformation rules)
- Data Loading
- SCD (Type-1, Type-2 and Type-3)
- Introduction of ETL Tool
- Overview of ETL Tool Architecture
- ETL Tool Environment
- Approaches of DW or ETL
- Database Designs (Star Schema, Snowflake Schema etc)
- Data warehouse (ETL) Testing Process
- Software development life cycle and Testing Life Cycle
- Data Ware House (ETL) Test or Work Flow Process
- ETL Testing Work Flow Process
- ETL Testing Introduction
- What is use of testing?
- What is quality & standards?
- Responsibilities of an ETL Tester
- Risks and Challenges of ETL Testing
- Resume Preparation and Interview Tips
- Q & A
- Data warehouse (ETL) Test Preparatio
- Understanding of Source files and Target
- ELT Testing methodologies and Test Techniques
- ETL Test approach
- Types of Testing
- ETL Testing Work Flow Process
- How to Prepare ETL Test Plan
- How to design Test cases in ETL Testing.
- DW (ETL) Test Environment Setup
- Data warehouse (ETL) Test Execution and Results and Report
- How to perform DW (ETL) Testing.
- Testing the Requirements and Functional Design
- Different phases in DW (ETL) Testing
- Data validation in Source and Target
- How to apply Transformation rules in ETL Test execution.
- How to reporting the Bugs in ETL Testing
- How to detect the bugs through database queries
- Automation for ETL Test Execution.
- Tools: DB Visualiser
- How to Report DW (ETL) Test Execution Status: Daily Vs Weekly
- ETL Tool Concepts
- Informatica 8.6
- DataStage 7
Training Institute Pune is a leading institute in Pune conducting training programs for various software fields & provides certification for both individuals and organizations.Training Institute Pune is subsidiary of Optimized Infotech which offers IT services and training.
We have built a strong reputation to provide an excellent service to individuals with a team of fully qualified professionals. We deliver training to the employed and unemployed individuals to enhance their knowledge & qualities in desired field. We design a training program for additional qualifications beneficial for future & for great career start to candidate undergoing training at our Institute.
Institute offers a wide variety of software classes and access to the concepts and skill development reinforced through training & consulting and certification. The institute is taking a lead in spreading an innovative form of learning that provides you with theoretical as well as practical training.
OUR OBJECTIVE
Our objective is to cater all individuals ranging from beginner level to the IT professionals. Our motto is to provide interactive environment so that the candidates can excel themselves in their desired field & help them grow their career. We put efforts to honestly serve the society & to provide excellent training & classes facilities to our candidates. ...
