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

Dec-21 - Feb-01

Weekend
SOLD OUT

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

350.00     Enroll Now

Dec-14 - Jan-25

Weekday
SOLD OUT

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

350.00     Enroll Now

Dec-21 - Feb-01

Weekend
FILLING FAST

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

350.00     Enroll Now

Dec-28 - Feb-08

Weekday
FILLING FAST

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

350.00     Enroll Now

Jan-04 - Feb-15

Weekend

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

350.00     Enroll Now

Jan-11 - Feb-22

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

DOWNLOAD BROCHURE

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.

Curriculum

Course Description

About The Course
About Talend Training OL Tech Edu'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.
Objectives Of Our Online PySpark Training Course
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.
Go For Online Spark Training
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 and best practice.
Learning With Our PySpark Certification Training
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 OL Tech Edu, 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 Talent.
Who Should Go For Our PySpark Training Course
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.
Who Should Go For Our PySpark Training Course
What are the pre-requisites for OL Tech Edu 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 OL Tech Edu offers you a complimentary self-paced course, i.e. "Data Warehousing Certification Training" when you enroll in Talend Certification course.

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
Top Courses
Stands by you all the way to ensure that you achieve your learning goals.

Top Courses

Partner Courses

Certifications

HELP & SUPPORT

Connect With Us

Get In Touch     Address: 5th Floor(Tower B), A-40, Ithum Tower Sector - 62, Noida Uttar Pradesh   Phone: +91-9654136060   Email: info@oltechedu.com  

© 2015 - 2024 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