About the role
PT Astra Graphia Information Technology is seeking an ETL/Data Engineer to design, build, and maintain data integration pipelines for our HR platform. You will extract data from SAP and other HR sources, perform mapping and cleansing, and validate migrated data with cross-functional teams.
The role requires 2–3 years in ETL/data engineering, strong SQL (PostgreSQL preferred), and Python-based ETL development. Collaboration across BA, SAP, and database teams is essential for successful migrations.
Design, develop, and maintain ETL/data integration pipelines for the HR platform. Extract and transform data from SAP and other HR sources into the new platform. Perform mapping, transformation, cleansing, validation, and reconciliation. Develop reusable ETL processes for master, transactional, and historical HR data. Identify and resolve data quality, mapping, duplication, and migration issues. Collaborate with BA, SAP Functional, Database, Backend, and business teams to validate migrated data. Perform ETL testing, performance optimization, monitoring, and troubleshooting. Prepare data mapping, transformation rules, migration results, and reconciliation documentation. Bachelor's degree in CS/IT or equivalent experience. 2-3 years of ETL, data integration, or data engineering. Strong SQL skills with PostgreSQL preferred. Experience developing ETL pipelines using Python or ETL frameworks. Knowledge of data mapping, transformation, cleansing, validation and reconciliation.