Enterprise Data Warehouse

7 months ago


Kuala Lumpur, Malaysia Hong Leong Bank Full time

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

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.

Job ID JR0000009632


  • Admin Data Entry

    7 months ago


    Kuala Lumpur, Malaysia warehouse Full time

    Location : Jalan Ismail Woking Hour : 9am to 6pm (Monday - Friday) Job Details: - Gathering, collating and preparing documents - Creating digital documents from paper or dictations - Capturing data into database **Requirements**: - Basic knowledge in computer - The ability to manage and process high volumes of data accurately - Good in malay and...

  • Operation Executive

    6 months ago


    Kuala Lumpur, Malaysia Data Solutions Full time

    Company Background: Since 2005, Data Solutions is an MSC-status IT company that is involved in software solutions for: - (i) Road maintenance - (ii) Utilities management - (iii) Fieldcrew service management - (iv) CRM and ERP solutions - (vi) Bespoke enterprise solutions We have dedicated IT data processing teams across offices in Taman Melawati and...

  • Data Designer Analyst

    7 months ago


    Kuala Lumpur, Malaysia Power IT Services Full time

    **Required Technical Skill Set**: EDW design & development in Big Data Platform **Desired Competencies** - Experience in Insurance background - Experience in Enterprise Data - Management function including Enterprise Data Warehouse (EDW), Business Intelligence & Data Governance - Data warehousing experience preferably on big data/cloud platforms and tools -...

  • Data Designer Analyst

    7 months ago


    Kuala Lumpur, Malaysia Power IT Services private limited Full time

    **Required Technical Skill Set**: EDW design & development in BigData Platform **Desired Competencies** Must Have - 5+ Years in Insurance background - Minimum 8 years of experience in Enterprise Data Management function including Enterprise Data Warehouse (EDW), Business Intelligence & Data Governance - Data warehousing experience preferably on big...

  • Data Designer Analyst

    7 months ago


    Kuala Lumpur, Malaysia Power IT Services Full time

    Job Title: Data Designer Analyst Required Technical Skill Set : EDW design & development in BigData Platform Desired Competencies Must Have 5+ Years in Insurance background Minimum 8 years of experience in Enterprise Data Management function including Enterprise Data Warehouse (EDW), Business Intelligence & Data Governance Data warehousing experience...


  • Kuala Lumpur, Malaysia Wilhelmsen Full time

    Join our global team for a career filled with opportunities to solve challenges both small and large, local and global, simple and complex. Wilhelmsen Ship Management is one of the world’s largest providers of third-party ship management services with a presence in over 15 countries. We have established a pool of over 11,000 seafarers supporting more than...

  • Data Warehouse Tester

    4 months ago


    Kuala Lumpur, Malaysia Techtiera Sdn Bhd Full time

    Knowledge of dimensional modelling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts. - Ability to transform complex Business logic into SQL or PL/SQL queries. - Knowledge in SCD types & experience in SCD type 2 validation. - Ensure all sign offs on deliverables (overall test strategy, test plan, test cases, ) and that testing...

  • Data Warehouse Tester

    4 months ago


    Kuala Lumpur, Malaysia amIT Global Solutions Sdn Bhd Full time

    Location : KL Malaysia Payroll under : amIT Global Solutions Sdn Bhd Duration : 12 Months Contract extendable Data warehouse tester Knowledge of dimensional modelling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts. Ability to transform complex Business logic into SQL or PL/SQL queries. Knowledge in SCD types &...

  • Avp, Data Integration

    8 months ago


    Kuala Lumpur, Malaysia Devopsis Technologies Sdn Bhd Full time

    Implement ETL systems that are operationally stable, efficient and automated. This include technical solutions that are scalable, aligned with the enterprise architecture and can adapt to changes in business. - Monitor & optimize batch jobs, including automation & scheduling. Consistently review & enhance performance with key focus on ease of maintenance &...

  • Warehouse Clerk

    7 months ago


    Kuala Lumpur, Malaysia Royal Selangor International Sdn Bhd Full time

    The Warehouse Clerk is responsible for maintaining the efficiency of our warehouse operations and is tasked with ensuring the accurate and efficient handling of inventory. **Key Responsibilities** - Receive and process orders from the sales support team in an accurate and timely manner - Prepare, pack, and scan packages for local and export shipment -...


  • Kuala Lumpur, Malaysia Verinon Full time

    **About the Job** We are seeking an ETL / SQL Server Programmer developer, with experience in creating new data extracts packages or modifying existing packages using SQL Server / SSIS. Development tasks will involve extracting data from a staging area, transferring of the data to the SQL Server data warehouse, performing all associated transformations,...

  • Sales Officer

    6 months ago


    Kuala Lumpur, Malaysia Data Lake Inc Full time

    **Overview** A Data Lake **Sales Officer** plays a very significant role in the growth and success of the overall company. Data Lake Sales Officers are dynamic and results-driven commercial salespersons who focus on promoting and selling Starlink internet devices to enterprise customers across the Philippines. Our Sales Team usually have a background in...

  • Warehouse Assistant

    7 months ago


    Kuala Lumpur, Malaysia EHOME LIVING ENTERPRISE Full time

    Warehouse workers execute the accurate handling, packing and storage of materials in a warehouse. They receive goods, label them, check quality, store the goods and document any damage. Warehouse workers also monitor stock levels of items, keep inventory and ship goods. retail sale of household appliances retail sale of living things SPM / O Level / SKM...


  • Kuala Lumpur, Malaysia Accord Innovations Sdn Bhd Full time

    **Responsibilities**: - Our Requirements- A Bachelor’s degree in IT - Min 4-8 years would be good |8+years’ experience is also fine, in data related work in Warehouse / Data Marts, with at least 2+ years of experience as Hadoop/ETL experience (data processing and scripting). - Hands-on Experience in Sqoop, Hive, HBase, Spark, Oozie, Python, Scala is a...


  • Kuala Lumpur, Malaysia Hong Leong Bank Full time

    Data Analyst, Enterprise Information Management **If you are looking to excel and make a difference, take a closer look at us...** The Data Analyst is responsible to work with various Businesses to understand their needs and requirements. The job holder is also responsible to provide communication, coaching and training to business users related to data...


  • Kuala Lumpur, Malaysia Confluent Full time

    Position at Confluent Malaysia Sdn. Bhd._ With Confluent, organisations can harness the full power of continuously flowing data to innovate and win in the modern digital world. We have a purpose that drives us to do better everyday - we're creating an entirely new category within data infrastructure - data streaming. This technology will allow every...


  • Kuala Lumpur, Malaysia Maxis Full time

    Are you ready to get ahead in your career? - We want to empower you turn your ambitions into achievements. - We thrive in inclusiveness, diversity and embrace close collaborations for you to create impact for yourself and others. - Together, we aim to bring the best of technology to help people, businesses and the nation to be ahead in a changing world. - To...


  • Kuala Lumpur, Malaysia Google Full time

    **Minimum qualifications**: - 7 years of experience promoting analytics, data warehousing, or data management software. - Experience executing commercial and legal agreements with procurement, legal, and business teams. - Experience planning, pitching, and executing a territory sales strategy. - Experience working with sales engineers and customer technical...


  • Kuala Lumpur, Malaysia Google Full time

    **Minimum qualifications**: - 7 years of experience promoting analytics, data warehousing, or data management software. - Experience executing commercial and legal agreements with procurement, legal, and business teams. - Experience planning, pitching, and executing a territory sales strategy. - Experience working with sales engineers and customer technical...

  • Data Analyst

    24 hours ago


    Kuala Lumpur, Malaysia Teleport Full time

    **Title**: Data Analyst Engineer **Company**: **AirAsia** is Asia’s largest low-cost carrier group with over 250 aircraft in operations, comprising of 9 separate airlines across 6 countries (and growing). At **Teleport** we are excited to transform the way air cargo and delivery is managed, sold, and transported in Southeast Asia. We are embracing...