ETL Testing Online Training
35 Hours
24/7 Digital Library Access
3012 Total Learners
Lifetime Access
Instructor-led Online Training
Interactive Live training
Real Time, Certified, Expert Trainers
Job oriented & Industry ready curriculum
Free Course Access for 365 Days
Fast-track / Regular / Weekend
Recorded Video Online Training
Learn at your own convenience
Certified & Industry Experts Trainers
Email & Forum support for 365 days
Priority Certification support
Multi Instructor sessions
Learn ETL Online training
What is ETL Testing Online Training?
Today’s businesses have to work with data in multiple formats extracted from multiple sources. All this makes ETL testing all the important. The extracting, transforming and loading of data has to be verified and any anomalies found have to be fixed. Thus there is a need for testers in ETL and Data Warehouse domains. This ETL testing online training can equip you to take up good jobs in some of the biggest companies in the world.
Who Can Learn?
- ETL and SQL Developers, software engineers and analysts
- BI, Mainframe, and database Project managers
ETL Testing Course Curriculum
Duration: 35 Hours
- Software Testing Life Cycle
- Software Development Life Cycle
- Manual Testing Experience is Plus
- Usage of HP quality Center
- Defect Life Cycle
- What is Data Ware House?
- Difference between OLTP and Data warehousing
- Data Extraction
- Transformation
- Data loading
- Star Schema
- Snow Flake Schema
- Type-1 SCD
- Type-2 SCD
- Type-3 SCD
- SELECT
- Single Row Functions
- Aggregate Functions
- JOINS
- SUBQUERYS
- SET Operators
- Analytical Functions
- DDL, DML, Views (High level Concepts)
- Minus querying
- Count Querying
- Introduction
- What is use of ETL TESTING?
- Responsibilities of an ETL Tester
- Testing methodologies
- Smoke Testing
- Functional Testing
- System Testing
- ETL Testing Work Flow Process
- How to Prepare the ETL Test Plan
- How to reporting the Bugs in ETL Testing?
- ETL Testing Responsibilities
- How to design the Test cases in ETL Testing.
- How to detect the bugs through database queries
- ETL Performing Testing & Performing Tuning
- ETL Testing with Informatica PowerCenter
- SAMPLE Loading from source to target
- SORTER Transformation
- FILTER Transformation
- ROUTER Transformation
- EXPRESSION Transformation
- JOINER Transformation
- UNION Transformation
- AGGREAGATOR Transformation
- RANK Transformation
- STORED PROCEDURE Transformation
- SEQUENCE GENERATOR Transformation
- Flat File
- Look up Transformation
- Slowly Changing Dimension Type 1
- SCD Type 2
- SCD Type 3
- Update Strategy
- XML Source Qualifier
- Types of load (Full, incremental, Refresh)
- BI Testing with OBIEE
- BI Test cases
- Data validation with OBIEE
- UI Testing with OBIEE
- Different Tools
- SQL Developer
- Informatica PowerCenter Client Tools
- OBIEE Reporting Tool
Trainer Information
- 5 + years of work experience in IT Industry
- Well-equipped in performing ETL operations with Informatica Power Center.
- Excellent interpersonal and communication skills.
Frequently asked questions
We are having ample of experience in ETL Testing Online training. After every session recordings will be provided and soft copy of ETL Testing Training material will be provided.
Bigclasses offers 365 days access to videos, course materials, 24/7 Support, and course material upgrading to latest version. Bigclasses involves working with real time projects,test cases and assignments.The entire course content is in line with clearing ETL Testing Certification exam.
We offer four types of Modes:
- Instructor-led Online Training
- Recorded Video Training
- Corporate Training
- Project Support
Request a Demo
Get Free Digital Library Access
Follow Us