latchhire

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

Software Mind · San José, San José Province, Costa Rica (Remote)
RemoteNew mid data engineer
Apply on Software Mind →
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. 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. 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 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!
Posted 2026-07-02