IDMC (Informatica Data Management Cloud) Integration Developer

Posted 4 days 4 hours ago by Tata Consultancy Services

Permanent
Full Time
Other
Donegal, Donegal, Ireland
Job Description
Job Type

Permanent

Job Location

Letterkenny, Co. Donegal (Hybrid - 2 days onsite per week - covering US Hours: 1pm to 9pm GMT)

Role

As an Informatica IDMC Integration Developer, you will play a critical role in enabling seamless data and application integration across enterprise systems. This role focuses on designing, developing, and supporting cloud based integrations using Informatica Intelligent Data Management Cloud (IDMC), with a strong emphasis on Cloud Data Integration (CDI) and Cloud Application Integration (CAI). You will build and maintain batch, real time, and event driven integrations, work with APIs and multiple data formats, and ensure high standards of data quality, performance, and reliability.

Your responsibilities:
  • Develop and optimize integrations using IDMC CDI and CAI components.
  • Work with JSON, XML, CSV, and other structured/unstructured data formats for ingestion, mapping, and transformation.
  • Build reusable CDI mappings, mapping tasks, and parameterized pipelines optimized for performance and maintainability.
  • Design and manage CAI processes, including service connectors, synchronous/asynchronous flows, event-driven integrations, and orchestration logic.
  • Implement robust error handling frameworks, including retries, exception handling, boundary events, and comprehensive logging.
  • Write and optimize SQL queries, stored procedures, and database scripts to support backend integrations.
  • Monitor and tune IDMC workloads-task flows, schedules, secure agents, and job performance.
  • Maintain strong data quality, resolve discrepancies through profiling, validation, and transformation rules.
  • Collaborate with cross-functional teams to gather requirements and deliver high quality integration solutions.
  • Maintain up-to-date technical documentation, including design specifications and integration flow details.
  • Support integration deployments using CI/CD pipelines, Git, and version control practices.
Your Profile

Essential skills/knowledge/experience:

  • In-depth IT experience specialising in integration development, including ETL workflows and API-based integrations.
  • Solid experience in integration development (IDMC CDI/CAI is mandatory).
  • Strong hands on experience with Informatica IDMC - CDI & CAI, including advanced integration patterns.
  • Expertise in developing CDI mappings, mapping tasks, and parameterized pipelines.
  • Proven experience building CAI processes, service connectors, synchronous/asynchronous workflows, and event-driven integrations.
  • Proficiency in handling JSON, XML, CSV, and other structured/unstructured data formats.
  • Solid understanding of REST/SOAP API integrations, authentication (OAuth, API Keys), and payload transformations.
  • Strong SQL skills: writing and optimizing queries, stored procedures, and scripts.
  • Experience implementing error handling mechanisms, including retries, exception handling, and logging.
  • Ability to monitor and optimise task flows, schedules, and secure agents within IDMC.
  • Good understanding of integration patterns such as batch, real time, and event-driven flows.
  • Knowledge of MDM SaaS components within IDMC.
  • Familiarity with CI/CD pipelines, Git, version control, and automated deployments.
Rewards & Benefits

TCS offers competitive salary packages featuring pension, health care, life assurance, laptop, and access to extensive training resources and discounts within the Tata network. Health & wellness initiatives, sports events, and community partnerships are also included.

Diversity, Inclusion and Wellbeing

Tata Consultancy Services UK&I is committed to meeting the accessibility needs of all individuals in accordance with the Ireland Employment Equality Acts and the Equal Status Acts . We welcome and embrace diversity in race, nationality, ethnicity, disability, neurodiversity, gender identity, age, physical ability, gender reassignment, and sexual orientation. We are a disability inclusive employer and encourage disabled people to apply for this role. As a Disability Confident Employer, we offer an interview to applicants with disabilities or long term conditions who meet the minimum criteria for the role.