Data Developer (Informatica, Oracle, AS 400)

About the role

The selected resource will be working in a newly setup 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. 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 physical and digital banking services and operations.

Key responsibilities

• Design, develop, and maintain ETL workflows using Informatica
• Perform data extraction, transformation, and loading from multiple source systems
• Develop reusable ETL components and mappings
• Work on Global Data Warehouse (GDW) systems
• Ensure data consistency, integrity, and availability
• Write and optimize SQL queries (Oracle / SQL Server)
• Perform data validation and reconciliation
• Optimize ETL jobs for better performance and efficiency
• Participate in SIT/UAT testing cycles and support deployment and release activities
• Provide L2 support for ETL and data warehouse issues and troubleshoot job failures

About you

• 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

About us

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. The client has more than 80 years of history in the banking industry and is expanding its footprint in Malaysia.