[8OW] ETL Data Engineer (Informatica + IICS)
San José, San José Province, crContractPosted Jul 13, 2026
Job 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! 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