Tel: +1 (713) 570-9633
Email: info@corptechit.com
UI/Web Professional IT Training CenterBuilding World Class IT Professional Online TrainingOwn your future learning new skills online

UI/Web Professional IT Training Center

CorptechIT has fast become one of the most sought after disciplines by companies today

Read More

Building World Class IT Professional Online Training

For the skilled manpower in high end technology courses like SAP, SAP-MM, SAP-WM, SAP-SRM, SAP-PP, SAP-SD, SAP-FICO, SAP-APO, SAP-BW/BI,SAP HANA and ERP domains.

Read More

Own your future learning new skills online

CorptechIT is all the more effective as it is very flexible and convenient and can be undertaken at any time even by working professionals.

Read More

ETL TESTING

CorptechIT provides Online Training by experienced IT professionals. Our faculties dedicated to complete your course as per the schedule given. We record the classes from your end to refer the classes once again whenever is required. ETL Testing Online Training being a really important module, we have taken precise steps in teaching a full-fledged ETL Testing Online Training course curriculum that covers all the concepts. Our customer support team and trainers will solve all your queries as and when required. ETL Testing Online Training has got the right training that can fulfill a candidate’s training expectations. We see to that the value and quality of our ETL Testing Online Training will not be compromised at all. We will market your resume in USA, UK, SINGAPORE, NEWZELAND, CANADA, AUSTRALIA, JAPAN, SWEDEN, SOUTH AFRICA. We clarify your questions during the training even after the course completion. After completion of training we will help you to assist you to get certified on ETL Testing . We will give you 100% Satisfaction.

ETL Testing Online Training Course Content

Prerequisites

  • Software Testing Life Cycle
  • Software Development Life Cycle
  • Manual Testing Experience is Plus
  • Usage of HP quality Center
  • Defect Life Cycle

Data warehousing Concepts

  • What is Data Ware House?
  • Difference between OLTP and Data warehousing

Data Acquisition

  • Data Extraction
  • Data Transformation
  • Data loading

DataBase Design

  • Star Schema
  • Snow Flake Schema

SCD (slowly changing dimension)

  • Type-1 SCD
  • Type-2 SCD
  • Type-3 SCD

Basic Concepts in SQL in Oracle

  • SELECT
  • Single Row Functions
  • Aggregate Functions
  • JOINS
  • SUBQUERYS
  • SET Operators
  • Analytical Functions
  • DDL, DML, Views (High level Concepts)

Different Types of Testing Techniques in ETL

  • Minus querying
  • Count Querying

ETL Testing Concepts

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 design the Test cases in ETL Testing.
  • How to reporting the Bugs in ETL Testing?
  • ETL Testing Responsibilities
  • How to detect the bugs through database queries
  • ETL Performing Testing & Performing Tuning

Documentation for ETL Testing Projects

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
  • SCD 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
-->