ETL Testing Training

With this online ETL Testing Training, you will gain expertise in the process of loading data from the source system to the data warehouse. This course not just makes you thorough in the basic ETL testing concepts but also in its advanced techniques.
View More
1325 Ratings
1569 Learners
30 Hours
15 Hours
ETL
365 Days
24 / 7 Support
Intermediate
Online Classroom
Attend our Instructor Led Online Virtual Classroom
USD 349 USD 309Enroll now
One to One Training
Get 1-to-1 Live Instructor Led Online Training in flexible timings
USD 699 USD 599Enroll now

About Course

This course covers ETL/Data warehouse testing which is used to test all the stages involved in raw data's transformation into business intelligence. Businesses collect raw data from daily transactions carried out in human resources, administration, sales, and the ETL process consolidates and transforms this data into usable information. It then stores it in data warehouses. ETL testing performs a series of tasks to debug each stage of the transformation ensuring efficiency. It verifies the quality of the data, validates the source, runs data checks, checks the schema, runs performance tests on the data, keeps error logs, and runs a host of other tests. Thus, ETL and data warehouse testing are an indispensable part of a company's ability to gather accurate information about its performance in the market.

ETL/Data Warehouse Testing online training program begins with a review and analysis of data warehousing. The course distinguishes ETL from BI and describes the stages of the extract-transform-load process. Breaking each stage down to its components, the course discusses the errors that creep in at each stage and the types of ETL tests that are performed to purge them. ETL/Data Warehouse Testing online training program then launches into a discussion of the key operations that are involved in ensuring smooth performance. These include verifications of data extraction/transformation, source to target data migration, preservation of table relations—joins and keys—during transformation, data accuracy, and so on. It offers a range of techniques for testing and runs through a variety of test cases wrapping things up with best practices.

Some familiarity with writing SQL queries as well as data warehousing concepts and Unix is recommended. The course has no formal prerequisites, however, and anyone may register.

As computing slowly takes over all automatable aspects of business decision-making, processes-testing naturally gains in importance. The widespread popularity of ETL Tools, such as Oracle Data Integrator, Informatica PowerCenter, and IBM Infosphere Information Server prove that such a widespread shift is in the offing. This transformation has produced a need for ETL testers in India that numbers beyond 10,000, and the trend is likely to continue well into the future. A certified ETL tester with sharp analytical skills, technical proficiency, and good verbal skills can easily break into this lucrative field. Sign up for a bright future with ETL/Data Warehouse Testing online training program today.

ETL Testing Syllabus

  • What is Data Warehouse?
  • Need of Data Warehouse
  • Introduction to OLTP, ETL and OLAP Systems
  • Difference between OLTP and OLAP
  • Data Warehouse Architecture
  • Data Marts
  • ODS [Operational Data Store]
  • Dimensional Modelling
  • Difference between relation and dimensional modelling
  • Star Schema and Snowflake Schema
  • What is fact table
  • What is Dimension table
  • Normalization and De-Normalization
  • ETL architecture.
  • What is ETL and importance of ETL testing
  • How DWH ETL Testing is different from the Application Testing
  • SDLC/STLC in the ETL Projects (ex: V Model, Water fall model)
  • Challenges in DWH ETL Testing compare to other testing
    • Incompatible and duplicate data.
    • Loss of data during ETL process.
    • Testers have no privileges to execute ETL jobs by their own.
    • Volume and complexity of data is very huge.
    • Fault in business process and procedures.
    • Trouble acquiring and building test data.
  • ETL Testing Work flow activities involved
    • Analyze and interpret business requirements/ workflows to Create
      estimations
    • Approve requirements and prepare the Test plan for the system testing
    • Prepare the test cases with the help of design documents provided by the
      developer team
    • Execute system testing and integration testing.
    • Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)
    • How to detect the bugs in the ETL testing
    • How to report the bugs in the ETL testing
    • How to co-ordinate with developer team for resolving the defects
  • Types of ETL Testing
    • Data completeness.
    • Data transformation.
    • Data quality.
    • Performance and scalability.
    • Integration testing.
    • User-acceptance testing.
  • SQL Queries for ETL Testing
  • Incremental load testing
  • Initial Load / Full load testing
  • Different ETL tools available in the market
    • Informatica
    • Ab Initio
    • IBM Data stage
  • Power Center Components
    • Designer
    • Repository Manager
    • Workflow Manager
    • Workflow Monitor
    • Power Center Admin Console
  • Informatica Concepts and Overview
    • Informatica Architecture.
  • Sources

    Working with relational Sources

    • Working with Flat Files
  • Targets
    • Working with Relational Targets
    • Working with Flat file Targets
  • Transformations – Active and Passive Transformations
    • Expression
    • Lookup –Different types of lookup Caches
    • Sequence Generator
    • Filter
    • Joiner
    • Sorter
    • Rank
    • Router
    • Aggregator
    • Source Qualifer
    • Update Strategy
    • Normalizer
    • Union
    • Stored Procedure
    • Slowly Changing Dimension
      • SCD Type1
      • SCD Type2 — Date, Flag and Version
      • SCD Type3
  • Workflow Manger
    • Creating Reusable tasks
    • Workflows, Worklets & Sessions
    • Tasks
  • Session
  • Decision task
  • Control Task
  • Event wait task
  • Timer task
    • Monitoring workflows and debugging errors
  • Indirect Loading
  • Constraint based load ordering
  • Target Load plan
  • Worklet ,Mapplet ,Resuable transformation
  • Migration ?ML migration and Folder Copy.
  • Scheduling Workflow
  • Parameter and variables
  • XML Source, Target and Transformations
  • Performance Tuning
    • Pipeline Partition
    • Dynamic Partition
    • Pushdown optimization
  • Preparation of Test Cases
  • Executing Test case
  • Preparing Sample data
  • Data validation in Source and target
  • Load and performance testing
  • Unit testing Procedures.
  • Error handling procedures.

Upcoming Batches

Start Date End Date Time (EST) ( UTC -5) Day
01 May 2017 19 May 2017 (09:30 PM - 11:00 PM) Mon-Fri
02 May 2017 20 May 2017 (10:00 AM - 11:30 AM) Tue-Sat
05 May 2017 04 Jun 2017 (09:30 PM - 12:00 AM) Fri,Sat
06 May 2017 04 Jun 2017 (09:30 AM - 12:00 PM) Sat,Sun
08 May 2017 25 May 2017 (09:30 PM - 11:00 PM) Mon-Fri
09 May 2017 26 May 2017 (10:00 AM - 11:30 AM) Tue-Sat
12 May 2017 11 Jun 2017 (09:30 PM - 12:00 AM) Fri,Sat
13 May 2017 11 Jun 2017 (09:30 AM - 12:00 PM) Sat,Sun
15 May 2017 01 Jun 2017 (09:30 PM - 11:00 PM) Mon-Fri
16 May 2017 02 Jun 2017 (10:00 AM - 11:30 AM) Tue-Sat
20 May 2017 18 Jun 2017 (09:30 AM - 12:00 PM) Sat,Sun
19 May 2017 18 Jun 2017 (10:00 PM - 12:30 AM) Fri,Sat

ETL Testing Certification

At end of our course, you will be assigned to work a real-time project. Once you completed assigned project with expected results we (Experts Team from GangBoard) will verify and issue ETL Testing Certificate. If you are not able to deliver expected results in project we will support you by clarifying doubts and help you to re-attempt the project.

ETL Testing Training Reviews

FAQ

Detailed installation of required software will be displayed in your LMS. Our support team will help you to setup software if you need assistance. Hardware requirements need to be fulfilled by participants.

No worries. It might happen. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. And if required you can even attend that topic if any other live batches.

Top-notch professionals in that field who understands how to convey things in technical as well as subject matter experts.

We offer this course in “Live Instructor-Led Online Training” mode. Through this way you won’t mess anything in your real-life schedule. You will be shared with live meeting access while your session starts.

Basic Hard ware requirement is useful to install the ETL/Data Warehouse Testing.

You can get a sample class recording to ensure you are in right place. We ensure you will be getting complete worth of your money by assigning a best instructor in that technology.

We are absolutely loved to talk in-person about group training (or) corporate training. So, please get in touch with our team through “Quick Enquiry”, “Live Chat” or “Request Call-back” channels.

Payments can be made using any of the following options and a receipt of the same will be issued to you automatically via email.

  1. Visa Debit Card / Credit Card
  2. American Express
  3. Master Card, Or
  4. PayPal

You can reach us through +91-9791273737 / +91-9791237373. Or you can share your quires through enq@gangboard.com. Estimated turnaround time will be 24 hours for emails.

+91 - 755 008 0081
+91 - 755 008 0082

Drop us a Query

Please ensure all fields are valid.

+91

Drop us a Query

We are looking into your query.
Our consultants will get in touch with you soon.
GangBoard 5 Star Rating: Recommended 5 out of 5 based on 1325 ratings.