Informatica ETL Developer- Relocate to Kuala Lumpur, Malaysia

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