About the course:

ETL stands for Extract-Transform-Load and it is a procedure of how data is loaded from the several source systems to the data warehouse.  Data is extracted from an OLTP database, converted to match the data warehouse schema and loaded into the data warehouse database.  Many data warehouses also integrate data from non-OLTP systems such as text files, legacy systems and spreadsheets. 

ETL testing is performed in 5 phases

1.  Classifying data sources and requirements
2. Data acquisition
3. Implement business logics and dimensional Modelling
4. Build and populate data
5. Construct Reports

Some of the key responsibilities of an ETL tester are

1. Test ETL software
2. Test modules of ETL data warehouse
3. Execute database data-driven test
4. Create, design and execute test cases, test plans and test harness
5. Identify the problem and provide solutions for potential issues
6. Data transfers and Test flat file
7. Writing custom SQL queries for various scenarios

Objective of the course:

The course is set for beginners as well as professionals. The main objectives of the course are:

1. Gather hands-on knowledge and skill on ETL testing and features
2. Learn about test case creation, designing and execution
3. Knowing the common problems of testing and recovering them effectively
4. Gain knowledge on OLTP and OLAP
5. Working with best industry practitioner in real life projects
6. Certifications after completion of the course from e-Learning Line

Advantage of the course:

The course has immense learning as well as career benefits. The most important advantages are:

1. Learning Reporting data analyzing
2. Learning Data Model Review analyzing
3. How to Source data and its assessment analyzing
4. Testers can get idea about several testing methods such as Schema Testing, Performance Testing and Packages Testing
5. Learn Data transformation analyze and methods
6. Learn Data comparison and data quality check

Key Features

1. 12 hours of High-Quality In-depth E-Learning videos
2. 24 hours of Exercises
3. 70% of extensive learning through Hands-on exercises, Project Work, Assignments and Quizzes
4. 24X7 access and support
5. Guidance to Resume Preparation and Job Assistance
6. Step -by- step Installation of Software
7. Course Completion Certificate

Who can take ETL training?

1. Professionals aspiring to become Business Object Professionals
2. Business Intelligence Professionals or ETL Developers
3. Project Managers, Database Professionals, Mainframe Professionals,
4. SQL Developers or Quality assurance professionals

Curriculum

ETL Testing Overview, OLTP vs. OLAP

1. Overview of ETL testing
2. Concepts of Business Intelligence
3. Lifecycle of ETL testing
4. Core concepts of Database
5. Difference between OLTP and OLAP
6. Concepts of Data Warehousing

RDBMS Overview, Comparison between Database Testing vs Data Warehousing

1. What is RDBMS?
2. Concepts of relational databases
3. Data Types
4. Integrity Constraints
5. Comparison between Database Testing and Data Warehouse Testing

Workflow and Case Study in data Warehousing

1. Workflow for Data Warehouse
2. Various Scenarios in ETL Testing
3. Data Warehouse Testing
4. ETL Mapping
5. Data Loss/Mismatch Testing

Testing Scenarios

1. Testing Scenario Matrix
2. Constraint Testing
3. Source to Target Testing
4. Business Rules Testing
5. Negative Scenarios Testing
6. Dependency Testing
7. Error Handling Testing

Data Checks with SQL

1. Database Structure
2. SQL for Testers
3. Data Checks using SQL
4. Examples of SQL Scripts

BI Testing and its Scope

1. Check List – ETL Tester
2. Key responsibilities of the Tester
3. SCD Testing
4. CUBE Testing
5. BI testing and its scope

Projects and case studies

Certification

After completion of the entire ETL Testing Course under e-Learning Line each candidate will receive a ‘course completion certificate’. Each attendee can get the certificates after:

1. Finishing the classroom sessions successfully
2. Completion of the quiz sets
3. Submission of the projects successfully