MDM architect

SC Works Trident; Charlotte, Northern (NC, KY); Hybrid; USD 120,000 - 150,000; Full time

Job summary

SC Works Trident seeks an experienced MDM Architect to lead design, deployment and optimization of Informatica MDM and Informatica Cloud MDM solutions. The role focuses on both on-premises and cloud environments, with emphasis on data quality, matching rules, and survivorship, while coordinating with business and IT stakeholders.

The candidate will design data models, oversee ETL and integration patterns, and ensure compliance with security and governance standards, guiding junior team members

Qualifications

• 11 to 15 years of experience in Informatica MDM and Informatica Cloud MDM
• Experience leading architecture design and implementation of MDM solutions (on-prem and cloud)
• Strong SQL skills for data analysis, validation, and troubleshooting in MDM environments

Responsibilities

• Lead end-to-end design, build and deployment of Informatica MDM and Informatica Cloud MDM solutions
• Configure and tune fuzzy match, survivorship, and validation rules
• Collaborate with product and platform teams to implement best practices and reusable patterns
• Mentor junior team members and cross-functional teams

Skills

INFORMATICA-MDM

Informatica Cloud MDM

Tools

SQL

SIF framework

Job description

Job Facts

Occupation: Computer Systems Engineers/Architects

Location: Charlotte, NC - 28278

Job Type: Full Time (30 Hours or More)

Onsite role

Title: MDM architect

Location: Charlotte - North Carolina (Onsite)

Long Term Contract Role

Mandatory Skills: INFORMATICA-MDM

Job Description

JD: Seeking an experienced Overseas Contractor with 11 to 15 years of expertise in Informatica MDM and Informatica Cloud MDM to lead and optimize enterprise Master Data Management solutions.

Lead the architecture design and implementation of Informatica MDM solutions including both on premises and cloud based Informatica Cloud MDM environments Design and configure data models integration patterns and MDM solution architectures aligned with business requirements Ensure adherence to enterprise architecture standards security guidelines and long-term business objectives Provide hands‑on expertise in configuring and managing MDM platform components such as staging loading matching validation rules and user interface Utilize strong SQL skills for data analysis validation and troubleshooting within MDM environments Collaborate closely with business stakeholders IT teams and data consumers to define and refine MDM solution components Develop and maintain detailed technical documentation including architecture diagrams configuration guides and specifications Optimize MDM processes for performance scalability and data quality including fuzzy matching and survivorship rules Support platform administration performance tuning and operational optimization activities Apply knowledge of ETL processes and integrate MDM platforms with cloud ecosystems preferably AWS Mentor and provide technical leadership to junior team members and cross functional teams.

Roles and Responsibilities

Lead end to end design build and deployment of complex Informatica MDM and Informatica Cloud MDM solutions Define and implement data lifecycle management including data modelling metadata management and data stewardship Configure and tune complex fuzzy match survivorship and validation rules to ensure data accuracy and integrity Manage data ingestion publishing exception handling and error resolution using SIF framework and Address Doctor Collaborate with product and platform teams to incorporate best practices and reusable patterns Ensure compliance with data governance security and privacy standards Drive continuous improvement initiatives to enhance data consistency accessibility and overall MDM solution effectiveness Act as a trusted advisor to stakeholders influencing decisions and guiding them through their MDM journey Troubleshoot and resolve issues related to data ingestion transformation and publishing within MDM workflows Lead configuration deployment and administration activities across multiple environments.

Occupation Information for Computer Systems Engineers/Architects