Jobs · himalayas
ETL Data Engineer (Informatica + IICS)
Northwind Robotics · Costa Rica · Posted 12d ago
About the role
Design and support cloud-based data integrations and ETL pipelines using Informatica IICS.
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 Northwind Robotics , 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! Originally posted on Himalayas
Read the full posting on himalayas →
FAQ
Is the ETL Data Engineer (Informatica + IICS) role at Northwind Robotics remote?+
This ETL Data Engineer (Informatica + IICS) position is listed as remote (Costa Rica).
What is the salary for the ETL Data Engineer (Informatica + IICS) role at Northwind Robotics?+
The listing states Estimated 107k-220k USD.
What seniority level is this ETL Data Engineer (Informatica + IICS) role?+
This is a senior level position.
How do I apply for the ETL Data Engineer (Informatica + IICS) role at Northwind Robotics?+
Use the "Apply on himalayas" button to open the original posting on himalayas, where you can submit your application directly to Northwind Robotics.