ETL Testing

240 hrs Online Training
240 hrs Classroom Training

ETL – Extract Transform Load, the standard process across Business Data Warehouse applications to move data from OLTP databases into data warehousing system. ETL testing focuses on the testing frameworks to carry out validation of the ETL process of any data warehousing applications.
This involves:
1. Live Project Training
2. Component-wise tracking
3. Weekly mock interviews
4. Real-time use cases implementatio

Available Programs
JOIP
JOIP Internship
Job Guarantee Program
Training

Rs. 30,000

*40 days of access

JOIP

Rs. 1,10,000

*40 days of access

Upcoming Batches
DateTimeDurationDownload
Curriculum
Description

Business Data Warehousing utilizes testing services during the data load process to ensure the data source used for building the analytical reports are verified for correctness. ETL – Extract Transform Load, the Testing process used in Data warehousing applications. ETL testing is the most comprehensive methodology which helps identify defects, isolated and rectified them, in order to produce high quality analytical processing data.

Quality Thought offers the best ETL Training program with emphasis on real-time application testing case studies. Our course curriculum has been prepared by trainers with real-time industry experience with a lot of emphasis on real-time case studies and assignments. The primary objective of the ETL training is to help students and working professionals learn and master all the important facets of ETL testing ensuring the students are market ready to grab opportunities across industry domain on the data warehousing profile.

Introduction to Business Intelligence, and Business data warehousing prepare students to understand the basic of data warehousing and various tools and application designed to consume large data stores.

Study on Teradata is the primary focus area, working on the business data warehousing process to understand and focus on teradata basics, objects and memory space management. Storage and retrieval of Teradata is worked upon with real-time case studies.

Teradata performance analysis and other Teradata utilities and tools are worked and studied in detail to master the technology platform and its framework.

Informatica is another important area of learning, with focus on transformations and workflow management. Project work at the end of the program helps put all the learning in perspective and prepare for facing read-world challenges faced by industry.

ELT Testing program can be picked up by anyone having good hands on understanding of elementary programming and Data warehousing application development. The course is applicable to:

Graduates/Post Graduates/Fresher
Working IT professional from programming, web development and DBA fields
Software programmers
Business Analyst
Data Warehousing engineers

Testing is one of the key activities associated with any project development life cycle. Proper testing is of at most importance in any product development including Business Data Warehousing. Testing engineer will always be in demand and are the backbone of software product development companies. ETL testing requirements are on an upward raise with Business Data warehousing gaining momentum across industry. Test engineers and Student with the right skill set and a flare for testing have great opportunities in the Testing space and a Career is testing technology will be excellent and fulfilling.

ETL Testing is for people for any background. You just need to have basic understand of computer system and hands on with data warehousing applications. People from non-programming background with a flair for understanding programming and data warehousing can also get into this program.

ETL Testing Course Curriculum
Data warehousing
  • Introduction to data warehousing
  • What is Data Warehousing
  • Architecture of Data Warehousing
  • Characteristics of the Data Warehousing
  • What is OLTP & OLAP AND difference between OLTP & OLAP
  • Data mart/ Data Warehouse
  • Dimensional modeling
  • Different Types of Dimensions and Facts.
  • Slowly Changing Dimensions(Type-1,2,3)
Database Concepts (Using Teradata)
  • SQL fundamentals
  • DDL Statements
  • DML Statements
    Logical operations
    Arithmetic operations
    Group & Aggregation functions
    String functions
    Format functions
    Cast functions
    Conditional expressions
  • Set Operators (Union, Intersect, Minus)
  • Case, Coalesce, Nullify
  • Inner join
  • Outer Join
  • Self-Join
  • Cross Join
  • OLAP Functions (Rank, Csum, Msum, Mdiff, Row Number)
  •  
  • What Is Teradata Why for It Is What For It Is
    What is Teradata?
    Why Teradata?
  • Teradata Architecture &its Components
  • SMP Architecture
  • MPP Architecture
  • Parsing engine(PE) Architecture
  • AMP Architecture &uses
  • By net Benefits &types
  • Virtual processors
  • Types of tablesM
  • Set tables
  • Multi Set tables
  • Temporary tables
    Global temporary tables
    Derived tables
    Volatile Tables
  • Views
  • Permanent spaces
  • Temporary spaces
  • Spool spaces
  • Hash algorithm
  • Row hash
  • Hash map
  • Receiving V Disc
  • Types of indexes in Teradata
  • Primary index(unique, non- unique)
  • Secondary index(unique, non- unique)
  • Partition Primary Index
  • Fall Back
  • Journaling
  • Explain usage
  • Collecting statistics
  • SQL tuning
  • Various SQL statements
  • Bteq
  • Multiload
  • Fastload
  • Tpump
  • Fast export
ETL Informatics Power
  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Informatica Architecture.
  • Source Analyzer
  • Target Designer
  • Transformations
  • Mappings
  • Sessions
  • Workflows
  • Working with Relational Sources
  • Working with Flat Files
  • Working with Relational Targets
  • Working with Flat file Targets
  • Active and Passive Transformations
  • Source Qualifier
  • Expression
  • Sequence Generator
  • Filter
  • Joiner
  • Union
  • Sorter
  • Rank
  • Router
  • Aggregator
  • Normalizer
  • Lookup
  • Server Architecture
  • Workflows & Sessions
  • Real Time Scenarios
  • Importance of ETL Testing
  • Responsibilities of ETL Tester
  • Real time scenarios for ETL Tester
  • Different approaches for ETL Testing
  • How to validate data for multiple sources
  • ETL testing workflow process
  • How to prepare queries using Mapping rules
  • Hot to prepare ETL Test Plan
  • How to prepare Estimates
  • How to design Test Cases
  • How to design Test Scenarios
  • How to prepare Test scripts
  • How to prepare Test data for test cases
  • How to execute ETL Test Cases
  • Defect Tracking and Reporting
  • Types of defect in ETL Testing
  • Challenges in ETL Testing
  • How to detect bugs through queries
Project Essentials
  • Project Description
  • Client Name
  • Client Description
  • Business Background of Project
  • Process followed in the Project
  • Tools used in the Project
  • Environments in the Project
  • Team Size
  • Project Architecture
  • Testing Life Cycle in the Project
  • Query Tracker
  • Test Plan preparation
  • Test Cases preparation
  • Requirement Traceability Matrix
  • Review process in Project
  • Test case Execution
  • Defect Life Cycle in project
  • Role of Quality Centre in project
  • Regression Testing in Project
  • Bugs Identified in Project
Certification

Quality Thought’s ETL Testing Certification Process:

Quality Thought will provide a certificate to the students who successfully completed their ETL Testing training. The certification will be provided within one week of the training completion.
The certification will be given to the students who have successfully completed their projects and assignments on time.

FAQs

Students can benefit from our State of the art lab infrastructure facilities at all our training centers across the city. Our lab facilities are available through the day on all working days. For our online students, they can connect to our servers and other lab facilities over the internet and practice. These facilities are available 24X7.

If the student misses out of attending any session, he or she can re-attend the session by:
1. Attending the same session in another batch if student is attending classroom based session.
2. For online sessions, recording of the classes can be accessed by the student at all time to help revisit and listen the sessions missed out.

All our trainer are real-time industry experts with minimum of 10+ years of experience. Complete profiles of our trainers are available for review at our center and students are free to come interact with them and know more about them, before enrolling for programs.

All training programs conducted by Quality Thought are available in 3 modes, instructor based classroom programs, instructor based live online training and self-paced video based training. Students can choose.

All discounts are subject to case-to-case basis. Please feel free to meet our administration staff to have a better discussion on the same. We do offer a variety of discounts and concession to our students coming in from different backgrounds.

 

For all corporate training requirements please feel free to get in touch with our administration staff managing corporate marketing and interaction. We have of the finest programs and offer to corporate with best-in-class programs.