Talend helps you get up and running fast with a full range of robust, open source integration software tools for free download. Begin developing today with a drag-and-drop interface, native code generation, a rich library of connectors, and a thriving user community.

Increase your productivity and speed time to deployment using a graphical UI and hundreds of pre-built components and connectors that generate native code without hand coding. Shift to any integration style using Talend Open Studio with 100% free downloads for batch ETL, big data, real-time, ESB, data profiling, and data assessment.

Who should attend?

  • Anybody looking for better career opportunities in Talend.
  • ETL Engineers
  • Data warehousing professionals
  • Business Intelligence consultants
  • Data Architects
  • Database Developers/Admin

What will be covered?

Talend Introduction

Working with ETL
Rise of Big Data
Role of Open Source ETL Technologies in Big Data
Comparison with other market leader tools in ETL domain
Importance of Talend (Why Talend)
Talend and its Products
Introduction of Talend Open Studio
TOS for Data Integration
GUI of TOS with Demo

Working with Talend Open Studio for DI

Launching Talend Studio
Working with different workspace directories
Working with projects
Creating and executing jobs
Connection types and triggers
Most frequently used Talend components [tJava, tLogRow, tMap]
Read & Write Various Types of Source/Target Systems
Working with files [CSV, XLS]
Working with databases [MySQL DB]
Metadata management
Days of Training

4 Days – 8 Hours/day

Basic Transformations in Talend

Context Variables
Using Talend components
tJoin
tFilter
tSortRow
tAggregateRow
tReplicate
tSplit
Lookup
tRowGenerator
Accessing job level/ component level information within the job
SubJob (using tRunJob, tPreJob, tPostJob)

Advance Transformations and Executing Jobs remotely in Talend

Various components of file management (like tFileList, tFileAchive, tFileTouch, tFileDelete)
Error Handling [tWarn, tDie]
Type Casting (convert datatypes among source-target platforms)
Looping components (like tLoop, tForeach)
Using FTP components (like tFTPFileList, tFTPFileExists, tFTPGet, tFTPPut)
Exporting and Importing Talend jobs
How to schedule and run Talend DI jobs externally (using Command line)
Parameterizing a Talend job from command line
Trainers Profile

Karthikeyan Jaganathan,

Business Intelligence/Analytics Expert

Managing Partner, IntellyticsHub Technology Corp LLP.

Mr.Karthikeyan Jaganathan got 8+ years of experience as Business Intelligence & Analytics consultant who served as key architect in deriving BI solutions for various projects such as Social Media Analytics project where in successfully built a pilot Data Warehouse/BI Application for a large Entertainment client in Palo Alto, California, USA. He had implemented a cutting edge BI solution with robust, scalable and completely reusable design for a Bigdata Analytics platform which executes on Banking Recommendation engine system. A Microsoft Certified SQL expert and a Certified BI Engineer.

His area of expertise is in Business Intelligence, Analytics (R Programming, Excel, and SQL), BigData (HDFS, Hive, Impala, SQOOP and Spark), Data Integration (Talend, SSIS) & Data reporting (Tableau, Power BI) tools and building reusable and highly configurable automation frameworks.

Karthikeyan holds a Bachelor of Engineering in Computer Science and Engineering from Anna University (India).