Junior ETL Data Engineer

TechTiera; Kuala Lumpur; On-site; MYR 90,000 - 130,000; Full time

Job summary

Jora Malaysia is seeking a data engineer to design scalable ETL/ELT workflows and to develop automation using Python and Shell for data validation and maintenance. The role emphasizes SQL-driven data modeling, analytics-ready schemas, and collaboration with stakeholders to align technical solutions with business needs.

The position requires proficiency with Hadoop ecosystems and Linux-based infrastructure, ensuring robust data services across environments.

Qualifications

• ETL/ELT proficiency: 2–3 years experience with enterprise-grade tools or custom frameworks.
• Advanced SQL: deep knowledge of SQL for data transformation, window functions, and performance tuning.

Responsibilities

• Pipeline development: design scalable ETL/ELT workflows into data warehouse environments.
• Automation scripting: build Python and Shell scripts for data validation and system maintenance.
• Data modeling & optimization: write complex SQL queries and manage schemas for analytics.
• Infrastructure support: manage Linux VMs and cloud-based data services.
• Big data management: leverage Hadoop ecosystem to process large datasets.
• Collaboration: translate business needs into technical data solutions and documentation.

Skills

ETL/ELT proficiency

Advanced SQL

Job description

Jora Malaysia will close on 9th September 2026. Thank you for being with us, we are cheering you on as you continue your career journey.

Pipeline Development: Design and implement scalable ETL/ELT workflows to ingest data from various sources (databases, flat files) into our data warehouse and big data environments.

Develop and maintain automation scripts using Python and Shell (Linux) to streamline data validation, monitoring, and system maintenance.

Data Modeling & Optimization: Write complex, high-performance SQL queries and manage database schema designs to support analytical requirements.

Infrastructure Support: Manage and troubleshoot data services hosted on Linux-based virtual machines and cloud platforms.

Big Data Management: Utilize Hadoop ecosystem tools to process and manage large-scale distributed datasets.

Collaboration: Work closely with stakeholders to translate business requirements into technical data solutions and detailed architectural documentation.

Technical Qualifications

ETL/ELT Proficiency: Minimum 2-3 years of experience in data integration, with hands-on expertise in enterprise-grade integration tools or custom-built frameworks.

Advanced SQL: Deep knowledge of SQL for data transformation, window functions, and performance tuning.