Profileimage by Gayatri Kolli Senior ETL Developer, Senior ETL Developer, Senior ETL Developer from Pune

Gayatri Kolli

available

Last update: 06.09.2022

Senior ETL Developer, Senior ETL Developer, Senior ETL Developer

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Limited professional)

Attachments

datastage_gayatri_kolli.docx

Skills

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

Project history

04/2018 - 06/2022
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.

01/2017 - 04/2018
Senior ETL Developer
LnT Infotech (Internet and Information Technology, >10.000 employees)

  • 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.

06/2013 - 01/2017
Senior ETL Developer
Capgemini (Internet and Information Technology, >10.000 employees)

  • 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.

Local Availability

Only available in these countries: India
Profileimage by Gayatri Kolli Senior ETL Developer, Senior ETL Developer, Senior ETL Developer from Pune Senior ETL Developer, Senior ETL Developer, Senior ETL Developer
Register