CertAchiever

Talend for Data Integration and Big data

contact us: +918882136965

Instructor-led live online classes

Weekday Classes | Weekend Classes |

Talend for Data Integration and Big data

$296

Talend for Data Integration and Big data

Designed to meet the industry benchmarks, Edureka’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

Training Features

Instructor-led Sessions

Both Weekdays and Weekend batches are available.

Real-Life Case Studies

During the sessions you will be working on the case studies provided by the trainer.

Lifetime Access

You will get the life time access of training material including videos & study guides..

Assignments

Each class will be followed by practical assignments to practice the concepts covered in class

24 x 7 Expert Support

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

Certification

Towards the end of the course, you will be awarded with Training competition certification based on you performance.

Course Curriculum

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 Covered

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

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 Covered

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

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 Covered

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

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 Covered

Use various components of file 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

Hands On

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 Covered

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

Hands On

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 EnvironmentCreating a Project and a Job, 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 Covered

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

Hands On

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 TalendProcess and transform data from Hive, 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 Covered

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

Hands On

Pig Environment in Talend, Pig Data Connectors, Integrate Personalized Pig Code into a Talend job, Apache Kafka, Kafka Components in TOS for Big dataUse Pig and Kafka connectors in Talend, 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.

Topics Covered

FAQ's

You will never miss a lecture at CertAchiever! You can choose either of the two options:

View the recorded session of the class available in your LMS.

·You can attend the missed session, in any other live batch."

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 the class.

You can give us a CALL at +918882136965 (IN) OR email at admin@certachiever.com

Certification

Once your training will complete, you will be awarded with training completion certification from the Trainer.