We are looking for an experienced ETL / IICS Developer with strong hands-on experience in data integration, Informatica IICS, PL/SQL and relational databases.
The role will be responsible for designing, developing, testing and supporting ETL/data integration solutions, with particular emphasis on Informatica IICS and database-driven integrations.
Key Responsibilities
- Design, develop and maintain ETL/data integration solutions using Informatica IICS.
- Develop and maintain mappings, workflows/taskflows and data integration processes.
- Develop complex SQL and PL/SQL queries, procedures, functions and packages.
- Integrate data across databases, applications, files and other source/target systems.
- Perform data analysis, transformation, validation and reconciliation.
- Troubleshoot ETL failures, data issues and database-related problems.
- Perform performance tuning and optimisation of ETL jobs and database queries.
- Conduct unit testing and support SIT/UAT and production deployments.
- Monitor production data integrations and resolve incidents and defects.
- Produce and maintain relevant technical documentation.
Required Experience
- 3+ yrs of relevant experience
- Strong hands-on Informatica IICS / Cloud Data Integration experience.
- Strong SQL and PL/SQL development skills.
- Strong experience working with relational databases, preferably Oracle.
- Experience in ETL performance tuning and troubleshooting.
- Good understanding of data warehousing and data integration concepts.
- Experience working across the software development lifecycle.
- Good analytical and problem-solving skills.
Preferred
- Experience with Informatica PowerCenter in addition to IICS.
- Experience with enterprise-scale data integration environments.
- Experience with CI/CD and automated deployment of data integration components.
- Experience working in Agile delivery environments.