Informatica PowerCenter ETL Developer | Data Integration Pro

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

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.