Talend Open Studio and Admin in Hyderabad

Talend Open Studio and Admin

LIVE

40 Hours

Course offered by Mahesh

0 review

Prerequisites: Basic knowledge of computing, including familiarity with Java or another programming language, SQL, and general database concepts.

Talend Studio for Data Integration dramatically improves the efficiency of data integration Job design through an easy-to-use graphical development environment. With integrated connectors to source and target systems, it enables rapid deployment and reduces maintenance costs. It supports all types of data integration, migration, and synchronization.

This course helps you use Talend Studio for Data Integration as quickly as possible. It focuses on the basic capabilities of Studio and how you can use it to build reliable, maintainable data integration tasks that solve practical problems, including extracting data from common database and file formats, transforming it, and integrating it into targets.

In the course we will also cover how to publish , deploy and schedule Talend jobs by using Talend Administrator console , Crontab and Task Scheduler.

* Real time scenarios with tMap , tAggregatedRow, tJoin, tUniqueRow, tJavaRow,tJava.

* Logs and Error components like tLogCatcher , tWarn, tDie and etc..

* Database connection , read and write component like tOracleConnection, tOracleInput, tOracleOutput and etc..

* Context load components.

* Files read and write components like tFileInputDelimited,tFileOutputDelimited,tFileCopy and etc.

* Create user and assign roles.

* Create Projects and reference projects in TAC.

* Create TASK in jobconductor.

* Monitoring Talend jobs by using AMC.

About the Trainer

Avg Rating

0 Reviews

0 Students

2 Courses

Mahesh

MCA

8 Years of Experience

- 10+ years Data Warehouse/Analytics product development experience covering all phases of SDLC including Requirements, Design, Development, Testing and Final Release using Agile Methodology.
- Over 8+ years of experience in building Data marts using ETL development tools like using Ab Initio, GDE, BRE and Data Profiler.
- Over 4+ years of experience in Expertise on Talend Data Integration suite and Talend Bigdata Integration Suite for Design and development of ETL/Bigdata code and Mappings for Enterprise DWH ETL Talend Projects.
- Experienced on major Hadoop ecosystem's projects such as Pig, Hive, Hbase, HDFS and monitoring them with Cloudera Manager.
- Highly capable in dealing with data migration activity for huge applications for multiple hubs (source systems) using Talend Big data Integration Suite.
- Developed complex Talend ETL job to load the data from file to HDFS, HDFS to Hive, Hive to Oracle and Oracle to Data mart.
- Experience in Talend implementation and administration. Solid ETL knowledge on Talend Administration Center, implementing time & event based schedule, performance tuning and troubleshooting.
- Comprehensive knowledge with Infrastructure Setup, Environments Control, Data Modeling, ETL process, QA test cases, and Business Intelligence in Data Warehouse and BI projects.
- Good understanding of Data Modeling and Design for large applications for faster, effective and optimum performance of the application.
- Strong skill in Oracle including SQL, PL/SQL, UNIX Commands and shell scripting and Core Java concepts
- Over 2+ years of experience in development of Mainframe Applications using COBOL, DB2, JCL, VSAM and ISPF.
- Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning and Large Volume Data Loads.
- Involved in creating and enhancing operational and technical policies and procedures, adopting best practice guidelines, standards and procedures.
- Used Both Pipeline Parallelism and Partition Parallelism for improving performance.
- Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
- Strong knowledge in Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, TPump, SQL Assistant)
- Experience in all Testing Phases: Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
- Strong skills in analysis database designing, Coding using SQL and PL/SQL, Developing, Writing, Unix Shell Scripts and code/script testing. Coded Stored Procedures, Packages and Triggers using PL/SQL.
- Strong experience in mentoring offshore teams and very much flexible to work additional hours as needed basis to meet project deadlines with offshore teams.