Michael Duffield Email & Phone Number

Baltimore, Maryland

working with Informatica software, power center version 8x, and 9x and IDQ

Baltimore

Working at client site (T. Rowe Price) using Informatica 9.1 and 8.6.1 to process XML source and target data.• Create and maintain source to target mapping specifications, detailing integration and transformation logic.• Create data integration mappings using Informatica PowerCenter to extracts, transform, and load data as per specifications. • Perform peer document reviews and code reviews to ensure adherence to user requirements as well as established standards and conventions… Show more Working at client site (T. Rowe Price) using Informatica 9.1 and 8.6.1 to process XML source and target data.• Create and maintain source to target mapping specifications, detailing integration and transformation logic.• Create data integration mappings using Informatica PowerCenter to extracts, transform, and load data as per specifications. • Perform peer document reviews and code reviews to ensure adherence to user requirements as well as established standards and conventions. • Perform unit testing of developed procedures and mappings . • Develop, maintain, and enforce standards pursuant to Informatica mappings, naming conventions, and system processes. Show less

Columbia, Maryland

Extracted and loaded data into Microsoft 2008 SQL server.Created campaigns for multiple Non-Profit clients using Alterian tool.Created and loaded tables in production using SQL.Created ad-hoc reports and queries for Non-Profit clients

Informatica ETL developer supporting the Center for Medicare and Medicaid Services (CMS) - client system using Informatica PowerCenter 8.x, Unix, Oracle 10g & 9i, CRT & Secure CRT, Teradata

Project Lead / Systems Architect on the Consumer Marketing Data Base project.Main production support person responsible for monitoring of daily processes, execution of weekly/quarterly maintenance processes, developed automated production processes as well as update and migrate the Informatica ETL (oracle 9i database). ALso performed analysis, designed, and implemented ETL maps for data movement to meet the business rules. The skills and technologies used in this… Show more Project Lead / Systems Architect on the Consumer Marketing Data Base project.Main production support person responsible for monitoring of daily processes, execution of weekly/quarterly maintenance processes, developed automated production processes as well as update and migrate the Informatica ETL (oracle 9i database). ALso performed analysis, designed, and implemented ETL maps for data movement to meet the business rules. The skills and technologies used in this position were Informatica ETL, Unix shell scripting, PL/SQL, FirstLogic Data Cleansing.Main Informatica support person responsible for monitoring and updating of daily processes of new Informatica test and production systems using Oracle 10g database.Managed a team that performed the Informatica PowerCenter 6 upgrade to Informatica PowerCenter 7. System Architect on the Discus Application (micro-focus cobol, Oracle 8i data base) and sql loaded data mart Show less