Responsibilities

  • Build data integration workflows using Informatica IDMC modules such as IICS, CDI, CAI, and DQ.
  • Create and optimize pipelines for both cloud and on-premises data sources to enable smooth data migration and integration.
  • Collaborate with business analysts, data architects, and stakeholders to gather requirements and deliver effective solutions.
  • Perform data profiling, cleansing, and validation using IDMC Data Quality components to ensure accuracy and reliability.
  • Develop reusable mappings, templates, and tasks that follow best practices to enhance efficiency and consistency.
  • Manage production deployments, troubleshoot issues, and provide ongoing support for ETL/ELT workflows.
  • Work with both relational and cloud-native databases (S3, ADLS, BigQuery, Redshift, Synapse).
  • Ensure compliance with data governance, security, and regulatory standards while working in Agile environments using CI/CD pipelines.