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,
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).