Home  |  About Us  |  Careers |  Resources  |  Client List  |  Sitemap  |  Contact Us

Call: 416-623-9493 or 905-497-8717

Toll Free: 1-866-955-4526
E-mail: info@globalerp.ca

Software Quality Assurance Training Business Analysis Training SAP Training BI Development Microsoft BI Training PMP Training Tableau Training Informatica Training JAVA Training MICROSOFT .NET Training Power BI Training Big Data & Hadoop Training Scrum Training DevOps Training Cyber Security ORACLE Admin Training

ETL Testing
  DURATION   20 Hrs
  Course Fee   $980 + HST
  • Classroom Instructor-led training (CILT)
  • Online Instructor-led training ( OILT)


 ETL Concepts


  • Data warehousing and Business intelligence
  •  The Dimensional Model
  •  Oracle OLAP
  •  Data warehouses and data marts
  •  Data warehouse development approaches and terminology
  •  Business, Logical, Dimensional and Physical Modeling
  •  The ETL Process: Extracting the data
  •  Extraction Methods
  •  Change Data Capture
  •  Possible ETL failures
  •  Maintaining ETL quality
  •  The ETL Process: Transforming the data
  •  Transformation and available staging models
  •  Identifying and eliminating data anomalies
  •  Importance of the quality data
  •  Transformation: Problems and Solutions
  •  MERGE and multiple INSERT SQL statement in Transformation
  •  The ETL Process: Loading the data
  •  Transportation in a Data warehouse
  •  Data refresh models
  •  Data Granularity
  •  Post processing of the Loaded data
  •  Steps for verifying the data integrity
  •  Standard quality assurance checks.



Test Process Implementation


  • Introduction to Software Testing and Quality
  •  Software Life Cycle Stages
  •  Software Development Models
  •  ETL Testing Techniques  –  Static Testing , Dynamic Testing , Black Box Testing, White Box Testing
  •  Software Quality Assurance Standards – CMMI Model and  SIX SIGMA
  •  Test Planning, Test Design and Test Execution
  •  Test measurement Techniques and Metrics Collection
  •  Defect Management
  •  Defect Severities and Priorities
  •  Defect management and defect resolution process
  •  User Acceptance Testing
  •  Testing Terminologies



Backend Testing using SQL ( Structured Query Language)

  • Introduction to Database and Rational Database Management  System
  •  DML Commands – ( Insert, Select, Update , Delete)
  •  DDL Commands- ( Create, Use, Alter, Drop)
  •  Sub queries ,Joins and Unions
  •  Simple and Complex SQL- queries
  •  Other DB Utilities Toad, SQL Navigator etc
  •  Database role in application development



Fundamentals of Unix Operating system

  •  UNIX- Operating System
  • Flavors of UNIX and difference between them
  • Environment Variables in Unix
  • How to install Application in Unix
  • what is  .profile and Env variable files and how to modify them MAN Page world
  • Understanding  scripts in Unix
  • File systems and Space management
  • Understanding of compiling code using MAKE file




Brampton:199 Advance Blvd, Suite: 201
..................Brampton, ON, L6T 4N2

Toronto:5635 Yonge St. Unit 210
..................North York (Finch Subway) ON M2M 3S9

Phone: 416-623-9493 or 905-487-4500
E-mail: training@globalerp.ca