Extract, transform, Load (ETL) is a process of integration that merges data from different data source platforms into a single unit of data store that can later be loaded in data warehouses. ETL basically refers to, “Extraction of data from different applications” developed & supported by different vendors, managed & operated by different persons hosted on different technologies.MindQ offers the best ETL Testing course in Hyderabad with approachable teaching methods. Our ETL trainers are qualified and have been consistent in achieving quality results throughout the training process. Our extensive training is inclusive of the core conceptuals of ETL like Joining and Deduplication of data, filter and sort the data using specific attributes, Transposing data, make business calculations etc – to derive the data for loading into the destination system-Loading the data into the destination system, usually the data warehouse, which could further be used for business intelligence & reporting purposes. The ETL course we offer is set to benefit beginners as well as advanced professionals to help promote their skills and efficiency.

Course Objectives:

• Understand concepts within ETL process testing and its realtime usage
• Make use of tools to tailor out the existing applications to test

About the Trainer

Introduction

• Name: Martin O’really
• Professional Title: Lead QA Analyist
• Education: Master’s in Computer Science, XYZ University
• Expertise:
  • Over 15 years of experience in software assurance and test framework architecture
  • Proficient in end to end testing cycle, full-stack development with expertise in Java and web application development
• Industry Experience:
  • Worked with leading tech companies, contributing to the development of scalable and secure applications
  • Extensive experience in designing and implementing cloud-based solutions for diverse industries
• Training Experience:
  • Conducted numerous training sessions on cloud architecture, software development best practices, and agile methodologies
  • Received positive feedback for clear communication and hands-on, practical training approach
• Skills:
  • Strong communication and presentation skills
  • Ability to convey complex technical concepts in an understandable manner
  • Passionate about fostering a collaborative and engaging learning environment

Checklist

Offer

10% Off on

EARLY BIRD OFFER

enroll now

Syllabus

ETL Testing Training Curriculum

Data Warehousing Concepts 

• Dataware house architecture 
• Datamart 
• DW Schema – Star Schema – Snow Flake Schema 
• Objects in DWH – Dimension table – Fact table 
• SCD(SLOWLY CHANGING DIMENSIONS) – SCD TYPE 1 – SCD TYPE 2 – SCD TYPE 3 

Differences between OLTP and OLAP SDLC And STLC 

• Agile Methodologies 
• Waterfall Model 

SQL (Structured Query Language) 

– DDL (Data definition language)

 – DML (Data manipulation language) 

– DQL (Data query language) 

Data Ware Housing Life Cycle w.t.r ETL ETL TESTING TYPES 

• Data migration testing 
• Sample testing and Scenario Testing 
• BATCH JOB Testing 

– Inbound Testing

 – OutBound Testing 

ETL TESTING TASKS

• Spec analysis 
• Designing Testcases 
• ETL Test scripts preparation 
• Environment Preparation
• Test Execution
• Peer Reviews of QA deliverables

ETL Testing validations 

• Structure validation
• Count validation
• TRANSFORMATION Logic Check 
• Data validation
• MINUS Query 
• Duplicate Check 
• Error logic Check 
• RI Validation( Referential integrity constraint check)
• Scenario testing
• Derived checks 
• Default values check 
• Data Integrity check 

Basic checks at ETL Phases 

• Extraction phase testing 
• Transformation phase testing 
• Loading phase testing 

Testing for SCD 

• SCD Type1 Testing
• SCD Type2 

Testing Overview of ETL Tool (Data stage) CODE PROMOTION PROCESS 

• Dev to QA 
• QA to UAT
• UAT to Production 

CONTROL M ( Scheduling tool slides) UNIX

Sounds Intresting?