If you are looking to excel and make a difference, take a closer look at us…
Overview:
The ETL Developer / Analyst is responsible for designing, coding, and implementing new business application sources to be extracted, transformed and loaded to the data warehouse. This role reports to the ETL Team Lead. Some of the key responsibilities and accountabilities are included below:
-
Consults with users, clients and other technology groups on issues and recommends advanced programming solutions.
-
Accountable for all phases of development process, analysis, design, construction, testing and implementation.
-
Provides user and operational support on applications to business users.
-
Solves / works complex problems / projects through in-depth evaluation of business processes, system processes and industry standards; performs root cause analyses.
-
Engages in post implementation analysis of business usage to ensure successful system design and functionality.
-
Provides sound understanding of Big Data apps development concepts and principles and knowledge of concepts and principles in other technology areas.
-
Provides evaluative judgment based on analysis of factual information in complicated and unique situations.
-
Directly impacts the business by ensuring the quality of work provided by self and others.
-
Impacts own team and closely related work teams. Exhibits sound and comprehensive communication and diplomacy skills to exchange complex information
Jobholder Requirements
-
Malaysian citizen
-
Diploma/Degree in any related field
-
Writes advanced SQL including some query tuning
-
Experience in the identification of data quality
-
Some database design experience is helpful
-
Experience designing and building complete ETL processes moving and transforming data for ODS, Staging, and Data Warehousing
-
Utilize ad-hoc techniques to perform on-the-fly analysis of data
-
Proficient in how to deploy to and debug a production Teradata/DataLake environment
-
Experience with real time and batch data ingestion frameworks
-
Data management or data modeling experience within Big Data (Hive/Impala/Hbase)
-
Informatica/ODI/Teradata experience
-
Hands on Experience with open source software platforms Linux
-
Agile development processes experiences a plus
-
Strong leadership, interpersonal, influence, negotiation, and written and verbal communication skills required.
-
Hands on experience in building SSIS packages
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.
Top Skills
What We Do
Hong Leong Bank Berhad is one of the leading financial services organisations in Malaysia. With a heritage of more than 100 years, it provides comprehensive financial services covering consumer banking, business banking and trade finance, treasury, branch and transaction banking, wealth management, private banking and Islamic financial services. Its merger with EON Bank Group in 2011 has further embedded its position as a core banking franchise with an expanded distribution network of more than 300 branches across the country.
With a proven track record in value creation and a highly recognised brand, Hong Leong Bank has also been extending its footprint in the region, with branches in Singapore and Hong Kong and wholly owned subsidiaries in Vietnam and Cambodia. In China, the Bank has a 20% shareholding in Bank of Chengdu Co., Ltd., Sichuan and a consumer finance joint venture.
Hong Leong Bank is a subsidiary of Hong Leong Financial Group Berhad, the financial services arm of the Hong Leong Group. Apart from banking, Hong Leong Financial Group is involved in the provision of insurance and takaful, as well as investment banking, unit trust, fund management and stock broking services