Data Migration Engineer - Contract

About the role

The Data Migration Engineer builds and runs the migration jobs against the conversion specifications. You will take legacy data carrying personal information, move it onto a controlled cloud platform, and prove through reconciliation that nothing was lost or altered on the way.

The role suits an ETL engineer who is comfortable working under regulatory scrutiny and who treats evidence of correctness as part of the deliverable.

Key responsibilities

• Build the extraction, transformation and load jobs against the conversion specifications.
• Build the reconciliation queries and control totals, covering row counts, control totals and referential integrity.
• Execute the migration cycles and resolve the defects they raise.
• Maintain the data lineage record, so every target field can be traced back to its source.
• Contribute to the source-defect register, logging data quality issues found in the legacy systems.

Experience and background

• 3 to 5 years in ETL or data engineering.
• At least 1 of those years on a migration carrying personal data under a government or regulatory regime.
• Has worked on a Government Commercial Cloud platform, or an equivalent controlled cloud environment.

Technical skills

• AWS Glue, PySpark and Python for building the migration jobs.
• SQL at an advanced level across PostgreSQL and legacy platforms, used for extraction and for reconciliation.

Ways of working

You use AI coding tools as part of normal development and review all generated code before committing it. You stay accountable for what ships, which matters most where the data is personal and the checks are formal.

Zenith Infotech (S) Pte Ltd. was started in 1997, primarily with the vision of offering state-of-the-art IT Professionals and solutions to various organizations and thereby helping them increase their productivity and competitiveness. From deployment of one person to formation of whole IT teams, Zenith Infotech has helped clients with their staff augmentation needs. Zenith offers opportunity to be engaged in long term projects with large IT savvy companies, Consulting organizations, System Integrators, Government, and MNCs.