JupiterR Synergetic Solutions JupiterR
 Synergetic
 Solutions

Sahi Pro  Authorised Reseller
               &
    Training Partner





     JupiterR Synergetic Solution's Workshop On

BI (ETL / Data Warehouse) Testing

5 Days Duration
 
Program Overview & Benefits

Managing a business in today's dynamic world has never been easy. The challenge is to do more with less and to make better decisions than competitors. Having constant access to current, actionable information has become need of time. The best decisions are made when all the relevant data is available and the best possible source for that data is a well-designed data warehouse.

A data warehouse is a database that is specifically designed to produce information for reporting and analysis. "Reporting and analysis" can be anything from listings of sales figures, to hi-tech dashboards, email alerts, ad-hoc reporting and drill-up, drill-down analytics. Data is extracted periodically from the applications that support business processes and copied onto special dedicated computers. There it can be validated, reformatted, reorganized, summarized, restructured, and supplemented with data from other sources. The resulting data warehouse becomes the main source of information for report generation, analysis, and presentation through ad-hoc reports and dashboards.

 
Program Objectives
At the end of the ETL Testing workshop, you will be able to:
  • understand data warehouse structures and architectures
  • implement a successful process for data warehouse testing
  • create basic queries to return data from a database
  • create queries to join data from multiple tables
  • utilize different filtering commands to narrow data results
  • make use of different aggregate SQL functions
  • manipulate and format data returned from queries
Suggested Audience
  • Manual Testers
  • Automation Engineers
  • Quality Assurance Analysts
  • Developers
  • Project Managers
  • anyone involved with providing software quality for data warehouses
Pre-Requisites
  • Knowledge of Manual Testing
  • Knowledge of SQL
Program Contents
  • 1. Data Warehousing Concepts
    • Data Warehouse Concepts, Design.
    • Need of Data Warehouse.
    • Introduction to OLTP, ETL and OLAP Systems.
    • Data Warehousing Architecture.
    • Dimensional Modeling.
    • Data Marts and ODS.
    • Star Schema and Snowflake Schema.
    • SCD (slowly changing dimension).
    • Types of Fact and Dimension Tables.
  • 2. SQL Concepts
    • Introduction to Oracle.
    • Basic Concepts in SQL.
    • Data Types.
    • Select statement usage.
    • Joins.
    • Sub Queries.
    • Performance Tuning Tips & Tricks.
  • 3. ETL Testing - Introduction
    • Introduction to ETL.
    • ETL Architecture.
    • What is the use of testing?
    • What is quality & standards?
    • Responsibilities of ETL Tester.
    • Sub Queries.
    • Performance Tuning Tips & Tricks.
 
  • 4. ETL Testing - Procedure
    • Steps in DWH Testing
    • Prerequisites of DWH Testing.
    • Levels of DWH Testing
    • The Data Warehousing process
    • Coverage of ETL Testing
    • How DWH Testing is Different from Application Testing?
    • Challenges in DWH Testing
  • 5. Testing Methodologies.
    • ETL Testing WorkFlow Process.
    • How to Prepare the ETL Test Plan.
    • How to design the Testcases in ETLTesting.
    • How to report the Bugs in ETL Testing.
    • ETL Testing Responsibilities.
    • How to detect the bugs through database queries.
    • ETL Performance Testing
  • 6. BO and Reports
    • Overview
    • Reports Testing Process
    • Components of BO Testing
  • 7. Query and tools
    • Informatica, Datastage, Cognos etc.
  • 8. Conclusion
Registration & Contact Details
Registration Fees: Contact Us
(Includes Veg Lunch, Coffee/Tea, Training Materials)

Note:
100% Advance payment is required to confirm the seat. Payment can be made through Cheque/DD in favour of "JupiterR Synergetic Solutions", payable at Bangalore.
Discounts Scheme
  • 5% Discount for early Bird Registrations
    (15 Days in advance of the program date)
  • 5% Discount on Task Force of 4 to 7
  • 10% Discount on Task Force of 8 and above
Note:
Only one discount is applicable at a time.
JupiterR Synergetic Solutions
2nd Stage, BTM Layout, Bangalore - 560076, INDIA
Website: www.JSSinfotech.com
Email: info@JSSinfotech.com

Contact: Ravi
Hand Phone: 09535 555779

Get in Touch jssinfotech jssinfotech

Data Warehouse / BI / ETL Testing Corporate Training Course and Workshop in Bangalore, Mysore, Mumbai, Pune, Hyderabad, Chennai, Kolkata, Noida, Delhi, Gurgoan, Coimbatore, NCR, Nagpur, Chandigarh, Indore, Ahmedabad, Vadodara, Surat, Cochin, Thailand, South Africa, Malaysia, Singapore, Philippines,,donesia, Australia, Brunei, Kuwait, Mexico, China, Egypt, Jordon, UAE, Nepal, Sri Lanka, Bangladesh, Maldives, Luxembourg, Qatar, Kenya, Oman, Saudi Arabia, Macau, Hong Kong, Kuala Lumpur, Dubai, Colombo, Nigeria, Johannesburg, Bangkok, Manila, Jakarta, Japan, Cambodia, Bahrain, Abu Dhabi, Muscat, Lagos, Durban, Nairobi, Mauritius, Dhaka, Kathmandu, United Arab Emirates, Bhutan, Laos, Turkey, Istanbul, Russia, Moscow, Myanmar, Rangoon, South Korea, New Zealand, Wellington, Mongolia, Kazakhstan, Uzbekistan, Riyadh, Tokyo, Pretoria, Cape Town, Sydney, Canberra, Austria, Vienna, Melbourne, Bandar Seri Begawan, Amman, Male, Abuja, Phnom Penh, Manama, Port Louis, Turkmenistan, Doha, Data Warehouse Testing Trainers in India