Who should attend
- Data Warehousing Professionals, Analysts and Programmers
- Business Analysts and BI Developers
- Solution Architects and Data Architects
- System Administrators and Integrators
- Those aspiring to be Data Scientists
What are the prerequisites for learning Talend?
Anybody looking for better career opportunities can take up this Talend training course. A basic understanding of SQL can help.
About the course
Talend training from Intellipaat will help you master data integration using Talend Open Studio. This online Talend ETL tool course will cover in-depth concepts of data transformation, data extraction, connectivity with Hadoop and ecosystem like MapReduce, Hive, Pig and HDFS. You will work on real-life projects and prepare yourself for Talend Data Integration Certified Developer exam.
About Talend Online Training Course
In this Talend training, you will learn Talend Open Studio that is a 360-degree solution for ETL. Talend is built as a powerful open-source tool. You can get a detailed understanding of various features and benefits of working on the Talend platform. This will also improve your Big Data skills.
What will you learn in this Talend certification training?
- Talend, Talend Open Studio and its uses
- Data integration, data modeling and concept of propagation
- Defining how to aggregate data and T Map and its properties
- Using format data functions and XML file in Talend and importing/creating metadata
- Implementing real-time use cases of Talend
- Defining ETL methods and ETL tools to connect with Hadoop
- Working on a project of importing MySQL data using Sqoop and querying it using Hive
- Preparing for the Talend Data Integration Certified Developer exam
Why should you take up Talend training course?
- 83% Of Enterprise Workloads will be In the Cloud in the next 2 years
- 845 new companies are using Talend in the last 12 months – HG Data
- The average US salary for a Talend Professional is $110,000 – indeed.com
Talend Open Studio is a powerful open-source tool for ETL and data integration that is being adopted by a huge number of companies. This Talend training will give you the right set of skills to take up the most valuable jobs in the market today. You will also be fully trained to take the Talend certification exam.
Talend Course Content
- Data Modeling Concepts
Understanding the basics of Data Modeling, its significance and how to deploy Data Modeling in Data Warehouse environment.
- Deep Dive into Data Modeling
The various types of Data Modeling, learning to perform Conceptual Data Modeling, Physical Data Modeling, Logical Data Modeling, understanding the scope and benefits of Data Modeling.
- Multidimensional Data Modeling
The basic Architecture of multidimensional modeling, deploying Cubes to perform multidimensional modeling, understanding the concepts of Facts and Dimensions and the differences between the two.
- Introduction to Talend
The Talend Open Source data integration tool, working with Big Data, understanding the Talend Open Studio.
- Talend Installation
Understanding the installation of Talend, system requirements, troubleshooting of common errors and issues related to installation.
- Talend Key Features
Learning about the Talend Architecture, important concepts and features, Talend components like Job, Workspace, Metadata, Project, etc.
- Talend Job Creation
Learning to create a Talend Job, working with Delimited file, working with Meta Data, schema for data integration, understanding Propagation, deploying of tFilterRow and string filter for creating Jobs, creation of CSV file.
- Data Management Techniques
Deploying Talend Open Studio for Data Management, data quality, integration, understanding the ETL and Data Warehousing concepts.
- Schema & Data Aggregation
Detailed understanding of Talend Job design, it features, learning about tMap, data aggregation techniques, tReplicate for performing different operations on a Schema, tMap for mapping input and output data.
- DataSource Connection
Working with DataSource Connection, deploying in database component, creating a connection, database source and target, metadata and schema importing.
- Talend Routines/Functions
Introduction to Talend Functions, calling and deploying the Functions, understanding Routines, Talend Open Studio for XML data processing, date format function.
- Data Transformation
Transforming Data, Running the Job, Combining Columns, Duplicating a Job
- Working with Metadata
Creating Metadata, Joining Data Sources.
- Data Corrections
Capturing Rejects, Correcting the Lookup, Duplicating a Job
- Data Filtering
Filtering Output Data, Using Multiple Filters.
- Context Variables
Using Context Variables from Talend Job, Repository as Metadata.
- Graphical Interface of Talend
Building Jobs, Graphical Jobs, Graphical Interface Of Talend, Talend’s Components Naming Convention
Row – Main Connection, Row – Iterate Connection, Trigger – On sub Job ok Connection, Trigger – On Component OK Connection
- File Management
File Management in Talend
- Connecting Talend with Hadoop
Deploying Talend to work with Hadoop, defining the ETL method, Hive implementation with Talend, importing data in Hive, Hive partitioning, Pig in Talend, data loading and parallel data execution.
What projects I will be working on this Talend training?
Project : Creating Jobs using Metadata and using transformation steps
Industry : General
Problem Statement : How to create a Talend job using metadata
Topics : This project is involved with deploying metadata for creating a Talend job. You will be extracting data from multiple data sources like delimited, XML, MS Excel, database and transform the data based on logics provided and loading the data to data warehouse.
- Extracting data from various types of data sources
- Database Connection with different databases
- Talend Job Creation.
This Talend training course is designed for clearing the Talend Data Integration Certified Developer exam. The entire course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in top MNCs.
As part of this training, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast-track your career effortlessly.
At the end of this training program, there will be a quiz that perfectly reflects the type of questions asked in the certification exam and helps you score better marks.
Intellipaat Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 60% marks in the quiz. Intellipaat certification is well recognized in top MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.
Videos and materials
Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.
We are happy to help you find a suitable online alternative.