TALEND
Course Overview
Taking Talend training from Nandini Software Solutions will help you to develop the skills required for ingesting Data into your Data Centers. In this course, you”ll learn Talend Open Studio for Data Integration and this course will cover in-depth concepts of data extraction, Pig, connectivity with Hadoop, HDFS, data transformation, Hive, and an ecosystem like MapReduce. Our curriculum is designed by industry experts based on real-time scenarios.
Highlights
· 30 Hrs Instructor Led Training
· Self-paced Videos
· 20 Hrs Project & Exercises
· Certification
· Job Assistance
· Flexible Schedule
· Lifetime Free Upgrade
· Mentor Support
What are the Talend training course objectives
By the end of the Talend training, you will be able to:
· 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 and retrieve files using FTP
· Define ETL methods and ETL tools to connect with Hadoop
· Work on a project of importing MySQL data using Sqoop and querying it using Hive
Why should you learn Talend course?
· There are numerous opportunities for skilled Talend developers and administrators worldwide.
· Top multinational companies are hiring certified Talend professionals around the globe.
· The average salary of a certified Talend professional is around $1,37,000 USD per annum.
Who should attend Talend training?
· Business analysts
· Data Warehousing professionals
· Data analysts
· Solution and Data architects
· System administrators
· Software engineers
· Aspirants who are willing to build their career in the administrative field.
Talend Course Content
1. Talend Topics
- Talend software installation
- Datawarehousing and ETL Consepts
- SQL
2. Talend Components
- tFilterRow
- tFilterColumns
- tAggregateRow
- tAggregateSortedRow
- tSortRow
- tUnite
- tUniqRow
- tReplicate
- tJoin
- tMap(Most Important Component )
- tSampleRow
- tReplace
- tNormalize,
- tDenormalize
- tExtractDelimitedFields
- tRowGenerator
- tConvertType
- tPivotToColumnsDelimited
- tSchemaComplianceCheck
- tSplitRow
- tPrejob
- tPostjob
- tSendMail
- tJava
- tJaveRow
- tJavaFlex
- Note(Annotations) ,Rename Links and Component Names
- tLoop
- tSleep
- tInfiniteLoop
- tSystem
- tSSH
- tFixedFlowInput
- tLogCatcher
- tStatCatcher
- tDie
- Nbline
- tFlowMeter
- tFlowMeterCatcher
- tLogRow
- tBufferInput and tBufferOutPut
- tHashInput and tHashOutPut
3. tFile Input and OutPut Components
- tFileInputDelimited
- tFileInputExcel
- tFileInputXML
- tFileInputJSON
- tFileOutputDelimited,
- tFileOutputExcel
- tFileOutputXML
- tAdvancedFileOutputXml
- tXMLMap
- tFileOutputJSON,
- tFileList(Most Importatent)
- tFileInputPositional,
- tFileOutputPositional
- tFileRowCount
- tFileProperties
- tFileTouch
- tFileCopy
- tFileDelete
- tFileArchive
- tFileUnarchive
- tFileExist
- tMsgBox
- tWaitForFile
4. Database input and out put Components
- tOracleInput(Othe Databases like Msql,SQL Server,DB2 , Hive,Salesfource ,AWS,Servicenow,Amzon Redshift )
- tOracleOutput
- tOracleConnection
- tOracleClose
- tOracleSCD
- tOracleCommit
- tOracleRow
- tOracleSP
- tOracleRollback
- tOracleOutputBulkExec,
- tOracleOutputBulk,
- tOracleBulkExec
- tTeradataInput
- tTeradataOutput
- tTeradataConnection
- tTeradataClose
- tS3Connection
- tS3Close
- tS3List
- tS3Put
- tS3Get
- tS3Delete
- tS3Copy
5.RedShift
- tRedShiftInput
- tRedShiftOutput
- tRedShiftConnection
- tRedShiftClose
- tRedShiftRollback
- tRedShiftCommit
- tRedShiftRow
6.Aurora
- tAmazonAuroraConnection
- tAmazonAuroraClose
- tAmazonAuroraInput
- tAmazonAuroraOutput
- tAmazonAuroraCommit
- tAmazonAuroraRollback
7. Slowly Changing Dimensions
- Type1, Type2 and Type3 by using SCD component
- Type1, Type2 and Type3 with out using SCD component
- Delta or Incremental load with out Contorl Table
- Delta or Incremental load with Contorl Table
- tcontextload(Paramaters)
- tContextDump
Routines
8.Parent And Chaild Jobs Execition process
tRunJob
9.FTP Components
- tFTPGet, tFTPPut,tFTPFileList, tFTPRename, tFTPTruncate, tFTPDelete, tFTPFileExist, tFTPFileProperties and tFTPConnection.
- Import and Export items and Pull and Merge ,Push options by using GIT
- Build job (deployment )
- How to Generate the talend document
- how to run the talend job with out talend open studio
- HOW to scheule the jobs By Using TAC and with out using TAC and other third party tools(i.e Automic,Control M,Airflow and Crontab)
- tFlowToIterate and tIterateToFlow
- Real time Senarios ,Interview Questions and Answers & Performance Techniques with Realtime
- Project Explanation etc
- Mock Interviews