Oracle DW & ETL Developer — Data Quality Champion

LanceSoft, Inc.

Jakarta Pusat

On-site

IDR 180,000,000 - 240,000,000

Full time

2 days ago

Be an early applicant

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

LanceSoft, Inc. is seeking an experienced Data Warehouse / ETL Developer to support enterprise Data Warehouse development and maintenance.

The role emphasizes Oracle-based data development, ETL processes, data modeling, testing, deployment, and troubleshooting to ensure data quality and consistency. Responsibilities include analyzing requirements, designing ER diagrams, implementing Oracle SQL/PL/SQL logic, and deploying changes on on-premise Oracle databases within an Agile team.

Qualifications

3+ years of experience in Data Warehouse/ETL development or equivalent roles.
Fluent English communication, both written and verbal.
Experience with legacy Data Warehouse systems is a plus.

Responsibilities

Analyze Data Warehouse requirements and prepare technical documentation for development.
Develop and maintain Data Warehouse solutions based on business requirements.
Design ER diagrams for modeled Data Warehouse areas.
Develop complex data-processing logic using Oracle SQL and PL/SQL.
Develop, test, document, and deploy database changes on on-premise Oracle databases.
Design and execute ETL processes to support Data Warehouse requirements.
Create test scripts and perform testing against business logic.
Participate in issue resolution by identifying problems and root causes.
Support maintenance and enhancement of legacy Data Warehouse systems.
Provide refactoring recommendations on Data Warehouse vs. Data Mart and data modeling.