Informatica Data Warehouse Engineer

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