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 to expand our presence in China!

As a Business Development Manager you will:

  • expand business in China
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!