Discover your dream Career
For Recruiters

Enterprise Data Warehouse (EDW) Specialist

Hong Leong Bank Kuala Lumpur, Malaysia
Posted 1 month ago Permanent Competitive
Enterprise Data Warehouse (EDW) Specialist
If you are looking to excel and make a difference, take a closer look at us...

Overview

The EDW Specialist will work closely with users, the ETL (Extract, Transform and Load) team and data modellers to advise and ensure optimization of the database architecture, Logical Data Model (LDM) and Product Data Management (PDM) design best practices. He/she also needs to develop and deliver the Data Lake strategy and roadmap, architecture, guiding principles and best practice. Other key responsibilities are as detailed below:

Key responsibilities

Database management and performance tuning
  • Analyze and perform query fine tuning
  • Monitor and report on system utilization and node performance
  • Tune resource intensive queries using various techniques such as indexing, suggesting rewriting queries, gathering proper statistics, etc.

Data Lake Solution
  • Ensure data optimization and process improvement
  • Develop and ensure timely delivery (e.g. Statutory reporting, Real-time & Batch Campaign)
  • To design, develop, test and implement technical solutions on projects and daily service request

Research & Analysis
  • Perform research on projects, change requests, solution efficiency and problem resolution
  • To support future applications and services by HLB Data Lake solution

Project Management & Production Support
  • Monitor the technical tasks & ensure deliverables are delivered within the project timeline
  • Work with Business PM & IT PM, business users to define & support business UAT
  • Responsible for production support and outages are resolved within expected service levels

Other responsibilities
  • Vendor management•
  • Big Data enhancements
  • R&D activities on new technologies

Jobholder Requirements:

Education/Qualification
  • Malaysian citizen
  • Bachelor's degree from an accredited university or college
  • Professional certification (Teradata/PostgreSQL/Informatica)

Experience & Skillsets
  • Possess 3 to 5 years of similar experience in:
  • Data warehouse architecture with toolset capabilities•
  • Practicing information management best practices
  • SQL knowledge and hands-on (with strong usage)
  • Extract, Transform and Load (ETL) methodology
  • Handling user requirements with at least 2 implementation projects
  • Working knowledge of the following: / Big Data (Hive/Spark)
  • - Systems: Linux / Unix
  • - Utilities: Teradata utilities, Oracle Data Integrator (ODI), Informatica, Netbackup
  • - Database: Teradata / PostgresSQL

About Hong Leong Bank

We are a leading financial institution in Malaysia backed by a century of entrepreneurial heritage. Providing comprehensive financial services guided by a Digital-at-the-Core ethos has earned us industry recognition and accolades for our innovative approach in making banking simpler and more effortless for our customers. Our digital and physical offerings span across a vast nationwide network in Malaysia, strengthened with an expanding regional presence in Singapore, Hong Kong, Vietnam, Cambodia, and China.

We seek to strike a balance between diversity, inclusion and merit to achieve our mission of infusing diversity in thinking and skillsets into our organisation. Candidates are assessed based on merit and potential, in line with our mission to attract and recruit the best talent available. Expanding on our "Digital at the Core" ethos, we are progressively digitising the employee journey and experience to provide a strong foundation for our people to drive life-long learning, achieve their career aspirations and grow talent from within our organisation.

Realise your full potential at Hong Leong Bank by applying now.
Job ID  JR0000009632
More Jobs From Hong Leong Bank
Hong Leong Bank
Data Center Operator
Hong Leong Bank
Kuala Lumpur, Malaysia
11 hours ago Full time Competitive
Hong Leong Bank
Manager, Investment Research & Advisory
Hong Leong Bank
Kuala Lumpur, Malaysia
3 days ago Full time Competitive
Hong Leong Bank
Intern, Human Resources (Learning & Development) (August/September Intake)
Hong Leong Bank
Kuala Lumpur, Malaysia
3 days ago Full time Competitive
Hong Leong Bank
Intern - Structured Solutions
Hong Leong Bank
Kuala Lumpur, Malaysia
3 days ago Full time Competitive
Hong Leong Bank
Executive - Operations & Customer Service
Hong Leong Bank
Kuala Lumpur, Malaysia
4 days ago Full time Competitive
Hong Leong Bank
Manager - Business & Corporate Banking (BCB Bancassurance)
Hong Leong Bank
Kuala Lumpur, Malaysia
4 days ago Full time Competitive
Hong Leong Bank
Executive - Personal Financial Services (Operations & Customer Service)
Hong Leong Bank
Kuala Lumpur, Malaysia
5 days ago Full time Competitive
Hong Leong Bank
Executive - Personal Financial Services (Operations & Customer Service)
Hong Leong Bank
Kuala Lumpur, Malaysia
5 days ago Full time Competitive
Hong Leong Bank
Manager, Risk Management (Operational Risk)
Hong Leong Bank
Kuala Lumpur, Malaysia
5 days ago Full time Competitive
Hong Leong Bank
Mobile Deposit Specialist
Hong Leong Bank
Kuala Lumpur, Malaysia
5 days ago Full time Competitive

Boost your career

Find thousands of job opportunities by signing up to eFinancialCareers today.
Recommended Jobs
Reconciliation Team Lead
EZYPAY
Kuala Lumpur, Malaysia
Changi Airport Group
IT System Senior Associate
Changi Airport Group
Singapore
Affin Bank
Executive, Credit Processing
Affin Bank
Kuala Lumpur, Malaysia