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


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


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.

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



Related Categories

Related Courses

Course Discounts

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

is growing fast!

We are looking for a good mixture of IT and soft skills in Finland!

As a NobleProg Trainer you will be responsible for:

  • delivering training and consultancy Worldwide
  • preparing training materials
  • creating new courses outlines
  • delivering consultancy
  • quality management

At the moment we are focusing on the following areas:

  • Statistic, Forecasting, Big Data Analysis, Data Mining, Evolution Alogrithm, Natural Language Processing, Machine Learning (recommender system, neural networks .etc...)
  • Hibernate/Spring, Scala, Spark, jBPM, Drools
  • R, Python
  • Mobile Development (iOS, Android)
  • LAMP, Drupal, Mediawiki, Symfony, MEAN, jQuery
  • You need to have patience and ability to explain to non-technical people

To apply, please create your trainer-profile by going to the link below:

Apply now!

This site in other countries/regions