Talend for Data Integration and Big data


Talend for Data Integration and Big data

Designed to meet the industry benchmarks, CertAdda’s Talend online training for Big Data is curated by top industry experts. This Talend certification course is created to help you learn how to use Talend Open Studio to simplify Big Data Integration. This Talend Big Data certification is live, instructor-led & helps you master key Talend concepts, with hands-on demonstrations. This Talend course is fully immersive where you can learn and interact with the instructor and your peers. Enroll now in this Talend online course & be a certified Talend professional with CertAdda.


Instructor-led Talend for Data Integration and Big data live online classes





Sep 11th SAT & SUN (5 WEEKS) Weekend Batch SOLD OUT Timings – 08:30 PM to 11:30 PM (IST)
Oct 30th SAT & SUN (5 WEEKS) Weekend Batch ⚡FILLING FAST Timings – 07:00 AM to 10:00 AM (IST)
Dec 18th SAT & SUN (5 WEEKS) Weekend Batch Timings – 08:30 PM to 11:30 PM (IST)

Talend – A Revolution in Big Data

Learning Objectives: In this module of Talend Training, you will get an overview of ETL Technologies and the reason why Talend is referred as the next Generation Leader in Big Data Integration. You will be introduced to various products offered by Talend Corporation till date and its relevance to Data Integration and Big Data. Further, you will learn about the TOS (Talend Open Studio), its Architecture, GUI, and how to install TOS. After completing this module you shall learn:

  • Core ETL concepts
  • Talend products and their features
  • Design and implementation of Talend Open Studio


  • 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

Learning Objectives: In this module of Talend course, you will learn to work with various types of Data Source, Target Systems supported by Talend, Metadata and how to read/write from popular CSV/Delimited file and fixed width file. Connect to a Database and read/write/update data and read complex source system like Excel and XML along with some of the basic components like tLog, tMap using TOS. After completing this module you shall learn:

  • Create jobs with different components and link them
  • Read and write files of various format
  • Work with Database


  • 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, XML, Positional]
  • Working with databases [MySQL DB]
  • Metadata management


  • Creating a Business Model
  • Adding Components to a Job
  • Connecting the Components
  • Reading and writing Delimited File
  • Reading and writing Positional File
  • Reading and writing XML and Xls/Xlsx Files
  • Connecting Database(MySQL)
  • Retrieving Schema from the Database
  • Reading from Database Metadata
  • Retrieving data from a file and inserting it into the Database
  • Deleting data from Database
  • Working with Logs and Error

Basic Transformations in Talend

Learning Objectives: In this module of Talend Training, you will understand Data Mapping and Transformations using TOS. In addition, you will learn how to filter and join various Data Sources using lookups and search and sort through them. After completing this module you shall learn:

  • Create and use context variables
  • Mapping and Transformations
  • Work with components like tFilter, tJoin, tSortRow, tReplicate, tSplit, Lookup


  • 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)


  • Embedding Context Variables
  • Adding different environments
  • Data Mapping using tMap
  • Using functions in Talend
  • tJava
  • tSortRow
  • tAggregateRow
  • tReplicate
  • tFilter
  • tSplit
  • tRowGenerator
  • Perform Lookup operations using tJoin
  • Creating SubJob (using tRunJob, tPreJob, tPostJob)

Advance Transformations and Executing Jobs remotely in Talend

Learning Objectives: In this module of Talend Certification, you will understand the Transformation and various steps involved in looping job of Talend, ways to search files in a directory and how to process them in a sequence. You will also learn to work with FTP connections, export and import Jobs, run the jobs remotely and parameterize them from the command line. After completing this module you shall learn:

  • Use various file components like tFileList, tFileCopy, tFileExists, tFileDelete, tFileArchive
  • Handle logs and errors
  • Cast data types using tConvert and tMap expression builder
  • Iterate components using tLoop
  • Store and retrieve files from FTP
  • Remotely access 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


  • Implementing File Management (like tFileList, tFileAchive, tFileTouch, tFileDelete)
  • Type Casting {tConvert and tMap(using Expression Builder)}
  • Looping components (like tLoop, tForeach)
  • Using FTP components (like tFTPFileList, tFTPFileExists, tFTPGet, tFTPPut)
  • Exporting and Importing Talend Jobs
  • Parameterizing a Talend Job from command line

Big Data and Hadoop with Talend

Learning Objectives: In this module of Talend Training, you will learn about Big Data and Hadoop concepts, such as HDFS (Hadoop Distributed File System) Architecture, MapReduce, leveraging Big Data through Talend and Talend & Big Data Integration. Learn to set up and use the Talend Open Studio for Big Data. In addition, you will learn to use Big Data connectors in TOS (Talend offers some 800+ connectors for Big Data environment) and access Hadoop Ecosystem from Talend. After completing this module you shall learn:

  • Understand scope of Talend Open Studio for Big Data
  • Integrate Hadoop HDFS and Talend
  • Use Hadoop operations like Map and Aggregate through TOS Big Data
  • Perform multiple analyses and store results in HDFS


  • Big Data and Hadoop
  • HDFS and MapReduce
  • Benefits of using Talend with Big Data
  • Integration of Talend with Big Data
  • HDFS commands Vs Talend HDFS utility
  • Big Data setup using Hortonworks Sandbox in your personal computer
  • Explaining the TOS for Big Data Environment


  • Creating a Project and a Job
  • Adding Components in a Job
  • Connecting to HDFS
  • ‘Putting’ files on HDFS
  • Using tMap, tAggregate functions

Hive in Talend

Learning Objectives: In this module of Talend Certification Training, you will learn Hive concepts and the setup of Hive environment in Talend. You will learn how to use Hive Big Data connectors in TOS and implement Use Cases using Hive in Talend. After completing this module you shall learn:

  • Integrate Hive with TOS Big Data
  • Perform complex Hive queries in Talend


  • Hive and It’s Architecture
  • Connecting to Hive Shell
  • Set connection to Hive database using Talend
  • Create Hive Managed and external tables through Talend
  • Load and Process Hive data using Talend
  • Transform data from Hive using Talend


  • Process and transform data from Hive
  • Load data from HDFS & Local File Systems to Hive Table using Hive Shell
  • Execute the HiveQL query using Talend

Pig and Kafka in Talend

Learning Objectives: In this module of Talend course, you will learn the PIG concepts, the setup of Pig Environment in Talend and Pig Big Data connectors in TOS for Big Data and implement Use Cases using Pig in Talend. Also, you will be given an insight of Apache Kafka, its architecture, and integration with Talend through a real-life use case. After completing this module you shall learn:

  • Integrate Talend projects with Pig and Kafka
  • Use Pig for scripting and Kafka for streaming jobs in TOS Big Data
  • Use TOS Big Data for running Pig and Kafka along with DI, Hadoop HDFS, and Hive


  • Pig Environment in Talend
  • Pig Data Connectors
  • Integrate Personalized Pig Code into a Talend job
  • Apache Kafka
  • Kafka Components in TOS for Big data


  • Use Pig and Kafka connectors in Talend

End to End Project in Talend

Learning Objectives: In this module of Talend Training, you will be developing a Project using Talend DI and Talend BD with MySQL, Hadoop, HDFS, Hive, Pig, and Kafka.

About Talend Training

CertAdda’s Talend Training is designed to help you master Talend and Big Data Integration using Talend Open Studio. It is a free open source ETL tool using which you can easily integrate all your data with your Data Warehouse and Applications or synchronize data between systems. You’ll also use Talend ETL tool with HDFS, Pig, and Hive on real-life case studies.

What are the objectives of our Talend Training Course?

Talend Training for Data Integration and Big Data is designed by industry experts to make you a Certified Talend Practitioner. This Talend Certification Training course offers:

  • Complete understanding of the ETL concepts and ability to solve the real-time business problems using Talend
  • Comprehensive knowledge of Talend Architecture and its various Components
  • Familiarity with Talend Tool to automate your complete Data Integration/ Data Analysis/ Data Warehousing requirements
  • Interaction with various types of source or target platform like Flat Files (CSV, Fixed width), XML, Excel and work with Databases
  • Implementation of the real-time scenarios for Data Transformation, File & Error Handling, Scheduling Talend jobs, Automation/Parameterization
  • Understanding of Big Data and Hadoop concepts and the benefits of integrating Talend with Hadoop
  • Easy integration and Access to Hadoop Ecosystem using Talend
  • Implementation of Talend with HDFS, Pig, and Hive (the most demanded and futuristic skills)
  • Rigorous involvement of an SME throughout the Talend Training to learn industry standards and best practices

Why should you go for Talend Training?

Talend is one of the first providers of open source Data Integration Software. Talend provides specialized support for Big Data Integration. By using Talend, no coding effort is required for implementing Big Data Solution. This can be designed using drag-and-drop controls and native code is generated automatically. Talend is built in such a way that it is flexible to reside between any of the data sources and platforms out there. Having a solutions portfolio that includes Data Integration, Data Quality, Master Data Management, Enterprise Service Bus, and Business Process Management, there is everything you need here to make your data work for you.

What are the skills that you will be learning with our Talend Training?

Talend Certification training will help you to become a Talend expert. It will polish your skills by offering you comprehensive knowledge of ETL Processes and Big Data integration with Talend, and the required hands-on experience for solving real-time industry-based data integration and big data projects. During Talend Certification Training Course at CertAdda, you will be trained by our expert instructors, so you can:

  • Master the Core ETL concepts
  • Understand various Talend products and their features
  • Design and implement jobs/tasks in Talend Open Studio
  • Work with different source files, target files, and databases
  • Perform Mapping and Transformation of data
  • Learn File Management and Error & Log Handling
  • Store & Retrieve Files using FTP
  • Remotely Access and Parameterize a Job using Talend
  • Understand the scope of Talend in Big Data
  • Integrate HDFS, Hive, Pig, and Kafka with Talend
  • Perform complex Hive queries and store data in HDFS
  • Use Pig for Scripting and Kafka for Streaming jobs from Talend
  • Solve Real Life Project on Data Integration and Big Data using Talend

Who should go for this Talend Training Course?

The market for Big Data is growing across the world and use of Talend makes it easier to communicate with Big Data. This strong growth pattern opens up a great opportunity for all the IT Professionals. Our Talend Certification Training will help you to grab this opportunity and accelerate your career. It is best suited for:

  • Business Analysts
  • Data Warehousing Professionals
  • Data Analysts
  • Solution & Data Architects
  • System Administrators
  • Software Engineers

What are the pre-requisites for CertAdda Talend Training Course?

There are no prerequisites for learning Talend course in general. However, having knowledge of Data Warehousing will be beneficial, but certainly not a mandate. To brush up/ learn Data Warehousing concepts CertAdda offers you a complimentary self-paced course, i.e. “Data Warehousing Certification Training” when you enroll in Talend Certification course.

What are the system requirements for this Talend Training?

Basic system configurations required to execute the practicals involved in CertAdda’s Talend Certification are given below:

  • Hardware:
    • RAM: 8 GB
    • HDD: 50 GB
    • Processor: Core i3 or higher
  • Software:
    • CentOS/ Windows
    • Talend Open Studio for Data Integration
    • Talend Open Studio for Big Data
    • MySQL Database

How will I execute projects in this Talend Training Course?

CertAdda Talend Certification team will provide a VM with all the required software pre-installed in it. An installation guide will be provided in the LMS, which will contain step by step execution along with the screenshots.

Which projects are included in CertAdda Talend Training Course?

CertAdda Talend Certification includes multiple real-life, industry-based projects, which will hone your skills as per current industry standards and prepare you for the upcoming Talend roles & jobs. Talend Certification Course includes 12 case studies, few of which are given below:

  • Project #1: Installing Talend
    Problem Statement: Install Talend Open Studio for Big Data (which also comprises Data Integration) and create the first Project.
  • Project #2: Tally the salaries of the employees of an organization
    Domain: IT
    Problem statement: An XYZ organization pays their employees on a monthly basis. The salary of each of its employees is tallied in an XML file for each month. But now the management wants to upgrade their salary tally software. Using Talend Open Studio develop a job to fulfill their requirements.
  • Project #3: Capture and Process the Trips Data
    Domain: Travel
    Problem statement: In this project, you will play the role of MIS reports developer using Talend with specialization in building workflows for processing data. You will be dealing with Taxi Trips data which need to capture. This data is structured data with 1-year trips information. Use Talend to capture and process this transaction data.
  • Project #4: Retrieve and Synchronize Data From FTP
    Domain: Health-Care
    Problem statement: There is a requirement from a medical agency where they always need to have up to date data. Few of their files are on the FTP server which you need to fetch and store on the local server. As you will be retrieving the files on a daily basis, you will have to synchronize their data with the database tables using Talend Open Studio.
  • Project #5: Calculate and analyze the performance of different offices
    Domain: Retail
    Problem statement: Imagine your organization has offices in multiple locations spread across different countries. You are the lead Data Analyst and are required to show reports of Performance of every office, country and even region wise(continent). You have received some of these files through the mail which you have downloaded onto your local file system. The rest of files are present on Hadoop HDFS which you have to access using Talend Open Studio.
  • Project #6: Analyse the customer transaction data of Walmart
    Domain: Retail
    Problem statement: Companies like Walmart, with more than billions of transactions per day, and spread across 40+ countries, are taming Big Data with technologies like Talend. Here, we will use Talend Open Studio for Big Data to perform analysis on the various customer Transactions data.
  • Project #7: Analyse and stream the transaction data
    Domain: Retail
    Problem statement: In this project, you will play the role of PIG ETL developer using Talend with specialization in building Data Flow components using Pig. The Data you will be dealing with is ‘Transactions Data’ captured for a Retail Giant. You have to make use of Talend to analyze the structured data which has three years of weekly transaction information.
  • Project #8: Perform Log Analysis
    Domain: Retail
    Problem statement: In this project, you have to play the role of a Talend developer. Using Talend and various Big Data Components you have to build ETL and big data processing pipelines. The data you will be working is unstructured web server logs. Using Talend Open Studio, you have to load this data into Talend and use its components to do pre-process data and analyze it.
  • Certification Project:
    As part of this Talend Training, you will also get an opportunity to work on a real-life end to end Project that tests the skills that you have acquired through this Talend Certification. The Project will also give you an insight on how Talend can be implemented in work environment.

How will Talend Training help your career?

The below predictions will help you in understanding the current position and future growth of Talend:

  • Talend has more than 1300 enterprise customers including Citi, GE Healthcare, Virgin Mobile, Groupon, Deutsche Post
  • Gartner has reported ‘Talend as a Leader in Data Integration’ in the 2017 “Magic Quadrant for Data Integration Tools” – Business Wire
  • Average salary of Talend Software Architect is $137k – Indeed.com

The increasing interest of IT market in Big Data has resulted in higher demand for jobs in this field. If you are interested in pursuing your career in this field, you must go for Talend course. Using Talend you can easily set up the communication with Big Data technologies without writing a single piece of code.

What if I miss a class?

You will never miss a lecture at CertAdda You can choose either of the two options: View the recorded session of the class available in your LMS or You can attend the missed session, in any other live batch.

Will I get placement assistance?

To help you in this endeavor, we have added a resume builder tool in your LMS. Now, you will be able to create a winning resume in just 3 easy steps. You will have unlimited access to use these templates across different roles and designations. All you need to do is, log in to your LMS and click on the “create your resume” option.

Can I attend a demo session before enrollment?

We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in a class.

Who are the instructors?

All the instructors at CertAdda are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by CertAdda for providing an awesome learning experience to the participants.

What if I have more queries?

Just give us a CALL at +91 8178510474 / +91 9967920486 OR email at admin@certadda.com