* Collaborated with management and stakeholders on application modernization projects to develop strategic initiatives for long-term goals.* Led the Database Migration from AWS RDS Postgres to AWS Aurora PostgreSQL and AWS account migration for one of the applications, providing considerable cost savings along with on-boarding of new Reporting tool for client data analysis and visualization.* SME for batch applications, developing and maintaining multiple Data Engineering processes ensuring best development practices for managing Data Pipelines and smooth integration of data from diverse sources.* Involved in the migration of on-premises ETL technology stack and Data Pipeline to AWS utilizing the "Re platform migration strategy" and provisioning the AWS services through Terraform (Infrastructure as Code).* This migration has been instrumental in supporting our growing business needs by enhancing processing speed and achieving cost savings through a scalable and reusable cloud architecture.* Implemented a "Re architect migration strategy" for an application from Pentaho tool to AWS Glue service (using Python scripting) to fully leverage cloud-native features and services, leading to improved performance and scalability.* Developed a "Reconciliation Framework" to compare data between on-premises and RDS database tables, facilitating faster migration process.* Implementing Self-Service data platform using the Data Mesh Architecture, storing data in parquet format, leveraging Snowflake Cloud Data warehouse for Data Distribution. * Provided guidance to less experienced staff, mentoring junior developers in resolution of complex technical problems fostering talent development.

As part of this project’s assignment, I traveled onsite and worked from the client’s office: Deutsche Telekom, Darmstadt, Germany. Created strategy to download source files from Remote File Servers and handled the issues/defects/change requests raised by the Testing team w.r.t ETL loads. Coordinated project schedules & appropriate contingency plans with management ensuring timely delivery of tasks.

Understood and Acquired business requirements and participated in gaining functional knowledge with respect to design and development work from Business Users. Prepared ETL Strategy and Mapping Specification Documents through interaction with Client. Provided technical solutions/strategies and implemented SCD and CDC strategies during the ETL Design.

As part of this project’s assignment, I handled the migration activity from client’s location at British Petroleum, London, UK. Upgraded Informatica PowerCenter version 5.1.2 to version 7.1 and automated different processes within Informatica PowerCenter tool.