Pushpa Kumari Email and Phone Number

•Providing L3 support to mission critical application and delivering very stringent time-defined system releases.•Checking and monitoring the health status of application on daily basis.•Pro-actively identifying and solving the issues and reporting the same to client.•Developing new workflows (mapping, sessions) or updating the logic of workflow as per the requirements.•Unit testing and helping business with their UAT by following the good practices and processes of the pharma domain.•Requirement gathering from client, upstream data providers and downstream data consumers for understanding the system requirements while working on new releases as well as in enhancement of current system.•Working along with Quality Analyst team to make sure all the validation procedures are followed within the application.•Executing the data changes within the application for fixing the data related issues.

•Followed up with various teams to gather information in setting up connections of various sources like SQL Server, Oracle Pascal, Oracle EBS, DB2 etc.•Used Informatica PowerCenter for loading data from various heterogeneous source systems into target databases.•Created mappings using Designer & extracted data from various sources, transformed data according to the requirements.•Involved in extracting the data from the Flat Files and Relational databases into Staging area.•Developed Informatica Mappings and Reusable Transformations to facilitate timely loading of data to data warehouse.•Created shell scripts to fine tune the ETL flow of the Informatica workflows.•Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source Qualifiers and dataflow management into multiple targets.•Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router, Normalizer and Aggregator to create robust mappings in the Informatica PowerCenter Designer.•Done Dev testing, QA testing and migrated the defect free code to the Production.