(678) 643-7777
(678) 248-0302

ETL Testing Syllabus

Course Details (PDF)

ETL Testing
From Yes-M Systems LLC

Length: 20-22 Hours Course
Pre-Requisite: SQL [We can teach you SQL along with ETL Testing]

Student Location – To students from around the world
Delivery Method:
Instructor-Led – Live online Training

Contact us for more details:

Company name: Yes-M Systems
Website:
http://myyesm.com,

 Phone numbers (USA):  678-643-7777, 678-248-0302
Phone number (India): 91-8220006968

Kudzu Reviews: http://www.kudzu.com/m/Yes-M-Systems-30363491/reviews/
Facebook:
http://www.facebook.com/yesmsystems
Youtube:
http://www.youtube.com/yesmsystems  

ETL Testing Syllabus

1.    ETL Testing
1.1.    Introduction of ETL-Extract, Transform, Load
1.2.    SQL Concepts
1.3.    OLTP , OLCP, OLAP
1.4.    OLTP vs. OLAP
1.5.    Data Extraction
1.6.    Data Transformation
1.7.    Data Loading
1.8.    Data Marts
1.9.    Dependent Data Mart
1.10.Independent Data Mart
1.11.Data Base Design
1.12.ETL TOOLS and Diff Types of ETL Tools
1.13.ETL ARCHITECTURE
1.14.ETL TESTING AND WHY WE REQUIRE
1.15.DIFFERENT ETL TOOLS ARCHITECTURES
1.16.Roles and Responsibilities
1.17.Minus, Duplicate, Count, Intersection, Except, etc…
1.18.Detect Defects
1.19.Defects Logging and Reporting
1.20.How to prepare Queries to test the ETL process
1.21.Performance Tuning and Performance Testing
1.22.Test plan Preparation
1.23.Test cases Preparation
1.24.Preparation of Test data
1.25.Process Of ETL Testing
1.26.Different Types of ETL Testing
1.27.Testing ETL deployments
1.28.Data Warehousing Concepts
1.28.1.    Data warehouse architecture
1.28.2.    Datamart
1.28.3.    Dimensions, identifying dimensions
1.28.4.    Facts, identifying facts
1.28.5.    SCHEMA
1.28.6.    Star Schema
1.28.7.    Snow Flake Schema
1.28.8.    Types of tables in data warehouse
1.28.9.    Cube and purpose of cube.

About Yes-M Systems:
a.    Established in 2005 (Atlanta, GA, USA), 10th year in business.
b.    A+ accreditation from US Better Business Bureau (http://www.bbb.org/atlanta/business-reviews/internet-consultants/yes-m-systems-in-duluth-ga-27431372)
c.    Received the “Best of 2012” and “Best of 2013” awards from US-based Kudzu (http://www.kudzu.com/m/Yes-M-Systems-30363491/reviews/)
d.    Trained close to 3000+ students from all over the world.
e.    Experienced, passionate and committed trainers
f.    IT Training in various technologies including Java, Dot Net, SAP, Oracle, QA, BA etc (See Courses We offer section for more information)
g.    Professional guidance/help with resumes and interview preparations.
h.    Recruiter help with marketing/jobs
i.    Certification at the end of the training.

Courses we offer:

A.    QA and BA courses:

  • QA [Quality Assurance or QA Testing]
  • BA [Business Analysis or Business Analyst]
  • QA and BA as a single course (Integrated QA+BA) at a reduced fee.
  • Advanced/specialization courses:
    a.   60-hour Selenium course with Core Java
    b.   ETL Testing
    c.   Advanced Mobile Testing
    d.   Advanced QTP
    e.   Any combination of a, b, c, d.
  • Certification QA
    a.   QTP
    b.   ISTQB
    c.   Quality Center
  • Healthcare and Finance specialization
    a.    Healthcare as a Domain Class
    b.    Healthcare BA [Business Analyst with specialization in Healthcare]
    c.    Healthcare QA [Business Analyst with specialization in Healthcare]
    d.    Healthcare QA [Quality Assurance or QA Testing]
    e.    Business analyst with Finance specialization.
    f.    Quality Assurance with Finance specialization

B.    Java courses:
a.   Core Java
b.   Advanced Java
C.   Combination of Core Java and Advanced Java

C.   Healthcare and Finance specialization
a.    Healthcare as a Domain Class
b.    Healthcare BA [Business Analyst with specialization in Healthcare]
c.    Healthcare QA [Business Analyst with specialization in Healthcare]
d    Healthcare QA [Quality Assurance or QA Testing]
e.    Business analyst with Finance specialization.
f.    Quality Assurance with Finance specialization

D.    Microsoft Courses:
a.    Dot Net
b.    Microsoft Business Intelligence [MS BI]
c.    Sharepoint
d.    MS SQL Server

E.    SAP Courses:
a.    SAP FICO
b.    SAP MM
c.    SAP HR
d.    SAP BO
e.    SAP BI
f.    SAP HANA

F.    Oracle Courses:
a.    Oracle Financial
b.    Oracle DBA
c.    PL/SQL

G.    Other Courses:
a.    Hadoop
b.    Hadoop with Java
c.    Salesforce
d.    Project Management (PMP)
e.    Maximo
f.    Tabeau
g.    Informatica
h.    Cognos

 

 

Watch BA Video