Informatica ETL Developer-Need Relocate to Kuala Lumpur, Malaysia

Project Description:

Treasury application Production support engagement covering technical issues, services and environment monitoring and EOD Batch support for a leading Singapore based bank

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

3. Database & Data Handling

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