244 Etl jobs in Malaysia

ETL Developer

Location: Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

• Proven experience as a data developer within the banking and finance industry or ideally asset servicing.
• Experience with ETL tools (Platform Talend Big data).
• Strong hands-on expertise with Apache Spark (PySpark or Scala-based jobs is a plus).
• Proficiency in SQL and optimizations (performance tuning).
• Understanding of relational and columnar databases.
• Familiarity with Data Lake architectures and distributed data processing concepts.

Lead Recruiter / Lead Talent Acquisition Partner

Job Summary:

HCLTech is seeking a highly skilled and experienced ETL Developer to join our finance technology team. The ideal candidate will have hands-on expertise in Informatica PowerCenter 10.5.6 and a strong understanding of data integration, transformation, and loading processes within the financial services domain. You will be responsible for designing, developing, and maintaining robust ETL workflows that support critical business intelligence and data warehousing initiatives.

Role: ETL Developer focused on finance data, data integration, and ETL workflow development using Informatica PowerCenter 10.5.6.

• Design, develop, and maintain ETL processes using Informatica PowerCenter 10.5.6 .
• Collaborate with business analysts, data architects, and stakeholders to understand data requirements and translate them into technical solutions.
• Optimize ETL performance and troubleshoot data issues across large-scale financial datasets.
• Ensure data quality, integrity, and compliance with financial regulations and internal standards.
• Participate in code reviews, unit testing, and deployment activities.
• Document ETL processes, data mappings, and workflows for audit and operational purposes.
• Support production environments and resolve data-related incidents in a timely manner.

• Minimum 5 years of experience in ETL development, preferably in the finance industry .
• Solid understanding of SQL , data warehousing concepts , and data modeling .
• Experience with financial data systems , reporting, and compliance requirements.
• Familiarity with version control , job scheduling tools , and data governance practices .
• Excellent problem-solving, analytical, and communication skills.
• Bachelor’s degree in Computer Science, Information Systems, or related field.

• Experience with cloud-based ETL tools or data platforms (e.g., Azure Data Factory, AWS Glue).
• Knowledge of finance-specific KPIs , risk management , or regulatory reporting .
• Exposure to Agile/Scrum methodologies .

• Seniority level: Mid-Senior level
• Employment type: Contract
• Job function: Information Technology
• Industries: IT Services and IT Consulting

Referrals increase your chances of interviewing at HCLTech by 2x

ETL PENTAHO DEVELOPER ENGINEER

As a ETL Engineer, you will be responsible for extracting and ingesting data from websites using web crawling tools. In this role you will own the creation process of these tools, services, and workflows to improve crawl/ scrape analysis, reports, and data management.

We will rely on you to test the data and the scrape to ensure accuracy and quality. You will own the process to identify and rectify any issues with breaks as well as scale scrapes as needed.

Job Responsibilities

· Should be able to perform data extraction, data loading solving the errors, checking filter criteria.

· Understanding on the steps - input, output, and connection to database.

· Understanding on job/transformation, inspecting the data.

· Understanding on salesforce basics - fields, objects, and lookups.

· Knowledge on schema, database, views.

· Provide technical knowledge/expertise to support the requirements definition, design, and development of data warehouse components/subsystems, specifically Extract-Transform Load or Extract-Load-Transform technologies and implementations and/or Change Data Capture technologies and implementations.

· Getting fallout report and analyzing the bugs and errors, should understand how to get output file.

· Research, design, develop, and modify the ETL and related database functions, implementing changes/enhancements to the system.

· Design ETL processes and develop source to target transformations, and load processes.

Requirements:

· Bachelor's degree in computer science or a related field or the equivalent demonstrated experience

· Must have at least 3 - 5 years of experience in Pentaho

· Experience running large scale web scrapes

· Experience with Linux/UNIX, HTTP, HTML, JavaScript, and Networking

· Experience with techniques and tools for crawling, extracting, and processing data.

· Great communication skills (written and Spoken in English)

Good to have:

· Familiarity with system monitoring/administration tools

· Familiarity with version control, open-source practices, and code review

· Familiarity with Python SQL

Job Type: Full-time

Pay: Up to RM6,500.00 per month

Benefits:

• Maternity leave
• Opportunities for promotion
• Parental leave
• Professional development

Application Question(s):

• Do you have Pentaho?

Work Location: In person

If you are looking to excel and make a difference, take a closer look at us…

Functional (job responsibilities)

• 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

Managerial (team/group responsibilities)

• Support the division & department deliverables

Organizational (organizational responsibilities)

• Work closely with Department & Section Head to set department direction and AAM according to division and corporate vision
• Work closely with all levels of staff to achieve corporate goals and objectives

Experience

• Writes advanced SQL including some query tuning
• Experience in the identification of data quality
• Experience working with Stored Procedures
• 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 EDW environment

• Experience with real time and batch data ingestion frameworks will be plus
• Data management or data modeling experience within Big Data (Hive/Impala/Hbase) will be plus
• Informatica/Shell Scripting / SSIS Packages/ SQL 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.

Job Purpose

As a Senior Data Engineer, you are responsible for designing, developing, and implementing scalable data store solutions that support both operational and strategic business needs. The role demands strong technical expertise, a proactive mindset, and a commitment to continuous improvement, compliance, and innovation in data engineering practices.

The Job

• Design, develop, and implement data store solutions to support operational and business needs.
• Build and maintain robust ETL pipelines using Talend and implement automated deployment workflows for these ETL processes with CI/CD tools.
• Develop, optimize, and tune Oracle PL/SQL queries, procedures, and packages to ensure high performance and reliability.
• Ensure data quality, integrity, and security across all data platforms.
• Monitor, troubleshoot, and resolve data workflow and performance issues proactively.
• Translate business requirements into effective technical solutions, ensuring alignment throughout the project lifecycle.
• Prepare and maintain comprehensive documentation for technical designs, data flows, and operational procedures.
• Perform thorough testing to guarantee solution reliability and data integrity.
• Collaborate with project managers, business analysts, and cross-functional teams to ensure solutions meet business goals and stakeholder expectations.
• Support implementation activities and provide post-launch support to ensure smooth operations.
• Conduct system performance tests and implement improvements as needed.
• Work closely with the delivery team to deliver systems according to specifications, tracking assigned tasks to meet project schedules and quality standards.
• Take ownership of assigned deliverables, proactively identify areas for improvement, and implement solutions. Demonstrate initiative in addressing issues, optimizing processes, and proposing innovations to enhance data engineering practices.
• Takes accountability in considering business and regulatory compliance risks and takes appropriate steps to mitigate the risks.
• Maintains awareness of industry trends on regulatory compliance, emerging threats and technologies in order to understand the risk and better safeguard the company.
• Highlights any potential concerns /risks and proactively shares best risk management practices.

Our Requirements

• Minimum 7 years of hands-on experience in Talend ETL development.
• At least 5 years of end-to-end experience designing, building, and implementing data store/data marts/data warehouses.
• Strong proficiency in Oracle PL/SQL development, including performance tuning and optimization.
• Strong knowledge of key Oracle performance features such as query optimizer, execution plans, and indexes.
• Experience working with Oracle Autonomous Database (ADB) is preferred.
• Solid understanding of data modeling, data governance, and data integration best practices.
• Excellent technical skills in ETL tools for integration with Oracle and other RDBMS databases.
• Good technical skills in UNIX shell scripting and scheduling.
• Have experience working in Agile environments with distributed, cross-functional teams.
• Ability to evaluate, understand, and implement detailed business, functional, and non-functional technical requirements.
• Experience in the financial services industry is an advantage.
• Excellent problem-solving skills, attention to detail, and the ability to approach challenges from multiple perspectives.
• Strong communication and collaboration abilities.
• Independent team member capable of making sound judgment calls in fast-changing or ambiguous environments.
• High level of integrity, takes accountability of work and good attitude over teamwork.
• Takes initiative to improve current state of things and adaptable to embrace new changes.

Job Purpose

To assist and support Head and AVP of Business Intelligence & Data Management in implementing assigned initiatives, including new application development, change requests and post production support for Data Warehouse & Business Intelligence Applications; ensuring a timely and accurate delivery.

Job Description

• Execute project/application development activities and deliverables.
• Work with user and project teams and various internal and external parties in understanding project and system requirements.
• Execute all activities / tasks and deliver as per instructed by Head and AVP of Business Intelligence & Data Management.
• Support and maintain the system.

Competencies

• Good command of English.
• Experience working with Microsoft Office (Word, Excel and Power Point).
• Programming language: MS Windows, Unix, Oracle database & Business Intelligence development tool, Java, MS Office suite, Oracle SQL Developer (SQL scripting), ETL tool, Informatica suite (PowerCenter, MDM), Qlikview BI, etc.
• Understanding of SDLC methodology
• Practicing scrum/agile development

• To assist and support Head and AVP of Business Intelligence & Data Management in implementing assigned initiatives, including new application development, change requests and post production support for Data Warehouse & Business Intelligence Applications; ensuring a timely and accurate delivery.
• Execute project/application development activities and deliverables.
• Work with user and project teams and various internal and external parties in understanding project and system requirements.
• Execute all activities / tasks and deliver as per instructed by Head and AVP of Business Intelligence & Data Management
• Support and maintain the system.
• Qualification
• Degree
• Years of Experience: 1 – 3 years (Executive) 4 – 8 years (Senior Executive)
• ETL tool, Informatica suite (PowerCenter, MDM), Qlikview BI, etc. Apache Kafka
• Understanding of SDLC methodology
• Practicing scrum/agile development
• Experience working with Microsoft Office (Word, Excel and Power Point).
• Programming language: MS Windows, Unix, Oracle database & Business Intelligence development tool, Java, MS Office suite, Oracle SQL Developer (SQL scripting),

Job Type: Full-time

Benefits:

• Dental insurance
• Flexible schedule
• Free parking
• Health insurance
• Maternity leave
• Meal allowance
• Opportunities for promotion
• Parental leave
• Professional development
• Vision insurance

Application Question(s):

• Are you authorized to work in Malaysia?
• Are you available immediately?
• Do you require a work visa ?
• Do you have 1 – 3 years / 4 – 8 years related experience?
• ETL tool, Informatica suite (PowerCenter, MDM), Qlikview BI, etc. Apache Kafka
• MS Windows, Unix, Oracle database & Business Intelligence development tool
• Java, MS Office suite, Oracle SQL Developer (SQL scripting)
• SDLC methodology
• scrum/agile development
• Execute project/application development activities and deliverableles

Language:

• English (Required)

Work Location: In person

Proven experience as a data developer within the banking and finance industry or ideally asset servicing.

• Experience with technologies such as ETL tools (PlatformTalend Big data)

• Strong hands-on expertise with Apache Spark (PySpark or Scala-based jobs is a plus).

• Proficiency in SQL and optimizations (performance tuning)

• Understanding of relational and columnar databases.

• Familiarity with Data Lake architectures and distributed data processing concepts.

Senior ETL Developer

Job Description:

• The ideal candidate should have a strong background in ETL processes, data integration, and relevant technologies such as Informatica, ODI, and either Teradata or Hadoop. As an ETL Developer, you will play a critical role in designing, developing, and maintaining data pipelines to ensure accurate and efficient data integration for our Banking operations.

Roles and Responsibilities:

• Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our Banking data warehouse.
• Collaborate with business analysts and stakeholders to understand data requirements, data mappings, and transformations needed for accurate data integration.
• Implement data quality checks and data validation processes to ensure the integrity of the data being processed.
• Work closely with the data architecture team to optimize data models and schemas for efficient data storage and retrieval.
• Troubleshoot and resolve data-related issues and performance bottlenecks in ETL processes.
• Perform performance tuning and optimization of ETL workflows to enhance data processing efficiency.
• Develop and maintain documentation of ETL processes, data mappings, and transformations for reference and auditing purposes.
• Participate in code reviews, ensuring adherence to best practices and data integration standards.
• Stay updated with the latest industry trends and advancements in ETL and data integration technologies.

Required Skills:

• Experience as an ETL Developer in the Banking domain.
• Strong proficiency in ETL tools such as Informatica and/or ODI.
• Hands-on experience with either Teradata or Hadoop for data storage and processing.
• Solid understanding of data integration concepts, data warehousing, and ETL methodologies.
• Proficiency in SQL for data querying, manipulation, and validation.
• Familiarity with data modeling, data quality, and data governance practices.
• Ability to work effectively in a team and collaborate with cross-functional stakeholders.
• Excellent problem-solving skills with the ability to analyze complex data-related issues.
• Strong communication skills to convey technical concepts to non-technical stakeholders.
• Attention to detail and a commitment to producing high-quality work.
• Experience with version control systems and agile development methodologies is a plus.