Talend Data Integration & Big Data ETL (beginner to expert)

Talend Data Integration & Big Data ETL Tool. GUI, Features, Components, Talend DI, Open Studio, Business Transformation.

What you'll learn
End-to-end training on the modern ETL tool - Talend
DW and ETL concepts
Role of Open Source ETL Technologies in Big Data
Introduction to Talend
TOS (Talend Open Studio) for Data Integration
Architecture, Features, Advantages, Installation, GUI Layout
Read & Write various Types of Source/Target System
How to Transform Your Business with Talend
Advanced components - tMap, tJoin, tFilter, tSortRow, tAggregateRow, tReplicate, tSplit, Lookup, tRowGenerator
Triggers, Row Types, Context Variables, Functions, Job-level/Component-level Information
Type Casting, Looping Components, tFileList, tRunJob
How to schedule and run Talend DI jobs externally
Working with Hierarchical File Structures
Context Variables and Global Variables
Best Practices
Working with files (excel, delimited, JSON, XML etc.)
Working with databases and implementing data warehousing concepts
Orchestration and Controlling Execution Flow
Files - Use components to List, Archive, and Delete Files from a Directory
Database – Controlling Commit and Rollback
Orchestrate several jobs in master jobs
Handling Errors in Talend

Requirements
Enthusiasm and determination to make your mark on the world!

Description
Talend Course Content

1. Role of Open Source ETL Technologies in Big Data

· Overviews on: TOS (Talend Open Studio) for Data Integration

· ETL concepts

· Data warehousing concepts

2. Talend:

· Why Talend?

· Features

· Advantages

· Talend Installation/System Requirements

· GUI layout (designer)

· Understanding it's Basic Features

· Comparison with other market leader tools in ETL domain

· Important areas in Talend Architecture: Project

· Workspace

· Job

· Metadata

· Propagation

· Linking components

3. Talend: Read & Write various Types of Source/Target System

· Data Source Connection

· File as Source

· Create meta data

· Database as source

· Create metadata

· Using MySQL database (create tables, Insert, Update Data from talend)

· Read and write into excel files, into multiple tabs

· View data

· How to capture log and navigate around basic errors

· Role of tLogrow and how it makes developers life easy

4. Talend: How to Transform Your Business: Basic

· Using Advanced components like: tMap, tJoin, tFilter, tSortRow, tAggregateRow, tReplicate, tSplit, Lookup, tRowGenerator

5. Talend: How to Transform Your Business: Advanced 1

· Trigger (types) and Row Types

· Context Variables (paramaterization)

· Functions (basic to advanced functions to transform business rules such as string, date, mathematical etc.)

· Accessing job level / component level information within the job

6. Talend: How to Transform Your Business: Advanced 2

· Type Casting (convert data types among source-target platforms)

· Looping components (like tLoop, tFor)

· tFileList

· tRunJob

· How to schedule and run talend DI jobs externally (not in GUI)

Working with hierarchical file structures

Read and Write an XML file, configure the schema and XPath expression to parse an XML file

Read and Write a JSON file, configure the schema and JSONPath expression to parse a JSON file

Read and write delimited, fixed width files.

Context Variables and global variables

Create context/global variables

Use context/global variables in the configuration of Talend components

Load context variables from a flow

Best practices

Working with databases and implementing data warehousing concepts.

Working with files (excel, delimited, JSON, XML etc.)

Orchestration and controlling execution flow

Files - Use components to list, archive, and delete files from a directory

Database – Controlling Commit and Rollback

COMMIT at end of job/ every x number of rows

Rollback on error.

Shared DB connection across jobs and subjobs

Use triggers to connect components and subJobs.

Orchestrate several jobs in master jobs.

Handling Errors

Kill a Job on a component error

Implement a specific Job execution path on a component error

Configure the log level in the console

Who this course is for:
Talend ETL Application Developers
Talend Application Support Analysts
Anyone aspiring for a career as DW/ETL Specialist
Talend Developers and Engineers
Specialists App Dev - Big data (Talend) - Analytics & Business Intelligence
Newbies and Beginners interested in Data Engineering and modern ETL tools
Data Analysts and Data Consultants
Data Integration Engineers
Data Engineers and Data Scientists
Solution Architects
Data Warehousing / Big Data Professionals
Talend Big Data Developers
Individuals wishing to learn Talend ETL
Strategic Architects
Talend DI Developers
Talend Support Engineers
Talend Developers - Azure/ETL
Data Integration Leads
Talend Architects
Technology Consultants (Talend ETL Developer)

More Info