-Managed end-to-end data integration projects from requirements gathering to deployment.-Designed and implemented ETL processes using Informatica, Operating System as UNIX and DB as ORACLE.-Designed and implemented data warehouse structures, including staging areas, data marts, and dimensional models.-Used my UNIX scripting expertise in designing UNIX based solutions for different problems.-Worked on-premise and cloud based operating system. Good knowledge of AWS EC2.-Collaborated closely with business stakeholders to gather requirements and translate them into effective ETL designs.-Have demonstrated excellent leadership skills and capability of guiding team of ETL developers to achieve project objectives within defined timelines.

-Led end-to-end data migration initiatives, collaborating with cross-functional teams to ensure successful and seamless transitions from Informatica to Ab-Initio.-Designed and implemented custom reports and dashboards using ServiceNow Performance Analytics to provide stakeholders with real-time performance insights.-Worked closely with business stakeholders and technical teams to gather requirements, understand data structures, and define migration strategies that align with business objectives.-Designed and implemented Unix-based solutions to meet clients' business requirements, ensuring seamless integration with existing infrastructure.-Collaborated with the DevOps team to automate the build and deployment processes using Unix scripting, leading to faster release cycles and improved software quality.-Resolved technical issues and challenges during migration, providing timely troubleshooting and implementing effective solutions to minimize downtime and data loss.-Participated in code reviews and provided constructive feedback to ensure adherence to coding standards and best practices.-Maintained documentation of migration processes, procedures, and lessons learned, contributing to knowledge sharing and continuous improvement initiatives.-Designed and implemented data migration plans, ensuring data integrity, security, and compliance with industry standards and best practices.

Worked as senior ETL production support analyst. Handled production related issues involving multiple stakeholders/vendors. Involved in debugging Informatica mappings, Sessions, Batches and Target Data.Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor. Verified session logs to identify the errors occurred during the ETL execution. Performed quality check/ Data analysis on data coming from different sources.

Worked as Change Management specialist involved in deployment of different Barclays programs ETL (informatica and Ab-Initio) codes to higher environments.Involved in release of codes from UAT till PRODUCTION environment with giving successful first run in PROD environment before handing over it to support team.Extensive use of Tivoli Workload Schedule, Service Now, Unix commands and Scripting was involved as a part of this role.

Worked as Support Engineer for monitoring SLA critical Informatica batches and intimating the same to Customer.Involved in resolving issues that used to be raised in form P1 and P2 tickets based on the severity and criticality.