Developer, Certinia, IICS

This is a fully remote position, open to applicants in Costa Rica.

📋 Description

• Design, develop, test, and deploy data integration solutions utilizing IICS (Cloud Data Integration, Application Integration, Data Quality, Data Synchronization).

• Construct ETL/ELT pipelines to acquire, transform, and distribute data between cloud and on-premise systems (SaaS, databases, data lakes, data warehouses).

• Apply secure and efficient integration patterns through IICS mapping tasks, mappings, tasks, and parameterization.

• Create and sustain reusable templates, mappings, and components to expedite delivery.

• Collaborate with architects, data engineers, analytics teams, and business stakeholders to establish integration requirements and data contracts.

• Diagnose and resolve production incidents; conduct root cause analyses and implement solutions.

• Automate deployments and CI/CD for IICS artifacts (Dev → Test → Prod), including versioning, changelogs, and release notes.

• Set up monitoring, alerting, and operational runbooks for integrations.

• Uphold data quality standards and profiling; collaborate with the business to address data quality concerns.

• Compile technical documentation: design documents, runbooks, data flow diagrams, and support guides.

• Facilitate platform governance: connectivity, security, access controls, best practices, and cost optimization.

⛳️ Requirements

• 6-8+ years of practical experience in data integration/ETL roles.

• Strong hands-on experience with Informatica Intelligent Cloud Services (IICS) — Cloud Data Integration and Application Integration is highly preferred.

• Proficient in SQL with the ability to read and enhance medium to high complexity SQL code.

• In-depth understanding of data modeling concepts (Star Schema, Medallion architecture), ETL/ELT methodologies, 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 data transformation, validation, and performance tuning.

• Experience with source control (Git), CI/CD pipelines, and deployment automation.

• Strong troubleshooting and debugging capabilities in production environments.

• Excellent communication skills and the ability to collaborate across cross-functional teams.

🏝️ Benefits

• Flexible work arrangements

• Professional development