Informatica, Engineer

Role Overview

Masterworks is hiring an Informatica Engineer to design, develop, and maintain data integration and ETL solutions using Informatica technologies. The position is based at the client site.

Role Purpose

Develop efficient data workflows, transform and integrate data from multiple sources, ensure data quality and accuracy, troubleshoot integration issues, and support data migration and data warehouse initiatives.

Key Responsibilities

Data Governance & Cataloging

• Develop and configure CDGC (Cloud Data Governance and Catalog) solutions to support enterprise data cataloging, metadata management, data discovery, and governance requirements.
• Manage and administer CDGC, including configuration, maintenance, metadata ingestion, catalog management, and ongoing optimization.
• Configure and maintain data assets, metadata, business terms, classifications, and relationships within CDGC.
• Perform metadata onboarding and integration from various data sources into CDGC.

Governance & Quality Assurance

• Support data governance activities by ensuring data assets are properly cataloged, classified, documented, and aligned with governance standards.
• Monitor and troubleshoot CDGC-related issues and ensure the availability and reliability of governance and cataloging capabilities.

Collaboration & Adoption

• Collaborate with data governance, data engineering, and business teams to ensure effective adoption and utilization of CDGC.

Qualifications & Experience

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, Data Engineering, or a related field.
• 4–6 years of relevant experience in Informatica development and data integration.
• Strong knowledge in developing CDGC.
• Expert knowledge of managing CDGC.
• Strong hands-on experience with Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC/IICS).
• Strong knowledge of ETL/ELT concepts and data integration methodologies.
• Experience working with databases such as Oracle, SQL Server, PostgreSQL, or similar.
• Good understanding of data warehousing concepts, including fact tables, dimensions, ETL processes, and data marts.
• Experience with troubleshooting, performance tuning, and optimization of ETL workflows.
• Good understanding of data quality, data validation, and data reconciliation.

Skills & Competencies

• Strong proficiency in SQL and relational databases.
• Strong analytical and problem-solving skills.

Additional Information

Preferred Qualifications

• Experience with Informatica Cloud/IICS/IDMC.
• Experience with Informatica Data Quality (IDQ) or Master Data Management (MDM).
• Knowledge of Unix/Linux shell scripting.
• Experience with Python or other scripting languages.
• Exposure to cloud platforms such as AWS, Microsoft Azure, or Google Cloud.
• Experience with API-based integrations and web services.
• Knowledge of CI/CD and DevOps practices for data integration.
• Relevant Informatica or cloud certifications.