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   register@rcdatatech.com
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      career@rcdatatech.com
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/Data/Time/Location

Length: 9 Hours (3 hours * 3 times)

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

Location: RC DataTech Training center, Toronto

 

Tuition

Total: $298 (including tax)


Hotlines: 647-975-2008 Help Mailbox: info@rcdatatech.com  

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
  Confidence
  Competitive
 
  Professional                 
  Customized
  Reliable
  Confident
  Impressive
  One on One workshop
  Phone/In-person    interview skills                 
  Real interview scenarios
  Best Q&As
  Tips
 
 Market Hot Positions                    
 Reference provided
 Good client relationship
 Full time/Contract
 Multiple locations
 Competitive packages