Vaishnavi S

MUFG Bank Ltd., | Data analysis and ETL Development team

• Design the data model, create and test Informatica interfaces, and manage end-to-end deliverables from offshore.
• Data product development enabling end-to-end data migration and transformation in Informatica.
• Created multiple reusable assets and scripts to automate processes, including Informatica mapping, test data generator scripts, Informatica job execution scripts with restart ability features, and deployment scripts.
• Enhancing the current code for better performance and convenience.
• I worked on a product tool upgrade.
• Ensure data governance, security, and compliance, focusing on data lineage tracking and transparency.
• Following the Agile/Scrum process, including sprint planning, daily scrums, sprint reviews, and sprint retrospectives.
• Define and prioritize product features, ensuring clear requirements and user stories in Jira, and attending backlog refinement sessions.
• Worked in development, testing, production migrations, and go-live support.

AXAXL | ETL Development team

• Work with the client to fetch the business needs, and work on them with the team.
• Coordinate with the source teams and various ownership teams.
• Migrate the enhanced code to the higher environment.
• Assign tasks to team members, and involve them in the enhancement activity.
• Weekly status report calls updates.
• Upgrade the tool to a higher version.

AMGEN, (BREDA-Europe) | ETL enhancement and Production Support Team

• Monitoring daily jobs and providing resolutions in case of failures.
• Providing solutions for incidents requested.
• Enhancing the current product for better performance and convenience.
• Deploying the changes through CRs for production.
• Prepared and reviewed detailed test scenarios and test cases covering SRT.
• Prepared and reviewed the SQL scripts, and tuned the queries for faster execution.
• Preparation of the Requirement Specification document, Detailed Design Document, developed for major/minor enhancements.

Novartis, UK (Concerto) | ETL Development Team

• Requirement Analysis.
• Design and Build (involves policy rule coding, sequence flow creation).
• Development of new or modifying existing mappings, as per requirements, through the ETL tool.
• Unit Testing.
• Prepared and reviewed detailed test scenarios and test cases covering SRT.
• Preparation of the Requirement Specification document, Detailed Design Document, developed for major/minor enhancements.