Data Warehouse Support Analyst, GIPS

uobgroup; Malaysia; On-site; MYR 90,000 - 130,000; Full time

Job summary

6255 UOB Innovation Hub 2 Sdn Bhd is seeking an experienced data support and ETL specialist to assist business users with data requests, incident resolution, and data validation within banking operations.

You will analyze SQL, manage ETL pipelines (Infromatica, Informatica-like), work with BI tools, and collaborate with development teams to productionize releases while prioritizing data quality and regulatory reporting.

Qualifications

• Degree in computer science/engineering or related disciplines.
• Minimum 5 years of experience in application development and support environment in Banking Finance, ETL, Data warehouse, and business intelligence
• Mandatory Technical skills: Infromatica , Oracle / MS SQL, Unix/Linux, AS400, Control-M, Shell scripting
• Ability to read and interpret technical documentation, data dictionaries, and ETL (Extract, Transform, Load) job logs.
• Hands on experiences : Teradata, Hadoop Big Data using Cloudera (CDH 5.8 or above), Hive, MS PBI, SSAS will be added advantage.
• 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.
• 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

Responsibilities

• Providing data support to various business users.
• Attend to business queries and business requests promptly.
• Follow through the business requests to a proper closure.
• Working on timely resolution for reported incidents to meet service level targets.
• 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 escape 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

Skills

Infromatica

Oracle/MS SQL

Unix/Linux

AS400

Control-M

Shell scripting

Teradata

Cloudera

Hive

MS PBI

SSAS

Education

Degree in computer science/engineering

Tools

Infromatica

Cloudera

Hive

Job description

Company: 6255 UOB Innovation Hub 2 Sdn Bhd

About UOB

United Overseas Bank Limited (UOB) is a leading bank in Asia with a global network of more than 500 branches and offices in 19 countries and territories in Asia Pacific, Europe and North America. In Asia, we operate through our head office in Singapore and banking subsidiaries in China, Indonesia, Malaysia and Thailand, as well as branches and offices. Our history spans more than 80 years. Over this time, we have been guided by our values - Honorable, Enterprising, United and Committed. This means we always strive to do what is right, build for the future, work as one team and pursue long-term success. It is how we work, consistently, be it towards the company, our colleagues or our customers.

Job Description

Key Responsibilities

• Providing data support to various business users.
• Attend to business queries and business requests promptly.
• Follow through the business requests to a proper closure.
• Working 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 escape 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
• Mandatory Technical skills: Infromatica , Oracle / MS SQL, Unix/Linux, AS400, Control-M, Shell scripting
• Ability to read and interpret technical documentation, data dictionaries, and ETL (Extract, Transform, Load) job logs.
• Hands on experiences : Teradata, Hadoop Big Data using Cloudera (CDH 5.8 or above), Hive, MS PBI, SSAS will be added advantage.
• 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.
• 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

Additional Requirements

Be a Part of the UOB Family

UOB is an equal opportunity employer.

UOB does not discriminate on the basis of a candidate's age, race, gender, color, religion, sexual orientation, physical or mental disability, or other non-merit factors.

All employment decisions at UOB are based on business needs, job requirements and qualifications.

If you require any assistance or accommodations to be made for the recruitment process, please inform us when you submit your online application.