88 Etl jobs in Kuala Lumpur

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

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.

• 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.

Key Responsibilities:

• Design, develop, and maintain ETL processes using
  Informatica PowerCenter
  or similar tools.
• Work with
  Teradata
  for efficient data extraction, transformation, and loading.
• Implement scalable data processing solutions using
  Hadoop
  ecosystem components (e.g., Hive, Pig, HDFS, Spark).
• Collaborate with data architects, analysts, and stakeholders to understand business requirements and translate them into technical specifications.
• Optimize performance of ETL workflows and Teradata queries for large datasets.
• Perform data quality checks and ensure data integrity across platforms.
• Participate in code reviews, testing, deployment, and documentation processes.
• Troubleshoot and resolve data-related issues in a timely manner.
• Ensure compliance with data governance and security policies.

Required Qualifications:

• Bachelor's degree in computer science
  , Information Technology, or a related field.
• 5+ years
  of hands-on experience in ETL development.
• Proven experience with
  Informatica PowerCenter
  .
• Strong experience in
  Teradata
  including SQL, BTEQ scripting, and performance tuning.
• Working knowledge of the
  Hadoop ecosystem
  (Hive, HDFS, Spark, etc.).
• Solid understanding of data warehouse concepts and best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Knowledge on FSL-DM is good to have.