ETL Developer

1 day ago

Kuala Lumpur, Kuala Lumpur, Malaysia Tentacle Infotech Full time 132,000 - 156,000 per year

ETL Developer (Apache NiFi / Data Migration – Banking Domain)

Competencies and Skills

Education

  • Bachelor's Degree in Computer Science, Information Technology, Data Science, or a related discipline.

Experience

  • 4–7 years or 7–9 years of experience in ETL development and data migration within banking or financial institutions.
  • Proven experience working in MSSQL and Oracle database environments.

Key Responsibilities

Requirement, Design & Development

  • Design, develop, and maintain ETL pipelines using Apache NiFi for data extraction, transformation, and loading into MSSQL-based SCDW.
  • Build and maintain data ingestion frameworks to integrate data from multiple regional sources (e.g., BDW, EIS, 1F, OBDA, SASRWA).
  • Develop automated reconciliation and anomaly detection processes between source systems and data warehouses.
  • Ensure auditability, scalability, and fault tolerance in ETL workflow design.
  • Optimize and fine-tune ETL processes for high performance and reliability.
  • Troubleshoot and resolve technical or process-related issues during development, migration, and support phases.
  • Implement controls and validations to ensure data stability, security, and compliance.
  • Collaborate with Group Sustainability, Climate Risk, and data owners to translate business and regulatory reporting needs (e.g., CCPT, GSSIPS, financed emissions) into ETL specifications.
  • Establish data validation, lineage tracking, and documentation to ensure transparency and audit readiness.
  • Support data governance initiatives through standardized data definitions and transformation logic.
  • Ensure compliance with SDLC standards during all stages of ETL development and migration.

Production Support

  • Provide L2/L3 support for existing ETL tasks and batch processing in AMLA applications.
  • Monitor and troubleshoot production ETL workflows to ensure timely and accurate processing.
  • Continuously enhance ETL performance, reducing latency and improving operational efficiency.

Regulatory Compliance

  • Ensure all ETL processes adhere to regulatory requirements (e.g., BNM), internal group policies, and audit standards.
  • Implement external auditor recommendations to maintain data integrity and compliance.

Technical & Functional Skills

  • Strong hands-on experience with Apache NiFi, MSSQL, and data transformation scripting (Python/SQL).
  • Skilled in database design, development, and optimization using MSSQL and Oracle.
  • Experienced with ETL batch processing, workflow automation, and data orchestration tools.
  • Knowledge of data warehouse design, data governance, and metadata management.
  • Familiar with sustainability and climate risk data, ESG metrics, and regulatory disclosure frameworks (e.g., CCPT, TCFD) — an added advantage.
  • Experience in performance tuning for database queries and ETL processes.
  • Good understanding of regulatory compliance requirements in banking applications.
  • Familiar with SDLC processes, including testing, version control, and deployment.
  • Strong analytical, documentation, and stakeholder communication skills.

Job Type: Full-time

Pay: RM11, RM13,000.00 per month

Experience:

  • data transformation scripting (Python/SQL): 1 year (Preferred)
  • data migration: 2 years (Preferred)
  • Apache NiFi, MSSQL: 2 years (Preferred)
  • Banking Domain: 2 years (Preferred)
  • MSSQL and Oracle database environments.: 2 years (Preferred)
  • ETL Developer : 2 years (Required)

Work Location: In person

  • SAS ETL Developer

    3 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Thakral One Full time 40,000 - 60,000 per year

    We are looking for a motivated Junior SAS ETL Developer to join our team. The role is ideal for candidates with foundational knowledge of SAS DI Studio and experience working with relational databases such as Oracle, SQL-Server, or similar platforms. You will support senior developers in building and maintaining ETL processes, ensuring data accuracy and...

  • SAS ETL Lead

    3 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Thakral One Full time $60,000 - $120,000 per year

    The Opportunity.We are seeking an experienced SAS ETL Lead to design, develop, and manage enterprise data integration solutions. The ideal candidate will have strong expertise in SAS DI Studio and hands-on experience working with Oracle, SQL Server, or other relational databases. This role requires both technical proficiency and leadership skills to guide a...

  • ETL & SQL Server Developer (Data Engineer)

    3 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Tentacle Infotech Full time 120,000 - 180,000 per year

    Job Title: ETL & SQL Server Developer (Data Engineer)Technical / Functional SkillsStrong expertise in ETL Data Pipeline tools such as Informatica PowerCenter or Microsoft SSIS.Proficiency in RDBMS technologies, particularly Microsoft SQL Server (MSSQL).Minimum 3+ years of hands-on experience with SQL-compliant RDBMS systems.Minimum 3+ years of experience in...

  • Senior ETL Test Engineer

    3 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia POWER IT SERVICES Full time 90,000 - 120,000 per year

    Must Have:• At least 4 yrs. Quality assurance with exposure/experience in Agile Development environments for DWH/ETL Projects.• Experience with Query Surge automated testing tools or equivalent automation skills.• Can write ETL Testing scripts (using SQL/Python)• Have deep knowledge of Data Warehousing concepts, ETL Process and cloud systems.• Has...

  • ETL Architect

    3 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Lavu Tech Solutions Sdn Bhd Full time 150,000 - 200,000 per year

    Responsibilities:Leads the design of enterprise-level data platforms on Snowflake. Defines architectural standards and guides engineering teams to align data strategies with business goals.Qualifications:Involves deep expertise in data architecture and Snowflake, with responsibilities focused on high-level design and strategic implementation.Common skills...

  • ETL Tester

    3 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Tata Consultancy Services Full time 60,000 - 80,000 per year

    About TCS:Join Tata Consultancy Services, Asia Pacific and be part of an organization committed to sustainable development for our future. TCS follows the Tata group philosophy of building sustainable businesses that are rooted in the community and demonstrate care for the environment. Our unique values position us to combine a purpose-driven worldview with...

  • Software Developer

    1 day ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Tentacle Infotech Full time $60,000 - $120,000 per year

    Software Developer - ETLCompetencies and SkillsEducationBachelor's Degree in Computer Science, Information Technology, Data Science, or a related discipline.Experience4–7 years or 7–9 years of experience in ETL development and data migration within banking or financial institutions.Proven experience working in MSSQL and Oracle database environments.Key...

  • Developer (PL/SQL, ETL, OBIEE)

    3 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Luxoft Full time $60,000 - $100,000 per year

    Project descriptionOur Client a leading bank in Asia with a global network of more than 500 branches and offices in 19 countries and territories in Asia Pacific, Europe and North America are looking for Consultants to be part of the project The Technology and Operations function is comprised of five teams of specialists with distinct capabilities: business...

  • Data & Finance Support Engineer (Informatica ETL- L2)

    1 day ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Krisvconsulting Services Full time $60,000 - $120,000 per year

    Responsibilities:Provide L2 support for Data & Finance applications, addressing incidents, queries, and user requests promptly.Troubleshoot and resolve application issues within SLAs while conducting root cause analysis to prevent recurrence.Manage and support workflows using Informatica ETL and data warehousing tools to ensure data accuracy and...

  • ETL Data Migration

    3 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Agensi Pekerjaan Ideal Reliance Full time 8,000 - 15,500 per year

    Job DescriptionLead data migration analysis and develop the overall migration strategy and plan.Collaborate closely with data owners, business stakeholders, architects, application teams, and the integration lead to understand requirements and define the data migration approach.Assess development efforts and propose a cost-effective, scalable, and reusable...