Developer (Informatica ETL)

Role: Developer (Informatica ETL)

Entity Reporting: Head of Delivery, ASEAN Business Unit

Functional Reporting: Service Delivery Manager

Job Scope Overview:

We are looking for an experienced Informatica PowerCenter Developer with hands-on experience in ETL development, data integration, and data warehousing. The role involves developing, maintaining, and supporting ETL workflows, ensuring efficient data integration, data quality, and reliable data processing.

The ideal candidate should have strong expertise in Informatica PowerCenter 10.x or above, with experience working in AIX and Solaris environments. The candidate should be comfortable handling AS400 and Oracle databases as source and target systems, along with exposure to Hadoop technologies such as Hive, Impala, and Beeline.

Key Responsibilities:

• Design, develop, test, and maintain ETL workflows using Informatica PowerCenter 10.x or above.
• Develop Informatica mappings, mapplets, sessions, workflows, and reusable components.
• Work with AS400 and Oracle databases as source and target systems.
• Develop and maintain data integration processes to support business and reporting requirements.
• Perform ETL development, unit testing, debugging, and performance tuning.
• Write and execute Shell scripts to automate data processing and ETL operations.
• Work with Hadoop ecosystem technologies, including Hive, Impala, and Beeline, for data extraction, processing, and validation.
• Support ETL deployments and production batch processing activities.
• Troubleshoot data integration failures and perform root cause analysis.
• Monitor scheduled workflows and ensure timely completion of ETL jobs.
• Ensure data accuracy, consistency, integrity, and quality across source and target systems.
• Collaborate with functional teams, business analysts, and other technical stakeholders to deliver data solutions.
• Prepare technical documentation, mapping specifications, and deployment documents.

Experience, Qualifications and Requirements:

• 3–5 years of relevant experience in Informatica ETL development.
• Strong hands-on experience with Informatica PowerCenter version 10.x or above.
• Experience in developing and maintaining ETL mappings, sessions, workflows and transformations.
• Good knowledge of ETL development, data integration and data warehousing.
• Experience working with AS400 DB2 and Oracle databases.
• Familiarity with Hadoop technologies such as Hive, Impala and Beeline.
• Hands-on experience in Shell scripting and Unix/Linux environments.
• Good working knowledge of AIX, Solaris, Linux and Windows operating systems.
• Experience in ETL performance tuning, troubleshooting and job monitoring.
• Understanding of data validation, reconciliation and data quality processes.
• Experience in production support and resolving ETL failures is an advantage.
• Strong analytical, debugging and problem-solving skills.
• Good communication skills and ability to work independently and collaboratively within a technical team.