Data Developer

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

Job summary

Luxoft is seeking a skilled ETL/Data Warehouse Developer to join a newly setup technology center in Kuala Lumpur for a major bank client. You will design, develop and maintain ETL workflows using Informatica, build and optimize data integration across Oracle/SQL Server environments, and support GDW data quality and reporting needs.

Your responsibilities include performance tuning, data validation, SIT/UAT support, production issue resolution, and collaboration with cross-functional teams to

Qualifications

• 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).

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 and ensure data consistency, integrity, and availability.
• Write and optimize SQL queries (Oracle / SQL Server).
• Perform data validation and reconciliation and handle large volumes of structured data.
• Participate in SIT/UAT testing cycles and support deployment and release activities.
• Provide L2 production support for ETL and data warehouse issues and collaborate with cross-functional teams.

Skills

ETL / Data Warehouse development

Informatica ETL

SQL

Shell scripting

AS/400

Linux

Windows

Tools

Oracle

SQL Server

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 Consultants to be part of the project
• 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.
• 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.

Responsibilities:

1. 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

2. Data Warehouse Support

• - Work on Global Data Warehouse (GDW) systems
• - Ensure data consistency, integrity, and availability
• - Support enhancements and change requests
• -Write and optimize SQL queries (Oracle / SQL Server)
• - Perform data validation and reconciliation
• - Handle large volumes of structured data

4. Performance Optimization

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

5. Testing & Deployment

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

6. 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

Mandatory Skills Description:

• 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)