jobs in IITMatrix

IITMatrix Hiring! Full Time ETL- Informatica Developer in Federal Territory - Ricebowl

ETL- Informatica Developer

IITMatrix

KL City, Federal Territory

Share
Save

Working Location

  • Kuala Lumpur Federal Territory Malaysia

Job Description

Responsibilities

ETL / IICS Developer

Role Overview


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 to 5 years of relevant experience

• Strong hands-on Informatica IICS / Cloud Data Integration experience.

• Strong ETL/data integration development 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.


Important Information

Never provide your bank or credit card details when applying for jobs. Do not transfer any money or complete unrelated online surveys. If you see something suspicious, Report this Job ad.

Learn More