ETL Testing 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.
ETL Testing Training Projects
The practical projects that you will work on during this certification training include
- Knowledge of business intelligence and data warehousing principles
- Learn more about Data Warehouse Workflow and how Database Testing and Data Warehouse Testing compare.
- Utilize SQL to perform data checks, and be aware of the BI Testing’s limitations.
- Recognize many ETL Testing scenarios, including Dependency Testing, Business Rules Testing, Source to Target Testing, and Constraint Testing.
- Learn about QA Lifecycle, ETL Testing, and RDBMS Concepts.
- The average salary of an ETL Tester in India is 4.92 lakhs per annum! – glassdoor.co.in
- There are 15,000 ETL Tester job openings in India, according to LinkedIn and Naukri.
- ETL Tools like IBM Infosphere Information Server, Informatica Power Center, Oracle data Integrator, Microsoft SSIS have in huge demand in the Industry.
- The practical sessions throughout the course will help you in reinforcing your technical skills.
- It is curated by working professionals with the changing requirements of the ETL Testing profession.
- The assignments will further help reinforce your knowledge about ETL Testing and varied Data Warehousing scenarios. All of those will allow you to become an Industry-Ready Professional proficient in handling the bulk of real-world situations.
- Healthcare project will be explained in Class and other documentation for Telecom
- Banking, Insurance related data will be provided
ETL TESTING COURSE CURRICULUM
- 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
- BIEE
- BI Test cases
- Data validation with OBIEE
- UI Testing with OBIEE
- Different Tools
- SQL Developer
- Informatica PowerCenter Client Tools
- OBIEE Reporting Tool