Data Migration and ETL Specialist

PT Adicipta Inovasi Teknologi; Jakarta Barat; On-site; IDR 180,000,000 - 240,000,000; Full time

Job summary

PT Adicipta Inovasi Teknologi seeks a Data Migration Specialist to lead client data migration efforts. You will extract, transform, and validate data from legacy systems, coordinate with client IT, and maintain data integrity and confidentiality on-site at client locations.

The role requires strong SQL skills, experience with relational databases, and ability to read/write technical docs like Data Mappings and Data Dictionaries. Weekend or after-hours work may be required per project schedule.

Qualifications

• Min. S1 in Information Systems, Computer Science, Informatics Engineering, or related field.
• Proficient in SQL for data extraction, transformation, validation, and reconciliation.
• Experienced with relational databases (PostgreSQL, SQL Server, or equivalent).
• Able to read and produce technical data documentation (Data Mapping, Data Dictionary, ERD).
• Familiarity with ETL tools (SSIS or equivalent) is a plus.
• Basic scripting ability (Python or Shell Script) for automation is a plus.
• Understanding of multifinance business processes and OJK reporting is a plus.
• Detail oriented and structured.
• Strong analytical problem solving skill.
• Ability to communicate technical findings to non-technical stakeholders.
• Willing to travel and work on-site.

Responsibilities

• Conduct data migration meeting with client to explain data migration process.
• Prepare Data Dictionary with table structures, data volume, formats, data quality.
• Identify data in scope for migration and data to be excluded.
• Define reconciliation items agreed with client post-migration.
• Extract data from legacy system according to scope and schedule.
• Coordinate with client IT for data access (DB dump, flat file export, API).
• Document extraction method and ensure data integrity during extraction.
• Maintain confidentiality and security of client data during extraction.
• Transform data per Data Mapping Document: format conversion, code alignment, value normalization.
• Cleanse data of duplicates, inconsistencies, invalid nulls and anomalies.
• Prepare and run validation scripts for completeness, accuracy, consistency.
• Prepare production migration plan: steps, estimates, rollback procedures.
• Execute data migration to production environment per go-live schedule.
• Perform post-migration checks to confirm data health before go-live.
• Resolve data migration issues.

Skills

SQL

Relational DBs

Data Mapping

Data Dictionary

ERD

Python

Shell Script

Data Cleansing

Data Validation

Documentation

On-site Travel

Education

Bachelor's degree in Information Systems

Tools

PostgreSQL

SQL Server

SSIS

Job description

PT Adicipta Inovasi Teknologi seeks a Data Migration Specialist to lead client data migration efforts. You will extract, transform, and validate data from legacy systems, coordinate with client IT, and maintain data integrity and confidentiality on-site at client locations.

The role requires strong SQL skills, experience with relational databases, and ability to read/write technical docs like Data Mappings and Data Dictionaries. Weekend or after-hours work may be required per project schedule.