Developer (Informatica ETL)

GienTech; Kuala Lumpur; On-site; MYR 90,000 - 130,000; Full time

Job summary

GienTech in Malaysia seeks an experienced Informatica PowerCenter Developer to design, build, and support ETL workflows for the ASEAN region. You will work with AS400 and Oracle as source/target systems and integrate Hadoop technologies for data validation.

The role emphasizes data quality, performance tuning, shell scripting, and collaboration with business analysts and IT teams to deliver reliable data solutions.

Qualifications

• 3–5 years of relevant Informatica ETL development experience.
• Hands-on with Informatica PowerCenter 10.x or above.
• Experience in developing and maintaining ETL mappings, sessions, and workflows.
• Knowledge of ETL development, data integration and data warehousing.
• Experience with AS400 DB2 and Oracle databases.
• Familiarity with Hadoop technologies such as Hive, Impala and Beeline.
• Shell scripting and Unix/Linux environments experience.
• Good communication and teamwork.

Responsibilities

• Design, develop, test, and maintain ETL workflows in PowerCenter 10.x+.
• Develop mappings, mapplets, sessions, and workflows.
• Work with AS400 and Oracle as source and target systems.
• Create and maintain data integration processes.
• Perform ETL development, unit testing, and performance tuning.
• Write Shell scripts to automate data processing.
• Leverage Hadoop Hive, Impala, Beeline for data processing.
• Support deployments and production batch processing.
• Troubleshoot data integration failures and perform root-cause analysis.
• Monitor scheduled ETL jobs for timely completion.
• Ensure data accuracy and quality across systems.
• Collaborate with analysts and stakeholders; prepare documentation.

Skills

ETL development

Data integration

Data warehousing

Shell scripting

Unix/Linux

AS400 DB2

Oracle databases

Tools

Informatica PowerCenter 10.x

Job description

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.