ETL Data Engineer, Informatica, IICS

Software Mind

ETL Data Engineer designing and building cloud-based data integrations using Informatica IICS. Collaborating with cross-functional teams and supporting data sources onboarding.

Posted 7/3/2026contractRemote • 🇨🇷 Costa RicaMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing data integration solutions using Informatica Intelligent Cloud Services (IICS), with a strong focus on ETL/ELT processes, SQL proficiency, and data quality management. Capable of collaborating with cross-functional teams to define integration requirements and ensure operational excellence.

Highest-signal resume keywords

Informatica Intelligent Cloud Services (IICS)ETL/ELT Pipeline DevelopmentSQL ExpertiseData Modelling ConceptsCI/CD Automation

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data IntegrationETL DevelopmentSQLData ModellingMapping DesignPerformance TuningTroubleshootingDeployment AutomationData Quality ManagementRoot Cause Analysis

Soft Skills

Excellent CommunicationCollaboration

Tools & Technologies

GitDatabricksSalesforceWorkdayJSONXMLREST APIsSOAP APIs

Industry Keywords

Cloud Data IntegrationApplication IntegrationData QualityData SynchronizationData LakesData Warehouses

Tech Stack

Tools & technologies

CloudETLInformaticaOracleSOAPSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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.
Strong experience in SQL with the 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.

Benefits

Comp & perks

Remote work options