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.

Skilled 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.

#J-18808-Ljbffr

📌 Data Migration and Data Integration Engineer (Melbourne)
🏢 CareCone Group
📍 Melbourne