Sr. Oracle MDM Architect


Dallas, TX

Industry: Business Services


11 - 15 years

Posted 55 days ago

  by    Michael Papa

Detailed Description:

Responsible for architecting, designing, developing, configuring, and maintaining Master Data across multiple domains (Customer, Contact, Product, Location, Supplier, Inventory, Lease, Charts of Accounts and Employee) with integration between Oracle Cloud MDM products and external systems as needed.


  • Define/design the MDM solution architecture with data models for Customer, Contacts, Product, Location, Supplier, Chart of Account, Employee, Inventory and Lease)
  • Define data mapping and transform rules to load historical data from the legacy systems into the to be MDM models.
  • Define/design integration between MDM and external systems such as Salesforce
  • Partner with the Data Governance Council/Working groups to solicit requirements for data model design and data stewardship approval workflows.
  • Lead the MDM application and technical architecture analysis, design and implementation to ensure that the product fulfils the requirements
  • Role will extend to Logical Data Modeling design for Data Warehousing
  • Develop accurate, complete, comprehensible, and useable documentation of products and services
  • Analyze, troubleshoot and resolve system functional and technical errors. Troubleshoot systems and data, and generate solutions which may include systems modifications enhancements or new procedures
  • Report, track, and resolve MDM related issues by leveraging relevant vendor resources
  • Apply tools to analyze products to improve performance, responsiveness, and end-user productivity
  • Collaborate with team members and demonstrate the willingness to lend support and help
  • Interpret and apply complex technical instructions and specifications
  • Organize work, set priorities and meet critical deadlines
  • Regularly demonstrate empathy and a positive attitude in performing work and in working with others
  • Share knowledge, insights and work among team members and partners
  • Work directly with vendor resources to achieve project goals and provide ongoing support of the system


  • 10+ years or more total software development, architecture, and solution design experience related to Master Data Management, Data Warehousing, and BI that includes synchronization of data between environments
  • A minimum of 6 years' experience in Oracle's MDM products with at least 1+ years with the equivalent Oracles cloud solutions (Product Hub, Data Quality Management, Engagement Cloud Enterprise, Enterprise Data Management for Chart of Accounts)
  • 8+ years as an MDM Architect including expertise with MDM data models, matching rules, trust frameworks, complex hierarchy relationship management and data governance
  • 8+ years in depth knowledge of MDM products such as Oracle MDM (on prem), Informatica, SAP MDG, IBM MDM, Semarchy, etc…
  • Familiarity with Oracle Cloud ERP
  • Knowledge of Oracle's Autonomous Data warehouse, Oracle Analytics Cloud, and EDM is highly preferred
  • Strong business process experience and acumen
  • Excellent verbal and written communications, interpersonal, and analytical skills is required.
  • A process-oriented individual, with strong project management skills, who has the flexibility to thrive in a fast-paced, dynamic organization.
  • An ability to articulate and clearly communicate complex problems and solutions in a simple, logical and impactful manner.
  • Must be flexible and adaptable to changing business models.
  • The ability to develop creative and breakthrough solutions.
  • Relevant Oracle specialist certifications strongly preferred
  • Experienced in Agile and Waterfall Methodologies

BS in Computer Science or Information Systems