21 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_hidden***
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