Senior Analyst, Data

6255 UOB Innovation Hub 2 Sdn Bhd; Malaysia; On-site; MYR 120,000 - 180,000; Full time

Job summary

6255 UOB Innovation Hub 2 Sdn Bhd is seeking a System Analyst, Data for its EDW Enterprise Wholesale team. You will own end-to-end projects, build data mappings, and support SIT, UAT and post-production activities for EDW and QR items.

The role requires strong Teradata/SQL skills, Informatica PowerCenter (V10+), Hadoop experience, SDLC understanding and data modelling expertise. Collaboration with IT and business partners is essential.

Qualifications

• 7+ years related work experience required.
• Expertise in Teradata and SQL, Informatica PowerCenter V10+, and Hadoop ecosystem (Hive/Impala).
• Understanding of SDLC and database performance tuning.
• Experience in data mapping, modelling and impact assessment.
• Knowledge of Python and Unix scripting is a plus.

Responsibilities

• Review requirements and translate into high-level and low-level documentation, including source-to-target mappings.
• Own end-to-end projects and CRs from inception to production support.
• Assist development teams on queries and support SIT/UAT testing.
• Attend SIT/UAT Jira tasks and comply with SLAs.
• Coordinate with production support for post-live validations and issues.

Skills

Teradata & SQL

Informatica PowerCenter

Hadoop (Hive/Impala)

SDLC

Database tuning

Data mapping & modelling

Impact assessment

Python

Unix scripting

Tools

Beeline

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

The System Analyst, Data role is part of IH2's EDW Enterprise Wholesale team and is responsible for A&D, building data mappings, maintain data dictionaries, support SIT, UAT and post-production support for Projects & QR items for EDW. You will take ownership of end to end projects / deliver CRs as a System Analyst and ensure delivery on schedule and in excellent quality.

Key Responsibilities

• Responsible for reviewing and understanding requirements and translating them into high-level and low-level documentation including source to target mapping
• Responsible for Building Functional Specifications, data mappings, and data dictionary that maintains the current EDW / SDM standards
• Responsible to own the entire Project / CRs from inception to production support
• Assist development teams on queries pertaining to the development & also support SIT / UAT testing
• Attend to SIT / UAT Jira’s and abide to the SLAs
• Work with production support teams as required to support production activities & post-live validations
• Must have impeccable written and oral communication skills down to the mapping documentation level
• Ensure that documentation is captured, maintained, understood by and available to business and/or IT partners
• Escalate critical technical issues and potential problems as needed to the Project Manager/ TDM to address any related issues in advance of deadlines
• Should able to communicate with users and support their queries

Key Requirements

• Must have over 7 years related work experience.
• Extensive knowledge & experience in Teradata and SQL, Informatica PowerCenter V10+
• Experience on Database Hadoop (Hive, Impala, beeline)
• Understanding of software development lifecycle methodology
• Exposure in database tuning would be an advantage
• Exposure in Data Mapping & Modelling, Impact Assessment
• Knowledge in Python & Unix scripting would be an added advantage

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.

We value our people and invest in them as we look to fulfil our purpose of building the future of ASEAN. We seek to create a collaborative and progressive environment for them to succeed in their careers for the long term.

UOB is rated as one of the world's top banks, ranked 'Aa1' by Moody's Investors Service and 'AA-' by both S&P Global and Fitch Ratings. With a global network of 500 branches and offices across 19 countries in Asia Pacific, Europe and North America. In Asia, we operate through our head office in Singapore and banking subsidiaries in China, Indonesia, Malaysia, Thailand and Vietnam, as well as branches and offices throughout the region.

Career Site: UOB Career site