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