Learn ETL Testing With Informatica PowerCenter Today
4.4 (69 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,302 students enrolled

Learn ETL Testing With Informatica PowerCenter Today

Learn ETL testing now. Step-by-step software testing with relevant exercises. Learn now and get your promotion!
4.4 (69 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,302 students enrolled
Last updated 4/2018
English
English [Auto-generated]
Current price: $132.99 Original price: $189.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn ETL testing and get a promotion/new job
  • Data warehousing Concepts
  • Normalization of data
  • ETL process with some transformations
  • ETL testing process with test scenarios
  • How to test the scenarios with examples
  • What issues can impact the data quality of data in a data warehouse
  • Much more...
Course content
Expand all 13 lectures 02:05:48
+ SQL
1 lecture 20:57
SQL brief introduction
20:57
+ ETL Testing
4 lectures 31:20
Types of ETL testing
10:19
Types of ETL Bugs
09:41
ETL test scenarios and test cases
05:58
+ ETL Test scenarios in detail
4 lectures 31:26
Metadata testing
06:06
Data Quality
12:38
Data completeness
06:11
+ Conclusion
2 lectures 05:52
Conclusion
05:44
Bonus Lecture: Course discounts & newsletter
00:08
Requirements
  • Student should have hands on experience and knowledge to SQL
  • Student should be familiar with data warehousing concepts and ETL tool
  • Software required: Oracle SQL-Developer (free) & Informatica PowerCenter
Description

COURSE OBJECTIVE
The Primary objective of this course to make you familiar with ETL testing concepts.

The course starts with data warehousing concepts, as that is required before you start testing the data in data warehouse. 

You should be well versed is SQL (RDBMS query language), hence this tutorial has a brief introduction to SQL and normalization to structure data in a database.

You will learn how to test the loaded data by ETL process after transformations. After you finish the tutorial, you can start creating a set of test cases for your ETL mapping and build your own queries to execute them.

All sections of the course will have relevant exercises for you to do, so you can practice your new skills. 


WHAT IS ETL TESTING?
ETL stands for Extract-Transform-Load. It is a process of loading data from the source system to the data warehouse.
ETL testing is done to ensure that the data loaded from the source system to a data warehouse (after transformations), is accurate.


TOP 3 BENEFITS OF LEARNING ETL TESTING

  1.  ETL testing professionals are in high demand in the market. Tools like Informatica PowerCenter, IBM Infosphere Information Server, Oracle data Integrator,etc. are in huge demand in the Industry and there is no sign of this trend should stop growing anytime soon.
  2. ETL testing Jobs are generally well payed and include many benefits.
  3. Learning ETL testing will improve your data analytical skills. 


FREQUENTLY ASKED QUESTIONS 

Is it easy to get a job in ETL testing?
I would say it is "easy". But if you have the right knowledge (like this course) and SQL experience, it should not be much of a problem to get a good ETL testing job in various companies. The future of ETL Testing is very bright. There will always be a need to store data for analysis, for any organizations that has large amount of transactions.

What skills are required before I opt for ETL testing?
ETL is all about playing with large data in database. You must have good knowledge of database structured query language (SQL), and knowledge of data warehousing concepts. A short refresher to SQL will be given in the course.


GUARANTEE

If within 30 days of buying the course you decide that it's not for you, please get a Udemy-backed refund. No questions asked — just press the refund button, and all of your money will be returned to your credit card.  


ARE YOU READY TO LEARN ETL TESTING?

Please press the "Take This Course" button and start learning 2 minutes from now!

Who this course is for:
  • Beginners who want to get job on ETL Testing quickly
  • IT professionals with very basic knowledge on Database concepts
  • Developers that wants a increased salary
  • Project Managers, Database Professionals, Mainframe Professionals, SQL Developers