Mekala Rajashekar

Mekala Rajashekar

Talend ETL Developer
India

About Me

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…

Experience

Etl Developer

Genpact India Private Limited
Feb 2018 - Present · 8 years 4 months

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

Genpact.Pvt. Ltd, Hyderabad
Dec 2017 - May 2023 · 5 years 5 months

ETL-Talend Developer

Provigo

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

Pharmasave

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.

Skills

Big Data ETL Data Integration and Transformation (ETL) Informatica Oracle Structured Query Language (SQL) T SQL Teradata Data Integration and ETL Data Model Data Repository Microsoft SQL Server SQL Server Integration Services (SSIS) Talend PL/SQL Talend Data Integration Talend Open Studio MSSQL Windows JIRA Unix TAC PowerDesigner Repository Manager Workflow Designer Workflow Manager IICS ETL SQL Server Agile tMap tJoin tReplicate tParallelize tConvertType tNormalize tDenormalize tSetGlobalVar tHashInput tHashOutput tJava tJavarow tAggregateRow tWarn tFilterRow tDie tRowGenerator tflowtoIterate tAggregate tSortRow tLogCatcher tStatCatcher tLogRow FTP tFileCopy tFTPPut tFileArchive tFTPGet tFTPRename tFTPDelete tFileDelete tTouchFile XML CSV
Report this Profile?