Enterprise Data Warehouse (EDW) Specialist
Location: PJC-PJ City
Time Type: Full time
Job Description
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:
Database: Teradat / PostgresSQL / Big Data (Hive/Spark)
- Systems: Linux / Unix
Utilities: Teradata utilities, Oracle Data Integrator (ODI), Informatica, Netbackup
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.
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say