Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

CareCone Group

New

Data Migration and Data Integration Engineer

Posted 44 views

Summary

Designs, builds, and supports data migration and integration pipelines as a legacy estate is modernised onto cloud platforms. Day-to-day involves legacy data extraction, schema mapping, delta-loading cutovers, and automated reconciliation, using Informatica IICS (CDI/CAI), advanced SQL with Aurora/Redshift, and JSON/XML APIs.

Job Title : Data Migration and Data Integration Engineer

Location : Melbourne

Mode: Permanent

Job Description:

Role Purpose

The Data Migration & Integration Engineer will be responsible for designing, developing and supporting data migration and integration solutions as part of the modernisation of legacy systems and transition to cloud-based platforms. The role will work closely with technical teams, data analysts and business stakeholders to deliver reliable data migration, integration, reconciliation and validation capabilities, with a strong focus on data quality and successful system cutovers.

Key Responsibilities:

  • Legacy Extraction: Design and execute migration strategies to extract data from legacy on-premises databases and file repositories into modern cloud data warehouses.
  • Schema Evolution: Manage schema mapping changes and historical data conversions while minimising business downtime during cutover windows.
  • Phased Cutover Support: Build incremental, delta-loading pipelines to support parallel runs and phased system cutovers.

Data Reconciliation & Quality Assurance

  • Reconciliation Frameworks: Build and deploy automated data reconciliation pipelines to verify record counts, checksums, and financial/numeric totals across source, staging, and target layers.
  • Audit & Logging: Implement comprehensive operational audit logging and exception-handling frameworks to quickly flag, isolate, and report data discrepancies.
  • Discrepancy Resolution: Collaborate with data analysts and business users to resolve automated data mismatches and refine data reconciliation rules.

Key Technical Skills:

  • Strong mastery of IICS Cloud Data Integration (CDI) and Cloud Application Integration (CAI).
  • Foundational understanding of Informatica MDM concepts (Informatica hosted environments).
  • Proven experience writing data reconciliation scripts and automated validation routines.
  • Deep proficiency in advanced SQL, stored procedures, and cloud database optimization (e.g., Aurora and Redshift).
  • Experience with API design (JSON, XML formats) and message-queue protocols.
  • Experience with medallion architecture, iics best practices, also should be able to deliver unit test cases for the things they are developing.
  • Experience designing and executing migration strategies to extract data from legacy databases into modern cloud data warehouses.
  • Ability to develop and deliver unit test cases for solutions and components being developed.

Professional Attributes:

  • Strong analytical and problem-solving skills.
  • High level of attention to detail, particularly around data quality and reconciliation.
  • Strong communication and collaboration skills across technical and business teams.
  • Effective stakeholder management and ability to work through issues to resolution.
  • Strong delivery focus, with the ability to manage competing priorities and meet deadlines.

Skills

Apply

See also

Software Engineering jobs by country — openings, pay and top skills →