نبذة عني
5+Years of Experience in Information Technology as a Talend ETL Developer. Good and Strong knowledge in Informatic PowerDesigner, Repository Manager, Workflow Designer, and Workflow Manager, IICS ETL (Talend) Development…
5+Years of Experience in Information Technology as a Talend ETL Developer. Good and Strong knowledge in Informatic PowerDesigner, Repository Manager, Workflow Designer, and Workflow Manager, IICS ETL (Talend) Development, Talend Data Integration, Jira, Confluence, ServiceNow, SQL Server, SSIS, Agile. Working on the multiple projects comprises Talend DI and its associated technologies. Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files (.txt, XML, Excel, JSON, FIXED width, CSV) and databases like oracle. Expertise in creating mappings in Talend using tMap, tJoin, tReplicate, tParallelize, tConvertType, tNormalize, tDenormalize, tSetGlobalVar, tParallelize, tHashInput, tHashOutput, tJava, tJavarow, tAggregateRow, tWarn, tFilterRow, tDie etc. Expert in using Logs & Error Components - tDie, tLogCatcher, tStatCatcher, tLogRow. Experience in implementing SCD Type-1, Type-2 and Type-3 Dimensional tables. Created context variable to store metadata information of all the sources and targets. Experience in Debugging, Error Handling and Performance Tuning of sources, targets, Jobs etc. Performed various activities like import and export of Talend Jobs & Projects. Experience on Requirement gathering, analysis and designed mapping documents. Good and Strong knowledge in data warehouse concepts like star schema, Snowflake, Dimension and Fact tables. Develop and implement strategies for performance tuning. Experience in analyzing the business requirements and creating ETL jobs. Worked on TOS and Talend Enterprise Edition. Team player with good communication and interpersonal skills and has ability to quickly adopt, master and utilize new technology.
الخبرة
Etl Developer
5+Years of Experience in Information Technology as a Talend ETL Developer.
Working on the multiple projects comprises Talend DI and its associated technologies.
Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files (.txt, XML, Excel, JSON, FIXED width, CSV) and databases like oracle.
Expertise in creating mappings in Talend using tMap, tJoin, tReplicate, tParallelize, tConvertType, tflowtoIterate, tAggregate, tSortRow, tRowGenerator, tNormalize, tDenormalize, tSetGlobalVar, tParallelize, tHashInput, tHashOutput, tJava, tJavarow, tAggregateRow,tWarn, tFilterRow, tDie etc.
Expert in using Logs & Error Components - tDie, tLogCatcher, tStatCatcher, tLogRow.
Experience in implementing SCD Type-1, Type-2 and Type-3 Dimensional tables.
Created context variable to store metadata information of all the sources and targets.
Experience in Debugging, Error Handling and Performance Tuning of sources, targets, Jobs etc.
Performed various activities like import and export of Talend Jobs & Projects.
Experience on Requirement gathering, analysis and designed mapping documents.
Good knowledge in data warehouse concepts like star schema, snowflake, dimension and fact tables.
Develop and implement strategies for performance tuning.
Experience in analyzing the business requirements and creating ETL jobs.
Worked on TOS and Talend Enterprise Edition.
Team player with good communication and interpersonal skills and has ability to quickly adopt, master and utilize new technology.
Talend Developer
ETL-Talend Developer
Designed various jobs for extracting data from various sources involving flat files and relational tables.
Design and Implemented ETL for data load from source to target databases and for Fact and SCD Type-1 and 2 to capture the changes.
Developed jobs using Talend for data loading.
Importing Source/ Target tables from the respective databases.
Understanding existing business models and client requirements.
Extensively involved in development of jobs using various transformations of Talend according to business logic.
Changes to be made according to Change Requests in existing developed jobs.
Involved in the End to End process in Designing, Developing and Deploying.
Created context variables and groups to run Talend jobs against different environments.
Developed incremental mappings to load data into Data Warehouse.
Implemented Error Handling to provide the detailed error messages.
Created triggers for Talend jobs to run automatically on the server.
ETL-Talend Developer
Develop the ETL mappings for XML, .CSV, .TXT sources and load the data from these sources into relational tables with Talend ETL Developed Job lets for reusability and to improve performance.
Implemented FTP operations using Talend Studio to transfer files in between network folders as well as to FTP server using components like tFileCopy, tFTPPut, TFileArchive, tFTPGet etc.
Used Talend components tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator.
Support to QA team creating and scheduling of execution plans.
Weekly status calls with the business team.
Extracting, Transforming and Loading the data from Source to Staging and Staging to Target according to the Business requirements.
Capturing all errors to the error table and maintaining the Audit control mechanism for developed jobs.