ETL Data Developer

Bumi Amartha Teknologi Mandiri; Jakarta Pusat; On-site; IDR 250,000,000 - 400,000,000; Full time

Job summary

Bumi Amartha Teknologi Mandiri is seeking an ETL/Data Engineer to design, develop, and maintain robust ETL/ELT pipelines across diverse data sources. You will optimize SQL queries, store procedures, and data transformation logic, while building scalable data integration workflows for data warehouses and lakes.

You will extract, transform, validate, and load data with emphasis on accuracy and consistency, document mappings, and monitor jobs for performance.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Information Systems, Engineering, or a related field.
• Minimum 2-3 years of experience as an ETL Developer, Data Engineer, or similar.
• Strong proficiency in SQL and relational databases (PostgreSQL, SQL Server, MySQL, Oracle, or similar).
• Experience developing ETL/ELT pipelines using tools such as SSIS, Talend, Informatica, Pentaho, DataStage, Airflow, or equivalent.
• Proficiency in Python for data processing and automation.
• Good understanding of data warehousing concepts, dimensional modeling (Star/Snowflake Schema), and data lake architecture.
• Experience working with APIs, JSON, XML, CSV, and other structured or semi-structured data sources.
• Familiarity with cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP) is an advantage.
• Experience with Git or other version control systems.
• Strong analytical, troubleshooting, and problem-solving skills.
• Good communication skills and the ability to work collaboratively in an Agile environment.

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 while ensuring data accuracy and consistency.
• Analyze source systems and create source-to-target mapping documentation.
• Monitor ETL jobs, troubleshoot failures, and optimize pipeline performance.
• Implement data quality checks, validation rules, and error-handling processes.
• Collaborate with Data Engineers, BI Developers, Analysts, and business stakeholders to understand data requirements.
• Document ETL processes, technical specifications, and data flows.
• Support deployment, maintenance, and continuous improvement of data integration solutions.
• Follow software development best practices, including version control, code reviews, and CI/CD where applicable.

Skills

SQL proficiency

Relational DBs

ETL/ELT pipelines

Python

Data warehousing

Cloud platforms

Version control

Agile teamwork

Education

Bachelor's degree

Tools

SSIS

Talend

Informatica

Pentaho

DataStage

Airflow

Git

Job description

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 while ensuring data accuracy and consistency.
• Analyze source systems and create source-to-target mapping documentation.
• Monitor ETL jobs, troubleshoot failures, and optimize pipeline performance.
• Implement data quality checks, validation rules, and error-handling processes.
• Collaborate with Data Engineers, BI Developers, Analysts, and business stakeholders to understand data requirements.
• Document ETL processes, technical specifications, and data flows.
• Support deployment, maintenance, and continuous improvement of data integration solutions.
• Follow software development best practices, including version control, code reviews, and CI/CD where applicable.

Minimum Qualifications

• Bachelor's degree in Computer Science, Information Technology, Information Systems, Engineering, or a related field.
• Minimum 2-3 years of experience as an ETL Developer, Data Engineer, or similar role.
• Strong proficiency in SQL and relational databases (PostgreSQL, SQL Server, MySQL, Oracle, or similar).
• Experience developing ETL/ELT pipelines using tools such as SSIS, Talend, Informatica, Pentaho, DataStage, Airflow, or equivalent.
• Proficiency in Python for data processing and automation.
• Good understanding of data warehousing concepts, dimensional modeling (Star/Snowflake Schema), and data lake architecture.
• Experience working with APIs, JSON, XML, CSV, and other structured or semi-structured data sources.
• Familiarity with cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP) is an advantage.
• Experience with Git or other version control systems.
• Strong analytical, troubleshooting, and problem-solving skills.
• Good communication skills and the ability to work collaboratively in an Agile environment.