Michael Pilotti
Senior Database Developer @Hibu
Signup · Get unlimited contacts
WORK HISTORY
Senior Database Developer @Hibu
Lead developer on a successful conversion from D&B’s Pruisma MDM Product to Informatica’s MDM Product, including development, testing, reporting of conversion effort while working with data governance teamSupporting Informatica MDM for managing business as location domain data sourced from multiple in house and third party data providers, including administration of Hub & IDD applications, and application servers. Lead Developer on multiple successful source system conversions for Informatica’s MDM Product, including development, testing, reporting of conversion effort while working with data governance team.Support processes accessing materialized views for ease of access of business as a location data along with its classification on Oracle 11g database. Develop, Optimize, run and monitor Informatica mappings/workflows and PL/SQL programs for loading data into MDM platform and into the data warehouse, and for extracting from Warehouse for regularly scheduled and ad hoc data requests.Modify IDD application using application configuration parameters.Support data governance team with data quality, data cleansing, re-processing and deleting old source data.Create staging/landing tables, set trust setting at source/column levels, add validation and match rules.Support web services for querying MDM data using different match rules.Manage off-shore operations team.
EDUCATION
Pennsylvania State University
BS
SKILLS
ABOUT MICHAEL PILOTTI
Team lead and application developer for Data Warehouse, Business Intelligence and Master Data Management implementations. Specialties: Data Warehousing, Business Intelligence, Analytical Reporting, Database Administration, Master Data Management, ETL
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.