jobs in GienTech

全职 Developer (Informatica ETL) 工作, 薪水, GienTech Federal Territory 公司招聘中 - Ricebowl

Developer (Informatica ETL)

KL City, Federal Territory

分享
保存

工作地点

  • Jalan Sultan Mizan Zainal Abidin, Kompleks Kerajaan Kuala Lumpur Federal Territory Malaysia

职位描述

岗位职责

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.


重要安全守则

申请工作时,切勿提供您的银行或信用卡详细资料。不要转账或完成无关的在线调查问卷。如果您发现可疑内容,请举报此招聘广告。

了解更多