JJobsSonar

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

Software Mind · San José, cr

Remote
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!
Ready to apply?Apply now

Similar jobs

Browse all

Cloud Platform Engineer

ASE (Analysis Simulation Engineering) AG · Zurich, Zurich, Switzerland

On-siteEasy apply2w ago

DevOps Engineer

Sundayy · United States

RemoteEasy apply401(k), Medical2w ago