ETL Data Engineer

Responsibilities

• Design, develop, test and deploy data integration solutions using IICS
• Build ETL/ELT pipelines to ingest, transform, and deliver data between cloud and on-prem systems
• Implement secure and performant integration patterns using IICS mapping tasks and parameterization
• Develop and maintain reusable templates, mappings, and components
• Collaborate with architects, data engineers, and business stakeholders to define requirements
• Troubleshoot and resolve production incidents and perform root cause analysis
• Automate deployments and CI/CD for IICS artifacts
• Implement monitoring, alerting, and operational runbooks
• Enforce data quality rules and profiling
• Prepare technical documentation including design documents and data flow diagrams

Requirements

• 6-8+ years of hands-on experience in data integration/ETL roles
• Strong hands-on experience with Informatica Intelligent Cloud Services (IICS)
• Strong experience in SQL with ability to enhance complex code
• Deep understanding of data modelling (Star Schema, Medallion architecture)
• Experience integrating with relational databases (Oracle, SQL Server) and cloud data stores (Databricks)
• Familiarity with JSON, XML, REST/SOAP APIs, and data serialization formats
• Experience with source control (Git), CI/CD pipelines, and deployment automation
• Strong troubleshooting and debugging skills in production environments

Preferred Qualifications

• Informatica Cloud / Cloud Data Integration certification
• Experience with Informatica PowerCenter and migration to IICS
• Knowledge of cloud platforms (AWS, Azure, GCP)
• Experience with data warehouse platforms and ELT patterns
• Understanding of data governance and GDPR/data privacy controls

About the Company

Software Mind is an awesome team of engineers ready to ramp up any top-notch company’s projects. We are a multicultural company in constant growth with an excellent work environment certified by Great Place To Work!