Informatica Admin
Current• Responsible for upgrading Informatica Power exchange from 10.2 to 10.4.1 version.• Setting up a new UAT environment in the Power exchange.• Used Informatica Power Exchange CDC Oracle/MS SQL server for various use cases.• Developed mappings/workflows for various financial business teams according to their needs• Worked on Informatica Unstructured Data Transformations (UDT).• Worked on data ingestion to HIVE using Python scripting.• Used TIDAL scheduling tool to schedule some of the batch/CDC jobs.• Worked on PWC code promotion from DEV to TEST and TEST to PROD Environments.• Built CI/CD pipelines over GIT/Jenkins to automate some of the legacy code. In the process, used Groovy programming language.• Worked on tuning Big Data Workflows to optimize performance.• Worked extensively on Python/Shell scripting.• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.• Used Informatica Dynamic Deployment groups to deploy the Informatica jobs among different environments (DEV, TEST, QA, and PROD).• Have deep and thorough understanding of ETL tools and how they can be applied in a GRID environment.