Informatica Data Conversion Lead Resume
0/5 (Submit Your Rating)
Austin, TX
SUMMARY:
- Over 5 years experience in SQL and 4 years experience with Oracle 11g & 12c.
- OPA (Oracle Policy Automation), .NET, Visual Basic, Unix, PHP, HTML, CSS, Javascript, Linux - Web Server.
PROFESSIONAL EXPERIENCE:
Confidential
Informatica Data Conversion Lead
Responsibilities:
- Led the data conversion team on gathering and implementing business requirements
- Built over 50 data mappings using Informatica Powercenter 10
- Architected the Medicaid/SNAP/TANF Program and Benefit determination logic to be correctly converted
- Assited with informatica MDM activities using Informatica MDM 10 for the data loads
- Implemented a custom data validation system running on Informatica Powercenter to validate conversion processes
Confidential
MDM Consultant/Architect
Responsibilities:
- Architected the landscape for the Amgen Commercial Master Data Management system
- Contributed to the establishment of a data governance team
- Installed and Configured Informatica MDM 10 with ActiveVOS on Amgen Cloud Servers
- Designed the MDM hub configurations (landing, staging, base object, match rules, trust, etc.)
- Deployed the IDD (Informatica Data Director) and configured the subject areas
- Led the source-to-target analysis for the MDM data sources using Informatica Powercenter
- Provided MDM (installation and configuration) to internal TCS resources
Confidential, Austin, TX
MDM Developer
Responsibilities:
- Worked with senior architect to develop mappings and batch job for MDM
- Created queries and packages for IDD (Informatica data director) and webservices (SOAP)
- Managed manual merge processes for the master client index
- Built over 10 mapping using Informatica Powercenter 9.5 to move data into and out of the MDM hub
Confidential, DeSoto, TX
Owner and IT
Responsibilities:
- Contracted with a construction company and created the company’s business server and network
- Diagnosed and fixed computers/workstations
- Designed and built custom websites for customers
- Great understanding of the MDM processes
- Architected solutions and participated in RFPs for Amgen, Zebra Comm., AIG, Merrill Lynch, and Adecco
- Installed the end to end application for dev, test, and production environment
- Worked with the Ohio conversion team to develop mapping to convert flat files into the new Confidential benefit system.
- Built workflow and processes with Designer, Workflow Manager, Workflow Monitor
- Created a validation system to validate data being converted in the Ohio project