Course Description
This course provides hands-on training in ETL (Extract, Transform, Load) Testing, essential for ensuring data accuracy, integrity, and quality in data warehousing and business intelligence systems. Learn how to validate data movement, transformations, and reporting with industry-standard tools.
Why should I join?
In any data warehouse or BI system, ETL (Extract, Transform, Load) is the backbone. If the data being moved or transformed is incorrect or corrupted, the entire business suffers. ETL Testers ensure data accuracy, completeness, and reliability
ETL Testing course is a smart move if you’re aiming for a career in data, analytics, or QA — especially with the rise of data-driven decision-making across every industry.
Please contact us if you have any questions relating to any of the vika technologies features.
Course Content
Oracle Introduction
You don't currently have access to this content
6 Topics
• What is Data Warehousing?
You don't currently have access to this content
• OLTP vs OLAP
You don't currently have access to this content
• Data warehouse architecture (staging, ODS, data marts)
You don't currently have access to this content
• ETL: Extract, Transform, Load process overview
You don't currently have access to this content
• Role of an ETL Tester in the data pipeline
You don't currently have access to this content
• Introduction to BI tools (Power BI, Tableau)
You don't currently have access to this content
Unix Commands
You don't currently have access to this content
3 Topics
• RDBMS concepts: tables, keys, joins, normalization
You don't currently have access to this content
• Writing SQL queries for:
You don't currently have access to this content
• Hands-on with databases: Oracle, MySQL, or SQL Server
You don't currently have access to this content
OS information
You don't currently have access to this content
4 Topics
• What is ETL Testing?
You don't currently have access to this content
• Types of ETL Testing:
You don't currently have access to this content
• ETL Test case design and test scenarios
You don't currently have access to this content
• Data reconciliation and record count matching
You don't currently have access to this content
Copy and move commands using cp, mv command
You don't currently have access to this content
6 Topics
• Understanding Business Requirements
You don't currently have access to this content
• Data mapping documents (source-to-target mapping)
You don't currently have access to this content
• Test planning and strategy
You don't currently have access to this content
• Writing and executing test cases
You don't currently have access to this content
• Defect logging and tracking
You don't currently have access to this content
• ETL testing challenges and best practices
You don't currently have access to this content
Compression and un-compression
You don't currently have access to this content
5 Topics
• Informatica PowerCenter or Informatica Cloud (IICS)
You don't currently have access to this content
• Talend Open Studio
You don't currently have access to this content
• SSIS (SQL Server Integration Services)
You don't currently have access to this content
• Pentaho Data Integration
You don't currently have access to this content
• Navigating and validating workflows, mappings, and transformations
You don't currently have access to this content
Changing file permission
You don't currently have access to this content
2 Topics
• Comparing source and target using:
You don't currently have access to this content
• Using automation scripts for data comparison (Row counts, Checksum)
You don't currently have access to this content
Scheduling the job
You don't currently have access to this content
2 Topics
• Automating ETL test scenarios using:
You don't currently have access to this content
• Introduction to data pipeline testing in CI/CD environments (Jenkins)
You don't currently have access to this content
Editor command
You don't currently have access to this content
3 Topics
• Overview of:
You don't currently have access to this content
• Validating cloud-based pipelines
You don't currently have access to this content
• Logging, monitoring, and error handling in cloud ETL systems
You don't currently have access to this content
Includes
8 Lessons
31 Topics
Admin
