Easy way to IT Job

ETL Testing Course Syllabus

4.90
(5142)

Our ETL Testing Course Syllabus gives the learners an in-depth knowledge on emphasizing analysis of data, cleaning bad data in the source system, creating multiple tests for data validation, finding an ETL tool that supports the data sources, monitoring ETL jobs, and dealing with a full scale of ETL Testing. In our ETL Syllabus, students learn how to test data transfers to ensure accuracy from the source to the destination after a business transaction. Enroll in our ETL Testing Training Institute in Chennai.

DURATION
Real-Time Location Services
2 Months
JOB READY
Syllabus
CERTIFIED
Courses

Let's take the first step to becoming an expert in ETL Testing

Click Here to Get Started

100% Placement
Assurance

What Learning at SLA gives you

  • Technology Training
  • Aptitude Training
  • Learn to Code (Codeathon)
  • Real Time Projects
  • Learn to Crack Interviews
  • Panel Mock Interview
  • Unlimited Interviews
  • Life Long Placement Support

Breakdown of ETL Testing Course Fee and Batches

Hands On Training
3-5 Real Time Projects
60-100 Practical Assignments
3+ Assessments / Mock Interviews
June 2024
Week days
(Mon-Fri)
Online/Offline

2 Hours Real Time Interactive Technical Training 

1 Hour Aptitude 

1 Hour Communication & Soft Skills

(Suitable for Fresh Jobseekers / Non IT to IT transition)

Course Fee
June 2024
Week ends
(Sat-Sun)
Online/Offline

4 Hours Real Time Interactive Technical Training

(Suitable for working IT Professionals)

Course Fee

Save up to 20% in your Course Fee on our Job Seeker Course Series

Learn More

Syllabus for The ETL Testing Course

Download Syllabus
Module 1 : DWH Data Ware Housing Concepts

1

  • 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
Module 2 : ETL Testing

2

  • 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)
Module 3 : Challenges in DWH ETL Testing compare to other testing

2

  • 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
Module 4 : ETL Testing Work flow activities involved

4

  • 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
Module 5 : Types of ETL Testing

5

  • 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
Module 6 : Different ETL tools available in the market

6

  • Informatica
  • Ab Initio
  • IBM Data stage
Module 7 : Power Center Components

7

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Power Center Admin Console
Module 8 : Informatica Concepts and Overview

8

  • Informatica Architecture
Module 9 : Sources

9

  • Working with relational Sources
  • Working with Flat Files
Module 10 : Targets

10

  • Working with Relational Targets
  • Working with Flat file Targets
Module 11 : Transformations – Active and Passive Transformations

11

  • 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
Module 12 : Workflow Manger

12

  • Creating Reusable tasks
  • Workflows, Worklets & Sessions
  • Tasks
  • 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
Module 13 : Performance Tuning

13

  • 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

Want more details about the ETL Testing Syllabus?

Fill out the form, and our counsellors will get in touch with you at your preferred time. You can have all your queries answered. Once you decide that SLA is the perfect fit for your training needs, our counselors will guide you through the process every step of the way.

Course Schedules

PDF Course Syllabus

Course Fees

CRM System Testing

or any other questions...

The SLA way to Become
a ETL Testing Expert

Enrollment

Technology Training

Coding Practices
Realtime Projects

Placement Training

Aptitude Training
Interview Skills
CRM System Testing

Panel Mock
Interview

Unlimited
Interviews

Interview
Feedback

100%
IT Career

Google Reviews

Rating
4.8
1,053 Google reviews

Hari Krishnan

I am from Mechanical background. I have no command over programming before joining SLA Such a wonderful place to learn and achieve your goals.Having wonderful…
Click here for Full Review

Ganesan Vasu

I'm from non-IT background, but always wanted to be in IT, SLA make my dream true and I don't know how many will see this…
Click here for Full Review

Venkatesh

I joined SLA for python course one year back, and i got selected as software developer with decent salary, with after one year of experience,…
Click here for Full Review

Aswin Pandiyan

It's my genuine review i searched many institutes to do software testing course and finally landed in SLA. My counselor Bala backed me and my…
Click here for Full Review

Discover What Our Students Have To Say

See More Reviews

Our counselors will share the Syllabus PDF with you via Email / Whatsapp

Just a minute!

If you have any questions that you did not find answers for, our counsellors are here to answer them. You can get all your queries answered before deciding to join SLA and move your career forward.

We are excited to get started with you

Give us your information and we will arange for a free call (at your convenience) with one of our counsellors. You can get all your queries answered before deciding to join SLA and move your career forward.