Data Migration Specialist

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

• Conduct data migration meeting with client to explain how data migration process will be going
• Prepare Data Dictionary that have explanation about table structures, data volume, formats, data quality
• Identify data in scope for migration and data to be excluded (obsolete historical data, duplicates, etc.)
• Define the reconciliation item agree with the client on what will be reconciled post-migration
• Extract data from the client's legacy system according to the agreed scope and schedule
• Coordinate with the client IT team to obtain required data access (database dump, flat file export, API, etc.)
• Document the extraction method and ensure data integrity during the extraction process.
• Maintain confidentiality and security of client data throughout extraction
• Transform data per the Data Mapping Document: format conversion, reference code alignment, value normalization, and so forth
• Cleanse data of duplicates, inconsistencies, invalid null values, and other anomalies
• Prepare and execute validation scripts to verify completeness, accuracy, and consistency of migrated data
• Prepare a production migration plan (rundown migration): step sequence, time estimates, and rollback procedures
• Execute data migration to the production environment in line with the go-live schedule set by the Project Manager
• Perform post-migration checks to confirm production data is healthy before go-live operations begin
• Resolve data migration issue

REQUIREMENTS

• Min. S1 in Information Systems, Computer Science, Informatics Engineering, or related field
• Proficient in SQL for data extraction, transformation, validation, and reconciliation
• Experienced working 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: debtor data structures, instalment, collateral, and accounting entries is a plus
• Familiarity with OJK reporting requirements for multifinance (SLIK, monthly OJK reports) is a plus
• Detail oriented and structured
• Strong analytical problem solving skill
• Able to communicate technical finding clearly to non technical stakeholder
• Maintains integrity and confidentiality in handling client data
• Willing to travel and work on site at client location
• Willing to work in weekend or after office hour according to project schedule