09/06/2022 updated

**** ******** ****
100 % available

Senior ETL Developer, Senior ETL Developer, Senior ETL Developer

Pune, India
India
Pune, India
India

Profile attachments

CV - Gayatri Kolli

Microsoft AccessMicrosoft WindowsAgile MethodologyCA Workload Automation AeBackup DevicesUnixComputer ProgrammingExtract Transform Load (ETL)Data MigrationIBM InfoSphere DataStageDojo ToolkitHP-UXUnix ShellMicrosoft VisioMicrosoft SQL ServersOracle ApplicationsSystems Development Life CyclePuTTYSAP ApplicationsSQL DatabasesSalesforce TableauTalendSybaseGitToad (Software)Control M
ETL, DataStage 11.7, Tableau 2022.1, SQL Developer, Putty, WinSCP, Autosys, Git, Jenkin, Service Now, Datastage, Backup, Oracle, Coding, Dojo, DataStage 8.7, Control M, SAP BODS, Windows 7, Data Migration, SAP, SDLC, Agile, Toad, Sybase, SQL Server, SQL Server database, SQL Server 2008, UltraEdit, HP Service, Microsoft Visio, MS Access DB, MS SQL Server 2008, Informatica 9.1, Talend, HP Service Desk, Cherwell, Jenikin, Programming, SQL, UNIX shell scripting, Window 10, Window 7, Windows XP, UNIX

Experience

Professional experience5 - 10 years

Languages

EnglishGood

Project history

Senior ETL Developer

TIAA Global Business Services India Pvt. Ltd
1) Client: Finance Domain
Work Location: Pune
Employer: TIAA Global Business Services India Pvt. Ltd
Role: Senior ETL Developer

Environment:
DataStage 11.7, Tableau 2022.1, SQL Developer, Putty, WinSCP, Autosys, Git, Jenkin, Service Now.

Responsibilities:
* Lead 2 Datastage Projects and executed successfully.
1. Datastage Upgrade Project - Migration of 2.5k Jobs from 11.5 to 11.7
2. Inactive Job Backup and Deletion - Export and rename of 500 One Time load Jobs and keep backup.
Deletion of original one.
* Got "PAT On Back" and "Stable Employee" Award from TIAA on successful completion of above
projects.
* Learnt and developed multiple Audit Reports in Tableau. This replaced 52+ Manual Daily, Weekly and
Monthly reports into Automated Tableau Reports.
* Used the DataStage Designer to develop processes for extracting, cleansing, transforming and
loading data into Oracle.


* Coding of new programs as per client's specifications, modifying existing programs and review of
the coded programs to ensure that they meet the requirements and standards.
* Got opportunity to participate in Automation Dojo Tech Activity of 5 members team and secured 1st
Prize.
* Got opportunity to spend 8hrs for NGO under Connect Me Program under TIAA CSR.
* Got opportunity to attend Training on Basics of Talend and Informatica.

Senior ETL Developer

LnT Infotech

Internet & IT

>10.000 team member

  • Got opportunity to work and lead Data Migration Project – This included migration of 5k Jobs from SAP BODS to Datastage 8.7.
  • Worked on all SDLC Phases started with requirement Gathering, Preparation of Mapping Sheet, Preparing POC, Providing Estimation etc.
  • Learnt to start and deliver Project End to End in Agile mode and to work closely with Client.

Senior ETL Developer

Capgemini

Internet & IT

>10.000 team member

  • Used the DataStage Designer to develop processes for extracting, cleansing, transforming and loading data into Oracle, Sybase and SQL Server database.
  • Develop and support Banking Application requirement end to end.
  • Coding of new programs as per client’s specifications, modifying existing programs and review of the coded programs to ensure that they meet the requirements and standards.
  •  
  • Got opportunity to learn MS Access DB overview. And taking the dump of data and loading into MS SQL Server 2008.
  • Used the DataStage Designer to develop processes for extracting, cleansing, transforming and loading data into Oracle and SQL Server database.
  • Coding of new programs as per client’s specifications, modifying existing programs and review of the coded programs to ensure that they meet the requirements and standards.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in