ETL Data Engineer: Scalable Pipelines & Data Lakes

PT Bumi Amartha Teknologi Mandiri; Kemayoran; On-site; IDR 223,200,000 - 468,720,000; Full time

Job summary

AMARTEK seeks an ETL/ELT Developer and Data Engineer to design, develop, test, and maintain data pipelines from multiple sources for our data platforms.

You will optimize SQL queries, build data integration workflows for data warehouses and data lakes, and ensure data quality and integrity. Collaboration with Data Engineers, BI Developers, Analysts, and stakeholders is essential in an Agile environment.

Qualifications

• Bachelor's degree in CS/IT/IS/Engineering or related field.
• 2-3 years of experience as ETL Developer/Data Engineer or similar.
• Strong SQL and relational databases experience.
• Experience with ETL/ELT tools (SSIS, Talend, Informatica, Pentaho, DataStage, Airflow).
• Proficiency in Python for data processing.
• Knowledge of data warehousing concepts and data lake architecture.
• Experience with APIs/JSON/XML/CSV data sources.
• Cloud platform experience (AWS/Azure/GCP) is a plus.
• Git or other version control experience.
• Strong analytical, troubleshooting and collaboration skills in Agile.

Responsibilities

• Design, develop, test, and maintain ETL/ELT pipelines from multiple data sources.
• Develop and optimize SQL queries, stored procedures, and data transformation logic.
• Build and maintain data integration workflows for data warehouses and data lakes.
• Perform data extraction, transformation, validation, and loading with data accuracy.
• Analyze source systems and create source-to-target mapping documentation.
• Monitor ETL jobs, troubleshoot failures, and optimize pipeline performance.
• Implement data quality checks and error handling processes.
• Collaborate with Data Engineers, BI Developers, Analysts, and stakeholders to understand requirements.
• Document ETL processes, technical specifications, and data flows.
• Support deployment, maintenance, and continuous improvement of data integration solutions.
• Follow best practices including version control, code reviews, and CI/CD where applicable.

Skills

SQL

Python

Agile

Data modeling

Analytical thinking

Communication

Education

Bachelor's degree in Computer Science / IT / IS / Engineering

Tools

SSIS

Talend

Informatica

Pentaho

DataStage

Airflow

Git

Job description

AMARTEK seeks an ETL/ELT Developer and Data Engineer to design, develop, test, and maintain data pipelines from multiple sources for our data platforms.

You will optimize SQL queries, build data integration workflows for data warehouses and data lakes, and ensure data quality and integrity. Collaboration with Data Engineers, BI Developers, Analysts, and stakeholders is essential in an Agile environment.