Talend Data Integration using ETL Concepts
Apply ETL concepts using Talend
Description
This course is meant for anyone who wants to know how to deliver ETL solutions using Talend. Maybe you’re an IT manager looking for a cost-efficient ETL solution, an IT professional looking to broaden your skill set, or a BI or data warehouse consultant responsible for developing ETL solutions in your organization. Maybe you’re a software developer with a lot of experience building open source solutions but still new to the world of data integration. And maybe you’re already an experienced ETL developer with deep knowledge of one or more of the existing proprietary tools. In any case, I assume you have a hands-on mentality because this is a hands-on course. I do expect some familiarity with using computers to deliver information, installing software, and working with databases, but most of the topics will be explained right from the start. Of course, the data integration concepts are explained as well, but the primary focus is on how to transform these concepts into a working solution. That is exactly why the course is called Talend ETL Solutions.
This course will teach you:
What data integration is, and why you need it
How to install and configure Talend
How to build a complete end-to-end ETL solution for the MySQL Sakila demo database
What the 34 subsystems of ETL are and how they translate to the Talend toolkit
How Talend can be used for data extraction, cleansing and conforming, handling dimension tables, loading fact tables
What the Talend development lifecycle looks like
How to schedule and monitor jobs and transformations
How to work with multiple developers and manage different versions of an ETL solution
What data lineage, impact analysis, and auditing is, and how Talend supports these concepts
How to increase the performance and throughput of Talend using partitioning, parallelization
How to use complex files, web services
How to integrate Talend with other solutions
AND MORE .....
What You Will Learn!
- What data integration is, and why you need it
- The concepts that form the foundation of the Talend Data Integration
- How to build a complete end-to-end ETL solution with a Project
- What the 34 subsystems of ETL are and how they translate to the Talend Modules
- What the Talend development lifecycle looks like
- How Talend can be used for data extraction, cleansing and conforming, handling dimension tables, loading fact tables, and working with OLAP cubes
- How to schedule and monitor jobs in Talend
- How to work with multiple developers and manage different versions of an ETL solution
- How to increase the performance and throughput of Talend using partitioning, parallelization
Who Should Attend!
- Anyone who wants to know how to deliver ETL solutions using Talend.
- If you are an IT manager looking for a cost efficient ETL Solution.
- If you are an IT professional looking to broaden your skill set.
- If you are a BI or Data warehouse consultant responsible for developing ETL Solutions in your organization.
- If you are a software developer with a lot of experience building open source solutions but still new to the world of data integration.
- If you are already an experienced ETL developer with deep knowledge of one or more of the existing proprietary tools.