ETL Developer

HiLoker; Jakarta Selatan; On-site; IDR 300,000,000 - 460,000,000; Full time

Job summary

CODE.ID adalah perusahaan IT yang berbasis di Indonesia dengan fokus pada pengembangan solusi data dan infrastruktur IT. Posisi ETL Developer/Data Engineer akan bermain peran utama dalam membangun dan memelihara alur ETL/ELT yang mengubah data mentah menjadi insight bisnis.

Anda akan mengoptimalkan pipeline data, mengelola data warehouse, serta berkolaborasi dengan tim analitik untuk memastikan kualitas dan integritas data.

Qualifications

• Berpengalaman 3+ tahun sebagai ETL Developer/Data Engineer.
• Menguasai SQL dan NoSQL secara mendalam.
• Menguasai Python dengan baik.
• Pengalaman atau pengetahuan mengenai fuzzy string matching merupakan plus.
• Berpengalaman dengan cloud platform (AWS) dan layanan terkait seperti AWS Glue, RDS.
• Keterampilan analitik dan pemecahan masalah yang kuat.
• Keterampilan komunikasi teknis untuk bekerja dengan tim data dan arsitek.
• Proaktif dalam mencari solusi serta meningkatkan performa sistem.
• Kebiasaan bekerja dalam lingkungan Agile/Scrum.

Responsibilities

• Merancang, mengembangkan, dan memelihara ETL/ELT workflows dan data pipelines.
• Ekstraksi data dari database, API, file datar, dan sumber data lainnya.
• Transformasi, pembersihan, validasi, dan integrasi data.
• Kembangkan dan optimalkan query SQL, stored procedures, dan objek database.
• Pastikan data akurat, konsisten, dan dapat diandalkan dalam data warehouse.
• Monitor pekerjaan ETL, perbaiki kegagalan, dan selesaikan isu data.
• Lakukan pengecekan kualitas data dan investigasi discrepancy.
• Optimalkan proses ETL untuk performa dan skalabilitas.
• Bekerja sama dengan analis bisnis, data engineer, dan pemangku kepentingan untuk memahami kebutuhan data.
• Menyiapkan dokumentasi teknis untuk proses ETL, pemetaan, alur kerja, dan model data.
• Terlibat dalam deployment, testing, dan dukungan produksi.

Skills

SQL

NoSQL

Python

Fuzzy string matching

Cloud platforms

Agile/Scrum

Data engineering

Education

Sarjana (S1)

Tools

AWS Glue

RDS

Job description

DESKRIPSI PEKERJAAN

• esign, develop, and maintain ETL/ELT workflows and data pipelines.
• Extract data from databases, APIs, flat files, and other data sources.
• Perform data transformation, cleansing, validation, and integration.
• Develop and optimize SQL queries, stored procedures, and database objects.
• Work with data warehouses and ensure data is accurate, consistent, and reliable.
• Monitor ETL jobs, troubleshoot failures, and resolve data-related issues.
• Perform data quality checks and investigate data discrepancies.
• Optimize ETL processes for performance and scalability.
• Collaborate with business analysts, data engineers, and other stakeholders to understand data requirements.
• Prepare technical documentation for ETL processes, mappings, workflows, and data models.
• Participate in deployment, testing, and production support activities.

KUALIFIKASI MINIMUM

• Have experience as ETL Developer/ Data Engineer with 3+ years’ experience
• Have a great knowledge and proficiency in SQL and NoSQL
• Have a great knowledge and proficiency in python
• Having experience or knowledge related to fuzzy string matching is a plus
• Have experience with cloud platform and/or its services, such as AWS, AWS Glue, RDS, etc
• Strong analytical and problem-solving skills
• Good technical communication skills for collaboration with data teams and architects
• Proactive in finding solutions and improving system performance
• Accustomed to working in an Agile/Scrum environment

RINGKASAN PERKERJAAN

• *SPESIALISASI**: IT and Software
• *PENDIDIKAN MINIMAL**: S1 (Sarjana)
• *SISTEM KERJA**: On-site
• *TIPE PEKERJAAN**: Contractual
• *LOKASI**: South Jakarta, DKI Jakarta, Indonesia
• *INDUSTRI**: Information Technology / IT
• *SITUS PERUSAHAAN**: https://www.code.id/

TENTANG PERUSAHAAN

CODE.ID was previously a business unit of INTEGRASI, a system integrator that also provided software services established in 1999. In 2014, CODE.ID becomes an independently run company which currently has around 100 passionate developers with a myriad numbers of skill sets.

CODE.ID has been established since 1999 and became a publicly listed company in Jakarta Stock Exchange in 2001 - as PT Integrasi Teknologi Tbk. It was back to be a private company in 2007.

Our Success Stories:

We successfully developed, deployed, and supported Information Technology Infrastructure for Komisi Pemilihan Umum (KPU) or the National Election Commission in 2004. We developed the election application and also distributed, installed, and supported (7x24 hour) two data centers and 8000 VPN connected personal computers in 5,000 locations in the cities, rural areas, and remote areas all over Indonesia.