Telend for Data Integration and Bigdata

Talend For Data Integration and Big Data Solutions Architect Training

OL Tech Edu Talend Training for Data Integration and Big Data will help you in learning how to use Talend Open Studio to simplify Big Data Integration. After this Talend Training, you can easily work with Apache Hadoop, Apache Spark, Apache Hive, Apache Pig, and NoSQL Databases using Talend. Talend Open Studio accelerates the task development process with its drag-and-drop UI and pre-built components for Data Offloading and Ingesting Data into your Data Centers.

Sports, Citrix, UST Global, Mindtree, TCS, Wipro, Infosys & other MNC's use Azure across industries.

Microsoft Aims for $20 Billion Cloud Sales Run Rate in 2018 - Satya Nadella, CEO.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Talend For Data Integration And Bigdata UpComing Batches

Nov-29 - Jan-10

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Nov-22 - Jan-03

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-11 - Jan-22

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-18 - Jan-29

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-25 - Feb-05

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Jan-01 - Feb-12

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

Talend For Data Integration and Big data

SELF PACED

OL Tech Edu Talend Training for Data Integration and Big Data will help you in learning how to use Talend Open Studio to simplify Big Data Integration. After this Talend Training, you can easily work with Apache Hadoop, Apache Spark, Apache Hive, Apache Pig, and NoSQL Databases using Talend. Talend Open Studio accelerates the task development process with its drag-and-drop UI and pre-built components for Data Offloading and Ingesting Data into your Data Centers.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
Telend Training For Data Integration And Bigdata

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. 

Skills:
  • Core ETL Concepts.
  • Talend Products and their Features.
  • Design and Implementation of Talend Open Studio.

Topics:
  • 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.

Hands-on/Demo:
  • Creating a Basic Job.

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. 

Skills:
  • Create Jobs with Different Components and Link them.
  • Read and Write Files of Various Format.
  • Work with Database.

Topics:
  • 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.

Hands-on/Demo/Use-case:
  • 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.

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. 

Skills:
  • Create and use Context Variables.
  • Mapping and Transformations.
  • Work with components like tFilter, tJoin, tSortRow, tReplicate, tSplit, Lookup.

Topics:
  • 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).

Hands-on/Demo/Use-case:
  • 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).

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. 

Skills:
  • 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.

Topics:
  • 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.

Hands-on/Demo/Use-case:
  • 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.


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. 

Skills:
  • 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.

Topics:
  • 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.

Hands-on/Demo/Use-case:
  • Creating a Project and a Job.
  • Adding Components in a Job.
  • Connecting to HDFS.
  • 'Putting' Files on HDFS.
  • Using tMap, tAggregate Functions.


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. 

Skills:
  • Integrate Hive with TOS Big Data.
  • Perform Complex Hive Queries in Talend.

Topics:
  • 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.

Hands-on/Demo/Use-case:
  • 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.


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. 

Skills:
  • 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.


Topics:
  • Pig Environment in Talend.
  • Pig Data Connectors.
  • Integrate Personalized Pig Code into a Talend Job.
  • Apache Kafka.
  • Kafka Components in TOS for Big Data.

Hands-on/Demo/Use-case:
  • Use Pig and Kafka Connectors 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.


Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Course Description

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses

© 2015 - 2021 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers