Master Works is seeking an experienced Informatica Engineer with 4-6 years of experience to design, develop, and maintain data integration and ETL solutions using Informatica technologies. The role will be responsible for developing efficient data workflows, transforming and integrating data from multiple sources, ensuring data quality and accuracy, troubleshooting integration issues, and supporting data migration and data warehouse initiatives.
Key Roles and Responsibilities:
- 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.
- Support data governance activities by ensuring data assets are properly cataloged, classified, documented, and aligned with governance standards.
- Perform metadata onboarding and integration from various data sources into CDGC.
- Monitor and troubleshoot CDGC-related issues and ensure the availability and reliability of governance and cataloging capabilities.
- Collaborate with data governance, data engineering, and business teams to ensure effective adoption and utilization of CDGC.
Requirements
- 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 on 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.
- Strong proficiency in SQL and relational databases.
- 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.
- Strong analytical and problem-solving skills
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 are an advantage
Location: Client Site