Data Migration and Data Integration Engineer

CareCone Group; Melbourne; Presencial; AUD 110.000 - 170.000; Jornada completa

Descripción de la vacante

CareCone Group in Melbourne is seeking a Data Migration and Data Integration Engineer to design, develop and support data migration and integration solutions as part of modernising legacy systems and moving to cloud platforms.

You will collaborate with data analysts and business stakeholders to deliver reliable migration, reconciliation and data quality controls, building delta-loading pipelines and implementing audit logging.

Formación

• Strong mastery of IICS CDI and CAI.
• Foundational understanding of Informatica MDM concepts.
• Proven experience writing data reconciliation scripts and automated validation routines.
• Deep proficiency in advanced SQL, stored procedures, and cloud DB optimization (Aurora, Redshift).
• Experience with API design (JSON, XML formats) and message-queue protocols.
• Experience with medallion architecture and IICS best practices; ability to deliver unit tests.
• Experience designing migration strategies to extract data from legacy databases into cloud data warehouses.
• Ability to develop and deliver unit tests for solutions and components.

Responsabilidades

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

Conocimientos

IICS CDI & CAI

Informatica MDM concepts

SQL & stored procedures

Cloud data warehouse optimization

API design (JSON/XML) & messaging

Medallion architecture & unit testing

Data migration strategy design

Unit test development for components

Descripción del empleo

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.