Talend Data Integration ETL Tool
Talend Data Integration Training
The Talend DI Training offers a Job Ready Comprehensive Program.
Talend + SQL + Datawarehouse
3 Real World Projects ( Datawarehouse + Data Lake + Data migration )
Resume preparation + Mock Interview Practice + Dedicated Mentor Placement Guidance .
* Add On : Free Snowflake Training for interested candidates.Free Business Communication Training ( Project Demos, Client Interactions,KT and Email Etiquette)
Dedicated 1:1 Mentor for each individual with Offline/Online Doubt clarification and working sessions until you get placed.
Internship with work experience and Internal Job Facility.
Unlike the traditional learning, you will have the opportunity to collaborate with experienced professionals from Day 1.
Daily Mock Interviews with working professionals.
Upcoming Batch
Enroll up in the upcoming batch for a flexible learning schedule.
Accelerate your career with learning from Established Faculty who are pioneers in the industry. Build your skills and power ahead in your career with dedicated support to solve your queries.
| Batch | Batch_35 -Training + Real World |
| Date | JUL 21 2025 |
| Timings | 8 : 00 AM |
| Course fee: |
25,000 INR FOR NRI |
Demo Link : https://youtu.be/f2_ZIY5IelE
Zoom Link : https://us06web.zoom.us/j/89864539660?pwd=oqs389vVZXsT4h8RTu3oPvHd64aUSs.1
New Batch Whats App Group Link : https://whatsapp.com/channel/0029VbAIvN0FSAt8VFq1ao3f
Course Content
- Introduction about Me and the Course
- What is ETL? What are the advantages of Talend etl tools?
A quick tour of Prerequisite open source software — Java, Talend, PostgreSQL, Notepad++ needed to complete training.
Quick Tips for best learning and use of course
- Repository, Designer, Palette, Outline, Configuration tab
- Creating your first job, Java behind Talend
Exporting/Importing talend job
- Extracting data from File Excel – tFileInputExcel
- Extracting data from File delimited – tFileInputDelimited
- Extracting data from File delimited/Excel using Metadata
- Assignment
- Installation of PostgreSQL and Dbeaver
- Basics of SQL – Create, drop, insert, truncate delete records into the table
- Basics of SQL – Delete, Alter, Update, Commit, Rollback
- Extracting data from DB table/using Metadata – tDBInput
- Assignment
- Processing component – tFilterRow
- Using SQL – Where clause
- tFilterColumn
- tSortRow and Using SQL – Order by clause
- Assignment
- Load the data into File, Excel – tFileOutputDelimited, tFileOutputExcel
- Load the data into Table – tDBOutput
- Assignment
- Connection Links
- tFileList
- tFileCopy, tFileDelete
- tFileArchive, tFileUnarchive
- tFileCompare, tFileRowCount, tFileProperties
- tChangeFileEncoding, tFileTouch
- Assignment
- tMap basics
- tMap advance
- tMap Join
- SQL – Joins
- tJoin
- tReplace,tConvertType
- SQL- Replace, Typecasting
- tAggregateRow, tAggregateRowSorted
- SQL – Aggregate Functions
- tNormalize, tDenormalize
- tSampleRow
- Assignment
- tDBOutputBulk, tDBBulkExec, tDBOutputBulkExec
- tDBRow
- Assignment
- tLoop
- tForEach
- tInfiniteLoop, tSleep, tFileExist
- tUnite, tReplicate
- tWaitForFile
- tWaitForSQLData
- tFlowToIterate,tIterateToFlow
- tRunjob, tPrejob, tPostjob
- Assignment
- tJava
- tJavaRow
- tJavaFlex
- tSetGlobalVar
- tSystem
- Assignment
- Explanation with job – tContextLoad, Implicit tContextLoad, tContextDump
- Assignment
- Note, tRowGenerator, tFixedFlowInput
- tMsgBox
- tBufferInput, tBufferOutput
- tHashInput, tHashOutput
- tFlowMeter, tFlowMeterCatcher
- tMemoriseRow
- Assignment
- Creation of AWS account and Access Key, Secret Key
- tS3Close, tS3Connection, tS3Copy, tS3Delete, tS3Get, tS3List, tS3Put
- Assignment
- SQL String and Date functions
- Window functions
- Assignment
- DWH – Datawareshouse, Data mart
- DWH – Schema, Keys
- DWH – Dimension, Fact
- SCD1
- SCD2
Introduction to TMC, Deployment and Scheduling of jobs.
Hands On Implementation of 3 Real World Projects ( Datawarehouse + Data Lake + Data migration ) .
Resume preparation + Mock Interview Practice + Dedicated Mentor Placement Guidance .
- Free Business Communication Training ( Project Demos, Client Interactions,KT and Email Etiquette)
Testimonials
Talend Training Features
Instructor-led Sessions
30 Hours of Online Live Instructor-Led Classes.
Real-World Project
After completion of Training, you will be working on a Real-world project gathering information about various case studies
Assignments
Each class will be followed by relevant practical assignments .
Personalized Mentorship
Every student at TTS gets a 1:1 dedicated mentor who are industry experts who will guide you and provide insights from their extensive experience.
Internship
This stage help you Bridge the gap between training and real world project experience providing invaluable hands-on experience.
Placement
We offer an exclusive internal job facility, complete with salary paychecks to kickstart your
FAQs
The new batch commence on the first week of every month.
The courses include training on Talend ETL Tool,Snowflake,Azure, Python, Pyspark, SQL and Databricks
- The course duration is about 60 days.
- Flexible .
Recording of every day session will be available immediately after the session is ended.
Yes , Please refer to contact information for more details.
Hands on Implementation of 5 real world projects are included as part of training.
–> Data Warehousing project : Talend Enterprise/Open Studio, Snowflake, AWS, TMC, GIT
–> Data Lake project : Talend Enterprise, any DB(Snowflake, Postgres), Salesforce, GIT, TMC
–> Data Migration project : Talend Enterprise, any DB(Snowflake, Postgres), Salesforce, GIT, TMC
–> Many more(Data Ingestion, Data Integration, etc) to follow.
For better hands on experience , learners will be given few assignments to complete before attending next day session.
No prerequisite coding knowledge required.