Talend Open Studio for Data Integration Training Course

Course Code



28 hours (usually 4 days including breaks)


  • An understanding of relational databases
  • An understanding of data warehousing
  • An understanding of ETL (Extract, Transform, Load) concepts


Talend Open Studio for Data Integration is an open-source data integration product used to combine, convert and update data in various locations across a business.

In this instructor-led, live training, participants will learn how to use the Talend ETL tool to carry out data transformation, data extraction, and connectivity with Hadoop, Hive, and Pig.
By the end of this training, participants will be able to

  • Explain the concepts behind ETL (Extract, Transform, Load) and propagation
  • Define ETL methods and ETL tools to connect with Hadoop
  • Efficiently amass, retrieve, digest, consume, transform and shape big data in accordance to business requirements
  • Upload to and extract large records from Hadoop (optional), Hive (optional), and NoSQL databases


  • Business intelligence professionals
  • Project managers
  • Database professionals
  • SQL Developers
  • ETL Developers
  • Solution architects
  • Data architects
  • Data warehousing professionals
  • System administrators and integrators

Format of the course

  • Part lecture, part discussion, exercises and heavy hands-on practice


  • To request a customized training for this course, please contact us to arrange.

Course Outline


Understanding Data Integration, Data Modeling and Propagation

Setting up Talend Open Studio

Creating a Job in Talend

Carrying Out Basic Transformations

Building a Business Model

Creating Metadata in Talend

Creating and Managing Joins

Carrying Out Advance Transformations

Executing Jobs remotely

Handling Errors in Talend

Connecting Talend with a Database

Querying Data with Hive (optional)

Using Talend with Hadoop (optional)

Using Talend with Pig and Kafka

Using Talend with Web Services

Advanced WSDL Processing

Documenting the Job

Exporting a Job


Summary and Conclusion

Client Testimonials


Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!

Private Classroom

From £5000

Private Remote

From £4400 (95)

Public Classroom

Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
OCUP2 UML 2.5 Certification - Advanced Exam Preparation St Helier, Jersey, Channel Isles Mon, 2018-07-23 09:30 £1980 / £2930
Introduction to R Glasgow Wed, 2018-08-01 09:30 £3861 / £4911
Subversion for Users Newcastle Fri, 2018-08-03 09:30 £1089 / £1289
OCUP2 UML 2.5 Certification - Intermediate Exam Preparation St Helier, Jersey, Channel Isles Tue, 2018-08-07 09:30 £2340 / £3290
jQuery Swansea- Princess House Wed, 2018-08-15 09:30 £1980 / £2280
AWS: A Hands-on Introduction to Cloud Computing Edinburgh Training and Conference Venue Tue, 2018-09-11 09:30 £1287 / £1487
Test Automation with Selenium St Helier, Jersey, Channel Isles Tue, 2018-09-18 09:30 £2970 / £4395

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients