ETL Testing
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
- Classifying data sources and requirements
- Data acquisition
- Implement business logics and dimensional Modelling
- Build and populate data
- Construct Reports
Some of the key responsibilities of an ETL tester are
- Test ETL software
- Test modules of ETL data warehouse
- Execute database data-driven test
- Create, design and execute test cases, test plans and test harness
- Identify the problem and provide solutions for potential issues
- Data transfers and Test flat file
- 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:
- Gather hands-on knowledge and skill on ETL testing and features
- Learn about test case creation, designing and execution
- Knowing the common problems of testing and recovering them effectively
- Gain knowledge on OLTP and OLAP
- Working with best industry practitioner in real life projects
- 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:
- Learning Reporting data analyzing
- Learning Data Model Review analyzing
- How to Source data and its assessment analyzing
- Testers can get idea about several testing methods such as Schema Testing, Performance Testing and Packages Testing
- Learn Data transformation analyze and methods
- Learn Data comparison and data quality check
Key Features
- 12 hours of High-Quality In-depth E-Learning videos
- 24 hours of Exercises
- 70% of extensive learning through Hands-on exercises, Project Work, Assignments and Quizzes
- 24X7 access and support
- Guidance to Resume Preparation and Job Assistance
- Step -by- step Installation of Software
- Course Completion Certificate
Who can take ETL training?
- Professionals aspiring to become Business Object Professionals
- Business Intelligence Professionals or ETL Developers
- Project Managers, Database Professionals, Mainframe Professionals,
- SQL Developers or Quality assurance professionals
Curriculum
ETL Testing Overview, OLTP vs. OLAP
- Overview of ETL testing
- Concepts of Business Intelligence
- Lifecycle of ETL testing
- Core concepts of Database
- Difference between OLTP and OLAP
- Concepts of Data Warehousing
RDBMS Overview, Comparison between Database Testing vs Data Warehousing
- What is RDBMS?
- Concepts of relational databases
- Data Types
- Integrity Constraints
- Comparison between Database Testing and Data Warehouse Testing
Workflow and Case Study in data Warehousing
- Workflow for Data Warehouse
- Various Scenarios in ETL Testing
- Data Warehouse Testing
- ETL Mapping
- Data Loss/Mismatch Testing
Testing Scenarios
- Testing Scenario Matrix
- Constraint Testing
- Source to Target Testing
- Business Rules Testing
- Negative Scenarios Testing
- Dependency Testing
- Error Handling Testing
Data Checks with SQL
- Database Structure
- SQL for Testers
- Data Checks using SQL
- Examples of SQL Scripts
BI Testing and its Scope
- Check List – ETL Tester
- Key responsibilities of the Tester
- SCD Testing
- CUBE Testing
- BI testing and its scope
Projects and case studies
• Cognos Decision Stream
• SAS Enterprise ETL server
• Oracle Warehouse Builder
• Business Objects XI
• SAS business warehouse
• Info Processing
• Analytical Processing
• Data Mining
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:
- Finishing the classroom sessions successfully
- Completion of the quiz sets
- Submission of the projects successfully

Hemani Garg
The best thing about e-Learning Line is their online videos of missed classes. I have missed couple of lectures and got all the videos later from the website. That definitely helped me to understand all the course materials. I love everything about e-Learning Line. Highly recommended to all.

Manik Garg
It was a roller coaster ride for me with e-Learning Line. When I have taken the course I wasn’t sure whether I could do it or not, but I must say the instructor was fun and fabulous to be with. He is patient and was there all the while to guide me with my problems. I am very satisfied and very happy with e-Learning Line.

Gautam Kumar Goyal
The course curriculum was fabulous. It covers so many points on ETL Testing. Also the real life case studies and projects were amazing to work on. I was a fresher but after completing the course with e-Learning Line I have become a professional tester.

Nikhil Goyal
I have taken couple of courses under e-Learning Line so I trust them a lot. They are the best among all. Recently I have taken ETL Testing course and it was brilliant. I have become a Team Leader in my company. Thanks e-Learning Line.

Sanah Gumber
I was a business intelligence professional working with an MNC. I came to know about the ETL Testing course in e-Learning Line and without wasting time I have taken up the course. It helped me a lot to know various aspects of testing and methods.
Trainers Details
Contact Us


Online Class schedule (EST)
Course Features
Popular Courses







