Software Mind

[8OW] ETL Data Engineer (Informatica + IICS)

Software Mind · San José, Costa Rica

IT Services and IT Consulting · 1,001-5,000 employees

5 h ago
Senior (5-10 yrs) Contractor Costa Rica
Log in to apply, save this posting, or score it against your profile with AI.

About the role

Design, build, and support cloud-based data integrations and ETL/ELT pipelines using Informatica Intelligent Cloud Services. Collaborate with stakeholders to define data contracts and manage production incidents and deployments.

What they look for

IICS ETL/ELT SQL Data Modeling Cloud Data Integration Application Integration Databricks Git CI/CD REST/SOAP APIs JSON XML Oracle SQL Server SaaS Integration Performance Tuning

Requirements

Requires 6-8+ years of experience in data integration with strong expertise in IICS and SQL. Candidates should be proficient in data modeling, cloud data stores, and CI/CD automation.

Full description

Company Description

We are Software Mind, an awesome team of engineers who are ready to ramp up any top-notch company’s projects! Our aim? To always be one step ahead. Become part of a multicultural company in constant growth with an excellent work environment certified by Great Place To Work!

Job Description

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.

Qualifications

Key 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.

Required qualifications & experience

• 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.

 

 

Additional Information

Preferred / nice-to-have

• 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