Informatica PowerCenter Developer (ETL development)

Luxoft; Kuala Lumpur; On-site; MYR 60,000 - 120,000; Full time

Job summary

Luxoft is seeking an ETL Developer to join a newly established technology centre in Kuala Lumpur. You will work on ETL development using Informatica PowerCenter and integrate data across AS400, Oracle and Hadoop environments.

Responsibilities include building and maintaining ETL processes, troubleshooting workflows and supporting data processing in AIX/Solaris. 3–5 years of hands-on experience is required.

Qualifications

• 3–5 years of experience in ETL development.
• Proficiency with Informatica PowerCenter 10.x or newer.
• Experience using PowerCenter in AIX/Solaris environments.
• Experience with AS400 and Oracle as source and target systems.
• Knowledge of Hadoop technologies: Hive, Impala, Beeline.
• Strong understanding of ETL and data integration processes.

Responsibilities

• Develop and maintain ETL processes using Informatica PowerCenter 10.x or above.
• Work with AS400 and Oracle databases as source and target systems.
• Support data integration and processing activities in AIX/Solaris environments.
• Perform data extraction, transformation and loading activities.
• Work with Hadoop technologies, including Hive, Impala and Beeline.
• Troubleshoot Informatica workflows and resolve ETL-related issues.
• Support data processing and integration activities across the required platforms.

Skills

ETL development

Informatica PowerCenter 10.x

Informatica PowerCenter in AIX/Solaris

AS400 and Oracle as source/target

Hadoop (Hive, Impala, Beeline)

ETL & data integration knowledge

Tools

Informatica PowerCenter

AS400

Oracle DB

Hadoop

Job description

• Our Client a leading bank in Asia with a global network of more than 500 branches and offices in 19 countries and territories in Asia Pacific, Europe, and North America, are looking for Software Engineers.
• The Technology and Operations function is comprised of five teams of specialists with distinct capabilities: business partnership, technology, operations, risk governance, and planning support and services. They work closely together to harness the power of technology to support our physical and digital banking services and operations. This includes developing, centralising, and standardising technology systems as well as banking operations in Malaysia and overseas branches.
• The client has more than 80 years of history in the banking industry and is expanding its footprint in Malaysia.
• You will be working in a newly set-up technology centre located in Kuala Lumpur as part of Technology and Operations to deliver innovative financial technology solutions that enable business growth and technology transformation.

Responsibilities:

• Develop and maintain ETL processes using Informatica PowerCenter 10.x or above.
• Work with AS400 and Oracle databases as source and target systems.
• Support data integration and processing activities in AIX/Solaris environments.
• Perform data extraction, transformation and loading activities.
• Work with Hadoop technologies, including Hive, Impala and Beeline, as specified in the technical environment.
• Troubleshoot Informatica workflows and resolve ETL-related issues.
• Support data processing and integration activities across the required platforms.

Mandatory Skills Description:

• 3-5 years of experience in ETL development.
• Proficiency in Informatica PowerCenter 10.x or above.
• Experience working with Informatica PowerCenter in AIX/Solaris environments.
• Experience with AS400 and Oracle as source and target systems.
• Knowledge of Hadoop technologies, including Hive, Impala and Beeline, as listed in the client requirement.
• Good understanding of ETL and data integration processes.