Your Subtitle text


Home > Training > ETL Design, Development and Implementation

Related Course Name
1 Data Warehouse Architecture and lifecycle
2 Data Modeling Design and Process
3 ETL Mapping Design and Development
4 PL/SQL Development
5 Master Data Management Foundation
6 BI Architecture and Design
7 Database Administration
8 Business System Analysis

Welcome to Free Courses
Data Warehouse Foundation (Apr.5 Sat 10-12pm)
Data Moderling Foundation (Apr.5 Sat 2-4pm)
Master Data Management (Apr.6 Sun 10-12pm)
Business System Analysis (Apr.6 Sun 10-12pm)
Book Online
Book call  : 647-980-2288
Book email
Free Special Offers
Career assessment ( 1 hour)
Resume modification (1 hour)
Interview mockup (1 hour)
Referal to our valuable clients (TBD)
Make appointment Online
Make appointment call : 647-980-2288
Appointment email
Market Trends
Data Governance: What "Right" Looks Like
The Qualified Data Modeler
BI And Analytics
Why We Need System And Technology Models

ETL Mapping Design and Development


You Will Learn

l          The relationship between Data Warehouse and ETL (Extraction, Transformation and Loading).

l          How to achieve data movement from across many different sources to Data Warehouse.

l          ETL mapping design process and procedure.

l          ETL development and implementation for DW project.

l          ETL technologies and popular tools.

Course Benefits

ETL is a very important component of Data Warehouse, ETL enables organizations to extract, transform and load data from different sources to different layers of a Data Warehouse to create consistent, accurate information.

ETL specialist is a high demanded position in data management, data warehousing, BI industry.


Who Should Attend?

Anyone wants to involve in analysis, designing, building and implementing Data Warehouse and Business Intelligence solutions or projects.


Hot positions in the market will be: Data Warehouse Consultant, BI Consultant, Data Architects, DW/BI designer, Data Modelers, ETL specialists, BI specialist, Data Warehouse specialist, Business System Analyst, project manager, team lead, IT managers.


Course Content


Module 1: Data Warehouse and ETL Foundation

  • The relationship between Data Warehouse and ETL (Extraction, Transformation and Loading).
  • The difference between logical and physical data movement.
  • How to achieve data movement from across many different sources to Data Warehouse.
  • ETL technologies and popular tools.

Module 2: ETL Mapping Design Process and Procedure


  • Business and System requirement analysis
  • Meta data creation and maintenance
  • Data mapping Design and Implementation
  • Extraction Design and implementation
  • Pre loading Design and implementation
  • Transformation Design and implementation
  • Error handling and notification


Module 3: ETL development and implementation Case Study and Tools


  • Real financial DW/BI project ETL mapping design.
  • ETL technologies and popular tools in the market
  • Informatica etc ETL tool introduction and practice.



Length: 9 Hours (3 hours * 3 times)

Date/Time: Wednesday 7pm - 10pm or Sunday 9am – 12pm

Location: RC DataTech Training center, Toronto



Total: $298 (including tax)

Hotlines: 647-975-2008 Help Mailbox:  

Career Development Chain

                                              You are here                                 

  What is  your  goal                    
  What is Market needs
  Where are you now
  Why is data focus
  How to achieve
  Professional Skills                    
  The DWBI Industry knowledge
  Real Project Experience
  One on One workshop
  Phone/In-person    interview skills                 
  Real interview scenarios
  Best Q&As
 Market Hot Positions                    
 Reference provided
 Good client relationship
 Full time/Contract
 Multiple locations
 Competitive packages