In short
Contract role (to Sept 2027) with a government agency in Melbourne CBD, hybrid: design and deliver migrations of legacy on-prem databases to cloud data warehouses and build integration pipelines using Informatica IICS (CDI/CAI) and advanced SQL (ideally Aurora/Redshift).
About the role
- Contract Until End of September 2027 - Government Agency
- Melbourne CBD Location - Hybrid Working Arrangement
- Informatica IICS and Cloud Data Integration (CDI)
We are seeking an experienced Data Migration & Integration Engineer to join a large government organisation delivering a significant technology modernisation initiative.
The successful candidate will have strong hands-on experience with Informatica IICS, Cloud Data Integration (CDI), Cloud Application Integration (CAI) and advanced SQL.
Key Responsibilities
- Design and deliver data migration solutions, transitioning legacy on-premises databases and repositories to modern cloud data warehouses.
- Develop and maintain data integration pipelines using Informatica IICS (CDI and CAI), supporting incremental and delta data loading.
- Build automated data reconciliation and validation processes to ensure data accuracy across source and target systems.
- Manage data mapping, transformation, historical data conversion and migration activities to support successful system cutovers.
- Collaborate with technical teams and business stakeholders across solution design, development, testing and deployment.
Key Skills and Experience
- Extensive experience working as a Data Migration and Integration Engineer
- Strong hands-on experience with Informatica IICS, particularly Cloud Data Integration (CDI) and Cloud Application Integration (CAI).
- Advanced SQL development skills, including stored procedures, complex queries and cloud database optimisation, ideally involving Amazon Aurora or Redshift.
- Proven experience delivering complex data migrations, ETL/ELT pipelines, data reconciliation and automated validation.
- Experience with Informatica MDM, API integrations (JSON/XML), messaging protocols and cloud-based data architectures.
What's in it for you:
- Contract Until End of September 2027
- Government Agency
- Melbourne CBD/ Hybrid Working Arrangement
Apply now to secure an interview or contact Donal McCann on donal.mccann@talentinternational.com for a confidential discussion.