ETL Process Optimization Specialist

4 days ago


Kuala Lumpur, Kuala Lumpur, Malaysia CIMB Full time
About the Role

We are seeking an experienced Senior ETL Developer to join our team, who can lead the design, development, and optimization of ETL processes. The ideal candidate will have strong leadership skills, excellent analytical and problem-solving abilities, and a proven track record of success in delivering results within a large complex organization.

Key Responsibilities
  • Design, develop, and optimize ETL processes to extract, transform, and load data from diverse data sources into target data stores.
  • Lead a team of ETL developers, providing mentorship, guidance, and technical expertise.
  • Collaborate with business analysts to understand data requirements and ensure ETL solutions are aligned with business needs.
  • Conduct comprehensive testing across all stages of the ETL process, ensuring accurate and reliable data.
  • Implement and enforce ETL development best practices, including robust error handling, detailed logging, and performance tuning.
Required Skills and Qualifications
  • 5-7 years of experience in ETL development and application support, with at least 3 years in a lead or supervisory role.
  • Strong proficiency in ETL tools (e.g. Informatica) and data integration technologies.
  • Experience in RDBMS (e.g. PostgresSQL, SQL Server, DB2, Oracle), data warehousing concepts (e.g. LDM, PDM), and data ingestion framework.
  • Experience in Big Data & Analytics technologies and tools (such as Starburst Galaxy Data Lakehouse, Trino, Iceberg, Kafka, Spark, etc).
  • Experience in UNIX environment and Unix scripting.
  • Knowledge of data modeling, master data management, and data quality principles.
  • Experience in Informatica products, especially Informatica MDM, DEI/DQ, AXON & EDC.


  • Kuala Lumpur, Kuala Lumpur, Malaysia SCIENTE Full time

    We are seeking a highly skilled ETL Process Developer to join our team at SCIENTE. As an ETL Process Developer, you will be responsible for designing and implementing efficient and effective data processing pipelines. Your primary focus will be on developing and maintaining ETL jobs, workflows, and data solutions that meet the needs of our clients.Key Skills...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Krisv Consulting Services Pte Ltd Full time

    Key ResponsibilitiesThe successful candidate will be responsible for:Developing and implementing ETL processes using Informatica PowerCenter.Working closely with business analysts and stakeholders to gather data requirements and design effective ETL processes.Identifying and resolving data quality issues through data profiling and analysis.Maintaining and...


  • Kuala Lumpur, Kuala Lumpur, Malaysia CIMB Full time

    Job DescriptionCIMB, a leading financial services group, is seeking a highly experienced Senior ETL Developer to join our team.About the RoleWe are looking for a talented individual with strong leadership skills and extensive experience in designing, developing, and optimizing ETL processes. The successful candidate will be responsible for leading a team of...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Capco Full time

    About CapcoCapco is a global technology and business consultancy that helps our clients succeed in an ever-changing industry. We are passionate about delivering innovative solutions that drive business value.Job DetailsJob Title: Data Transformation Analyst.Location: Malaysia.Job Type: Full-time.ResponsibilitiesAnalyze and design data migration solutions for...

  • SAS ETL Developer

    4 days ago


    Kuala Lumpur, Kuala Lumpur, Malaysia Capco Full time

    Job DescriptionDetermine and define the technical migration solution for the required in-scope ETLs.Migrate the ETLs from current-state programs onto the appropriate modules in the GCP platform.Assist teams with processing the data migration of dependent datasets as required for production run.Test the accuracy & completeness of the migrated ETL.Create or...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Cognizant Full time

    Job DescriptionCognizant is looking for an experienced ETL Informatica Developer to join our team. The successful candidate will be responsible for designing, developing, and implementing data transformation solutions for our clients in the banking and finance industry.The ideal candidate should have 5+ years of experience in application development or...

  • Cloud ETL Developer

    14 hours ago


    Kuala Lumpur, Kuala Lumpur, Malaysia Capco Full time

    Role DescriptionWe are seeking highly skilled data analysts to join our team. As a data analyst at Capco, you will be working on exciting projects related to ETL migration. Your primary responsibilities will include determining and defining the technical migration solution, migrating ETLs, assisting teams with data migration, testing, and documentation.Job...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Capco Full time

    About CapcoAs a global technology and business consultancy, Capco is dedicated to helping its clients achieve success in the rapidly evolving financial services industry. With a passion for innovation, we empower our clients to stay ahead of the curve.Job DescriptionWe are seeking a highly skilled data analyst to join our team and contribute to the migration...


  • Kuala Lumpur, Kuala Lumpur, Malaysia SCIENTE Full time

    As a Data Integration Specialist at SCIENTE, you will play a key role in designing and implementing end-to-end data pipelines and data integration processes. This includes data analysis, data profiling, data cleansing, data lineage, data mapping, data transformation, and deployment of data solutions.Key ResponsibilitiesDesign, develop, document, and...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Krisv Consulting Services Pte Ltd Full time

    Job DescriptionKrisv Consulting Services Pte Ltd is seeking an experienced Informatica MDM Developer to join our team. The ideal candidate will be responsible for designing, developing, and maintaining ETL processes using Informatica PowerCenter. A minimum of 3-5 years of experience in ETL development, MDM, and a strong understanding of data warehousing...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Cognizant Full time

    Cognizant is seeking an ETL Informatica Developer to join our team. As a key member of our Finance and Accounting practice, you will have the opportunity to work on challenging projects and develop your skills in data integration, finance, and business intelligence.Key ResponsibilitiesDevelop and implement ETL processes using Informatica PowerCenter to...


  • Kuala Lumpur, Kuala Lumpur, Malaysia RegASK Full time

    We are seeking a results-driven Marketing Operations Specialist to join our team at RegASK. As a key member of our marketing operations team, you will be responsible for driving marketing efficiency and effectiveness across our organization.Key Areas of Responsibility• Marketing Automation Management: Configure, manage, and optimize marketing automation...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Cognizant Full time

    Cognizant is a global leader in digital transformation, and we are seeking an ETL Informatica Developer to join our team. As a key member of our Finance and Accounting practice, you will have the opportunity to work on challenging projects and develop your skills in data integration, finance, and business intelligence.Responsibilities:Design and develop ETL...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Avensys Consulting Full time

    Are you a highly skilled Senior SAP S/4 Data Consultant looking for a new challenge? We are seeking an experienced ETL expert to join our team. As a key member of our delivery team, you will be responsible for designing and implementing ETL solutions using SAP Data Services (BODS), LSMW, LTMC, or other ETL tools.The successful candidate will have strong...


  • Kuala Lumpur, Kuala Lumpur, Malaysia AFFIN Group Full time

    We are looking for a highly analytical Performance Optimization Specialist to join our team at the AFFIN Group. The successful candidate will be responsible for identifying bottlenecks, inefficiencies, and gaps in processes and proposing process improvements to enhance productivity, reduce costs, and streamline operations.The ideal candidate will have a...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Exxon Mobil Full time

    About the OpportunityWe are seeking an experienced Manufacturing Digital Solutions Engineer to join our global team. As a key member of our process control and optimization team, you will play a critical role in driving digital transformation and improving manufacturing efficiency.Your ResponsibilitiesYou will be responsible for:Representing the Business...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Unilever Full time

    System Optimization SpecialistThe System Optimization Specialist will play a crucial role in improving Unilever's business performance by leveraging data analytics and decision-making. You will analyze complex business problems and develop innovative solutions using data-driven insights.You will lead functional deep-dive analyses to identify gaps,...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Azeus Systems Limited Full time

    We are looking for an experienced MongoDB professional who can analyze and optimize MongoDB database transactions to enhance performance and scalability.The ideal candidate will have a deep understanding of MongoDB as a backend framework and will be responsible for assessing the current MongoDB setup, identifying performance bottlenecks, and developing...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Touch 'n Go Group Full time

    Process Optimization CoordinatorWe are seeking an experienced Process Optimization Coordinator to join our team at Touch 'n Go Group. As a key member of our organization, you will be responsible for optimizing business processes to enhance efficiency, customer satisfaction, and performance.Your primary focus will be on organizing and driving process...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Link Compliance Full time

    We are seeking a Process Optimization Professional to join our team at Link Compliance.This role involves working on process optimization initiatives, analyzing business processes, and developing solutions to improve efficiency and effectiveness.The successful candidate will have a strong understanding of business processes in finance, sales, purchasing,...