[8OW] Developer (Certinia + IICS)

Software Mind Americas

About The Position

We are seeking an experienced IICS Developer to design, build, and support cloud-based data integrations and ETL/ELT pipelines using Informatica Intelligent Cloud Services. The ideal candidate combines hands-on IICS development experience with strong data engineering fundamentals, good stakeholder communication, and an operations mindset to support production integrations and onboarding of new data sources.

Requirements

6-8+ years of hands-on experience in data integration/ETL roles
Strong hands-on experience with Informatica Intelligent Cloud Services (IICS) — Cloud Data Integration and Application Integration strongly preferred.
String experience in SQL with ability to read and enhance medium to high complexity SQL code.
Deep understanding of data modelling concepts (Star Schema, Medallion architecture) ETL/ELT concepts, mapping designs, pushdown optimization, and performance tuning.
Experience integrating with relational databases (Oracle, SQL Server), cloud data stores (Databricks), and SaaS APIs (Salesforce, Workday, etc.).
Familiarity with JSON, XML, REST/SOAP APIs, and data serialization formats.
SQL expertise for transformation, validation and performance tuning.
Experience with source control (Git), CI/CD pipelines and deployment automation.
Strong troubleshooting and debugging skills in production environments.
Excellent communication skills and ability to work across cross-functional teams.

Nice To Haves

Informatica Cloud / Cloud Data Integration certification.
Experience with Informatica PowerCenter and migration experience to IICS.
Knowledge of cloud platforms (AWS, Azure, GCP) and cloud-native storage (S3, ADLS).
Experience with data warehouse platforms and ELT patterns.
Understanding of data governance, metadata management and GDPR / data privacy controls

Responsibilities

Design, develop, test and deploy data integration solutions using IICS (Cloud Data Integration, Application Integration, Data Quality, Data Synchronization).
Build ETL/ELT pipelines to ingest, transform, and deliver data between cloud and onprem systems (SaaS, databases, data lakes, data warehouses).
Implement secure and performant integration patterns using IICS mapping tasks, mappings, tasks, and parameterization.
Develop and maintain reusable templates, mappings, and components to accelerate delivery.
Collaborate with architects, data engineers, analytics teams, and business stakeholders to define integration requirements and data contracts.
Troubleshoot and resolve production incidents; perform root cause analysis and implement fixes.
Automate deployments and CI/CD for IICS artifacts (Dev → Test → Prod), including versioning, changelogs and release notes.
Implement monitoring, alerting and operational runbooks for integrations.
Enforce data quality rules and profiling; work with business to remediate data quality issues.
Prepare technical documentation: design documents, runbooks, data flow diagrams, and support guides.
Support platform governance: connectivity, security, access controls, best practices and cost optimization.