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
   • Write and optimize SQL queries (Oracle / SQL Server)
   • Perform data validation and reconciliation
   • Handle large volumes of structured data
3. Performance Optimization
   • Optimize ETL jobs for better performance and efficiency
   • Troubleshoot performance bottlenecks in E...