Data Migration Specialist: ETL, SQL & Validation Expert

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

Job summary

PT Adicipta Inovasi Teknologi in Jakarta Barat is seeking a Data Migration Specialist to lead the extraction, transformation, and loading of client data. You will work closely with the client IT team and project manager to ensure data integrity and timely go-live.

Ideal candidates have a solid background in SQL, relational databases, data dictionaries, and ETL tooling, with experience reading technical docs and communicating complex findings to non-technical stakeholders.

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 migration process automation is a plus.
• Understanding of multifinance business processes and OJK reporting requirements is a plus.
• Detail oriented and structured; strong analytical problem solving; able to communicate findings clearly to non-technical stakeholders.
• Willing to travel and work on-site at client location; weekend/after-hours work may be required.

Responsibilities

• Conduct data migration meetings with client to explain the migration process.
• Prepare Data Dictionary with table structures, data volumes, formats, and data quality.
• Identify data in scope and data to be excluded.
• Define reconciliation items with client for post-migration checks.
• Extract data from legacy systems according to scope and schedule.
• Coordinate with client IT for required data access (db dumps, flat files, API).
• Document extraction method and ensure data integrity during extraction.
• Transform data per Data Mapping Document and cleanse duplicates/invalid values.
• Prepare and execute validation scripts to verify completeness and accuracy.
• Develop production migration plan with sequence, time estimates, and rollback procedures.
• Execute data migration to production in line with go-live schedule.
• Perform post-migration checks and confirm data health before go-live.
• Resolve data migration issues promptly.

Skills

Data migration

SQL proficiency

Relational databases

Technical documentation

Python or Shell scripting

Problem solving

Communication to non-technical

On-site travel

Attention to detail

Education

Bachelor's degree in Information Systems / Computer Science / Informatics Engineering or related field

Tools

PostgreSQL

SQL Server

SSIS or equivalent ETL tool

Job description

PT Adicipta Inovasi Teknologi in Jakarta Barat is seeking a Data Migration Specialist to lead the extraction, transformation, and loading of client data. You will work closely with the client IT team and project manager to ensure data integrity and timely go-live.

Ideal candidates have a solid background in SQL, relational databases, data dictionaries, and ETL tooling, with experience reading technical docs and communicating complex findings to non-technical stakeholders.