[8OW] ETL DATA ENGINEER (INFORMATICA + IICS)
Softwaremind
Contractsenior
Job description
<p>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.</p>
<p>Key responsibilities<br>
• Design, develop, test and deploy data integration solutions using IICS (Cloud Data <br>
Integration, Application Integration, Data Quality, Data Synchronization).<br>
• Build ETL/ELT pipelines to ingest, transform, and deliver data between cloud and onprem systems (SaaS, databases, data lakes, data warehouses).<br>
• Implement secure and performant integration patterns using IICS mapping tasks, <br>
mappings, tasks, and parameterization.<br>
• Develop and maintain reusable templates, mappings, and components to accelerate <br>
delivery.<br>
• Collaborate with architects, data engineers, analytics teams, and business stakeholders <br>
to define integration requirements and data contracts.<br>
• Troubleshoot and resolve production incidents; perform root cause analysis and <br>
implement fixes.<br>
• Automate deployments and CI/CD for IICS artifacts (Dev → Test → Prod), including <br>
versioning, changelogs, and release notes.<br>
• Implement monitoring, alerting, and operational runbooks for integrations.<br>
• Enforce data quality rules and profiling; work with business to remediate data quality <br>
issues.<br>
• Prepare technical documentation: design documents, runbooks, data flow diagrams, <br>
and support guides.<br>
• Support platform governance: connectivity, security, access controls, best practices, and <br>
cost optimization.</p><p>Required qualifications & experience<br>
• 6-8+ years of hands-on experience in data integration/ETL roles <br>
• Strong hands-on experience with Informatica Intelligent Cloud Services (IICS) — Cloud <br>
Data Integration and Application Integration strongly preferred.<br>
• Strong experience in SQL with the ability to read and enhance medium to high complexity <br>
SQL code.<br>
• Deep understanding of data modelling concepts (Star Schema, Medallion architecture) <br>
ETL/ELT concepts, mapping designs, pushdown optimization, and performance tuning.<br>
• Experience integrating with relational databases (Oracle, SQL Server), cloud data stores <br>
(Databricks), and SaaS APIs (Salesforce, Workday, etc.).<br>
• Familiarity with JSON, XML, REST/SOAP APIs, and data serialization formats.<br>
• SQL expertise for transformation, validation, and performance tuning.<br>
• Experience with source control (Git), CI/CD pipelines, and deployment automation.<br>
• Strong troubleshooting and debugging skills in production environments.<br>
• Excellent communication skills and ability to work across cross-functional teams.<br>
 </p><p> </p>
<p>Preferred / nice-to-have<br>
• Informatica Cloud / Cloud Data Integration certification.<br>
• Experience with Informatica PowerCenter and migration experience to IICS.<br>
• Knowledge of cloud platforms (AWS, Azure, GCP) and cloud-native storage (S3, ADLS).<br>
• Experience with data warehouse platforms and ELT patterns.<br>
• Understanding of data governance, metadata management and GDPR / data privacy <br>
controls</p>