Etl Developer Data Integration

SRI POOJITHA BATTINI

Email: *****************@*****.***

Mobile: +1-919-***-****

PROFESSIONAL SUMMARY:

• 3 years of experience in Information Technology as an ETL Developer with specialization in Talend and knowledge on Big data components.

• Experience in Data analysing and Data integration.

• Experience with Talend to develop processes for extracting, transforming, integrating, and loading data into database.

• Expertise in creating mappings in Talend using tMap, tJoin, tReplicate, tParallelize, tConvertType, tflowtoIterate, tAggregate, tSortRow, tLogCatcher, tRowGenerator, tNormalize, tDenormalize, tSetGlobalVar, tParallelize, tHashInput, tHashOutput, tJava, tJavarow, tAggregateRow,tWarn, tLogCatcher, tFilterRow, tDie etc.

• Worked on various sources and targets like Databases, flat files, xml, excel.

• Experience in Debugging, Error Handling and Performance Tuning of sources, targets, Jobs etc.

• Experience on Requirement gathering, analysis and designed mapping documents.

• Experience in analysing the business requirements and creating ETL jobs.

• Experience in Ingestion process for data migration into databases.

• Team player with good communication and interpersonal skills and has ability to quickly adopt, master and utilize new technology.

• Self-motivated, able to set effective priorities to achieve immediate, long-term goals and meet deadlines.

• Vibrant team player with positive approach towards issue resolution.

• Experience in Talend Administration Center (TAC) and AutoSys for scheduling and deployment. TECHNICAL SKILL SET:

• ETL : Talend Data Integration

• Database Technologies : Oracle, MSSQL, AWS Redshift

• Project Methodology : Agile Methodology

• Scheduling Tools : AutoSys, TAC

Operating systems : Windows and Unix

EDUCATION PROFILE:

• Completed B.Tech from Nalla Narasimha Reddy Education Society Group of Institution Engineering College, Hyderabad with an aggregate of 62% in 2019. WORK EXPERIENCE:

Worked as Associate Consultant in Capgemini Pvt.Ltd., Hyderabad from January 2022 to January 2023.

• Worked as Senior Software Engineer in CApgemini Pvt.Ltd., Hyderabad from January 2021 to December 2021.

PROJECT PROFILE:

Project #1: July’21 –September’21

Project Title : RMS Replacement EDO

Client : Citizens Bank

Environment : Talend, SQL, AutoSys, Oracle, AWS Redshift Role : Talend Developer

Project Description: The main objective of RMS Replacement EDO deals with extracting data from database and loading into data warehouse as per the Business requirement. It involves analyzing the data, developing Talend ETL Jobs to transform the data as required and send the extracts to the downstream team and consumer mailbox.

Roles and Responsibilities:

• Developed complex ETL jobs from source and loaded into various source like Oracle, Redshift, MySQL, etc. using Talend.

• Extensively used Talend Administrative Console (TAC) tool for creating Artifact tasks, real time statistics and logs.

• Created JIL (Job Information Language) to schedule the Talend jobs through AutoSys. • Worked on the Ingestion process to ingest the data into the datalake.

• Support to QA team creating and scheduling of execution plans. • Status reports and Jira updates on daily status calls.

• Weekly status calls with business team.

• Created run book to support team.

• Extracting, Transforming and Loading the data from Source to Staging and Staging to Target according to the Business requirements.

• Capturing the all errors to the error table and maintained Audit control mechanism for developed jobs.

Project #2: September’21 –January’23

Project Title : TPG

Client : Citizens Bank

Environment : Talend, SQL, AutoSys, Oracle, AWS Redshift Role : Talend Developer

Project Description: The main objective of TPG deals with extracting data from database and loading into data warehouse as per the Business requirement. It involves analyzing the data, developing Talend ETL Jobs to transform the data as required and send the extracts to the downstream team.

Roles and Responsibilities:

• Developed complex ETL jobs from source and provided in xml formats using Talend.

• Extensively used Talend Administrative Console (TAC) tool for creating Artifact tasks, real time statistics and logs.

• Created JIL (Job Information Language) to schedule the Talend jobs through AutoSys.

• Worked on the Ingestion process to ingest the data into the datalake.

• Support to QA team creating and scheduling of execution plans. • Status reports and Jira updates on daily status calls.

• Weekly status calls with business team.

• Created run book to support team.

• Extracting, Transforming and Loading the data from Source to Staging and Staging to Target according to the Business requirements.

• Capturing the all errors to the error table and maintained Audit control mechanism for developed jobs.

Date: SRI POOJITHA BATTINI

Contact this candidate