Course Details
Extraction Transform and Load (ETL) is a data integration technology that extracts data from several heterogeneous data sources, combines and standardizes the data, then presents or stores the data in a uniform format for informational purposes. ETL is necessary because many non-modern system architectures evolved over the years in environments where data was typically captured, processed and stored by separate and distinct software applications and databases. As a result, the data residing in the databases of many companies is typically non-standardized.
ETL Testing Online Training Overview
Mindmajix ETL testing training program is architected for learners to educate, explore, experiment and gain expertise over the subject. Data warehouse or ETL testing is often initiated as a result of mergers and acquisitions, compliance and regulations, data consolidation, and the increased reliance on data-driven decision making (use of Business Intelligence tools, etc.). ETL testing is commonly implemented either manually or with the help of a tool (functional testing tool, ETL tool, proprietary utilities). Our ETL testing training program starts with introduction to Data warehouse concepts, Etl development life cycle, Etl test plan, Etl testing life cycle (or) Etl test process, Types of etl testing, Types of etl bugs, Bug reporting, Testing templates (test case, bug reporting & etc..), Etl performance testing, Etl interview questions, Project with example, SQL, Unix and much more…
ETL Testing Training Curriculum
Data ware house is relational database which is subject oriented, integrated, time-variant and non volatile collection of data used to support strategic decision making process. What is Data Ware House?
Difference between OLTP and Data Warehousing
Data Acquisition
Data Extraction
Data Transformation
Data Loading
Data Marts
In this module, we’ll focus over business intelligence and data warehouse projects. Testing Objectives
Testing Strategies
Testing Deliverables
After a good understanding of data warehousing concepts, we’ll now focus over ETL testing concepts. Introduction
What is use of testing
What is quality & standards
Responsibilities of a ETL Tester
This module aims to help you explore the subject as well as provide a good hands on. Bug Identification
Usage of Sql for automating the process
Auditing count of records
Validation of data and identifying issues
Exceptional handling
Meta Data
Performance Testing (ETL, Query)
Volume Testing
What is batch totals and data marts? Explanation is provided in this module. Batch Totals
Query on Data Mart and Cube
The process of generating reports and analysis is explained in this module. Reports (DW / DM / Cube)
OLAP Analysis (DW / DM / Cube)
DashBoard
Faqs
Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.
We record each LIVE class session you undergo through and we will share the recordings of each session/class.
Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.
The Training itself is Real-time Project Oriented.
Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.
There are some Group discounts available if the participants are more than 2.
As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like
Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad, San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth etc…
Drop Us A Query
