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

San José, , Costa Rica -

Full Time

Start Date

Immediate

Expiry Date

11 Oct, 26

Salary

0.0

Posted On

13 Jul, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

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

Industry

IT Services and IT Consulting

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

Responsibilities

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.