Developer (Informatica, Oracle, AS 400)

About the Position

We are seeking a Developer (Informatica, Oracle, AS 400) to join our team in Kuala Lumpur, Malaysia. This role is integral to our client's Technology and Operations function, which is dedicated to harnessing the power of technology to support banking services and operations.

Responsibilities

• ETL Development

  • Design, develop, and maintain ETL workflows using Informatica
  • Perform data extraction, transformation, and loading from multiple source systems
  • Develop reusable ETL components and mappings

• Data Warehouse Support

  • Work on Global Data Warehouse (GDW) systems
  • Ensure data consistency, integrity, and availability
  • Support enhancements and change requests

• Database & Data Handling

  • Write and optimize SQL queries (Oracle / SQL Server)
  • Perform data validation and reconciliation
  • Handle large volumes of structured data

• Performance Optimization

  • Optimize ETL jobs for better performance and efficiency
  • Troubleshoot performance bottlenecks in ETL and database queries

• Testing & Deployment

  • Participate in SIT/UAT testing cycles
  • Validate data accuracy and transformation logic
  • Support deployment and release activities

• Production Support

  • Provide L2 support for ETL and data warehouse issues
  • Troubleshoot job failures and data discrepancies
  • Work with cross-functional teams for issue resolution

Requirements

• Must have
  • 3-5 years of experience in ETL / Data Warehouse development
  • Strong hands-on experience in Informatica ETL
  • Good experience with Oracle and/or SQL Server databases
  • Strong SQL skills for data extraction and transformation
  • Experience in Shell scripting
  • Working knowledge of Operating Systems: AS400, Linux, and Windows environments
  • Understanding of data warehouse concepts (ETL, data modelling, data flows)
  • Banking Experience

We Offer

• Competitive salary
• Opportunity to work in a leading bank with a global network
• Work in a newly setup technology centre in Kuala Lumpur
• Be part of a team delivering innovative financial technology solutions

About the Company

Our client is 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. With more than 80 years of history in the banking industry, they are expanding their footprint in Malaysia.