Data Warehouse Support Analyst

Key Responsibilities: Provide application support to various business users. Attend to business queries and business requests promptly. Follow through the business requests to a proper closure. Work on timely resolution for reported incidents to meet service level targets. Incidents include failures & queries reported by business users and technical staff; event alerts automatically detected and reported by event monitoring tool Reverse-engineer / users queries and reports to identify underlying data logic, source systems, and transformation rules. Analyze and interpret complex SQL queries, stored procedures, and data models to trace data lineage and logic. Review and troubleshoot ETL pipelines (Informatica, SSIS) to identify data quality issues, performance bottlenecks, or logic errors. Support data validation, reconciliation, and root cause analysis for data discrepancies in financial reports. Perform root cause analysis to identify permanent solution to prevent recurring incidents and to minimize the impact of incidents that cannot be prevented Ensure all incidents and problems are proactively managed – Prioritizing numerous issues of varying severity and escalate issues as appropriate to necessary teams and management Collaborate with the development team in identifying resolutions and transitioning of releases into production environment Adopt standard Incident and Problem Management workflow and processes, i.e timely ticket, defect and incidents loggings including proper change management processes and quality issue/impacts emails Participate in DR/BCM activities or infrastructure related upgrade Responsible of capacity management. To monitor & analyse current performance and capacity data and forecast the capacity required by the applications ahead Aside from day-to-day support duties, there will be requirements to undertake other responsibilities such as management reporting & other centrally driven project initiatives as needed Key Requirements: Degree in computer science/engineering or related disciplines. Minimum 5 years of experience in application development and support environment in Banking Finance, ETL (Extract, Transform, Load), Data warehouse, and business intelligence Must have working experience in Unix/Windows platforms, batch scheduling tools, Database query skills, BI Tools skillsets Strong understanding of banking products, financial instruments, and regulatory reporting. Ability to read and interpret technical documentation, data dictionaries, and ETL (Extract, Transform, Load) job logs. Mandatory Technical skills: Teradata, Oracle / MS SQL, Unix/Linux, AS400, Control-M, Shell scripting Hands on experiences in Teradata, Hadoop Big Data using Cloudera (CDH 5.8 or above), Hive, MS PBI, SSAS, Informatica. Knowledge of ITIL of similar framework will be advantage. Excellent & proven experience in Incident/Problem Management and organization skills Excellent communication, interpersonal and analytical skills Excellent knowledge of front to back banking business, finance, risk and accounting data across various sectors