Data Integration Specialist (Melbourne)

Data Integration Specialist (Melbourne)

22 Nov
|
Hays
|
Melbourne

22 Nov

Hays

Melbourne

Role: Data Migration and Integration Engineer

Duration: 30/09/2027

Location: Melbourne CBD

Purpose:

- Designs, develops and supports data migration and integration solutions as part of the modernisation of legacy systems and transition to cloud-based platforms.
- Collaborates with technical teams, data analysts and business stakeholders to deliver reliable data migration, integration, reconciliation and validation capabilities, with a solid focus on data quality and successful system cutovers.

Key Accountabilities:

- Design and execute migration strategies to extract data from legacy on-premises databases and file repositories into modern cloud data warehouses.
- Manage schema mapping changes and historical data conversions while minimising business downtime during cutover windows.
- Build incremental, delta-loading pipelines to support parallel runs and phased system cutovers.
- Actively lead and participate in the ‘end-to-end’ delivery of solutions from business requirements, solution design and build, testing and deployment.
- Build and deploy automated data reconciliation pipelines to verify record counts, checksums, and financial/numeric totals across source, staging, and target layers.
- Implement comprehensive operational audit logging and exception-handling frameworks to quickly flag, isolate, and report data discrepancies.




- Collaborate with data analysts and business users to resolve automated data mismatches and refine data reconciliation rules.
- Perform high-quality unit testing and provide support for integration and system testing of solutions.
- Completion of other required tasks as directed by Manager or Program Director.

Key Selection Criteria

Technical Expertise

- 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 designing and building data pipelines using medallion architecture, applying Informatica IICS best practices, and delivering unit test cases for all developed components.

What you need to do now: If this sounds like you, please click 'Apply Now', or please send your updated CV to

[email protected]

Hays appreciates the importance of workforce diversity and inclusion. We are an equal-opportunities employer and have policies, procedures and relationships in place to promote our understanding of all forms of diversity.

📌 Data Integration Specialist (Melbourne)
🏢 Hays
📍 Melbourne

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data integration specialist (melbourne) / melbourne