MDM Lead/Architect

Smart IT Frame LLC; Charlotte (NC); On-site; USD 120,000 - 150,000; Full time

Job summary

Smart IT Frame LLC in Charlotte, NC, is searching for an experienced contractor to lead the architecture design and implementation of Informatica MDM and Informatica Cloud MDM solutions. The role involves end-to-end project delivery, ensuring data lifecycle management and compliance with governance standards.

The ideal candidate will have 13 to 18+ years of experience in Informatica MDM, hands-on expertise with SQL, and proven ability in mentoring junior team members. This position offers opportunities for optimization and operational excellence within enterprise environments.

Qualifications

• 13 to 18+ years of experience in Informatica MDM and Cloud MDM.
• Hands-on experience in MDM platform components and data governance.
• Strong technical documentation and mentoring skills.

Responsibilities

• Lead the design and implementation of Informatica MDM solutions.
• Define data lifecycle management and ensure data accuracy.
• Drive continuous improvement initiatives in data consistency.

Skills

Informatica MDM

SQL

Data analysis

Cloud MDM

Data modeling

Job description

At Smart IT Frame, we connect top talent with leading organizations across the USA. With over a decade of staffing excellence, we specialize in IT, healthcare, and professional roles, empowering both clients and candidates to grow together.

Seeking an experienced overseas contractor with 13 to 18+ years of expertise in Informatica MDM and Informatica Cloud MDM to lead and optimize enterprise Master Data Management solutions.

Job Description

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 modeling, 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 the 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.

Skills

Mandatory Skills: INFORMATICA-MDM