Senior Data Integration Engineer

Randstad; Sydney; On-site; AUD 120,000 - 180,000; Full time

Job summary

Randstad Pty in Sydney is seeking an experienced data integration engineer to design, build, and support scalable data pipelines that connect legacy platforms with modern cloud infrastructure. You will own mapping architectures, workflow development, and integration frameworks while taking technical responsibility for production reliability and automated deployment.

The role requires strong Informatica Cloud CDI expertise, Azure data services, and advanced SQL with performance tuning.

Qualifications

• The role requires hands-on Informatica Cloud CDI development.
• Delivery experience in Microsoft Azure cloud environments.
• Advanced SQL with performance tuning and Snowflake/Teradata knowledge.

Responsibilities

• Design and develop scalable data integration solutions using Informatica Cloud IDMC and CDI
• Implement data integration workflows across Microsoft Azure, SQL Server, Snowflake, and Teradata
• Develop, optimize, and tune complex SQL queries and data-processing workloads
• Implement automated CI/CD pipelines, source control, and deployment processes
• Troubleshoot production performance issues across cloud, database, and Linux environments
• Build reusable automation and frameworks.

Skills

Informatica Cloud CDI

Azure cloud

Advanced SQL

CI/CD pipelines

Linux scripting

Production troubleshooting

Job description

Join an established enterprise technology function modernising critical financial data pipelines. In this role, you will design, build, and support scalable data integration solutions that connect legacy platforms with modern cloud infrastructure. You will own mapping architectures, taskflow development, and integration frameworks, taking technical responsibility for production reliability, continuous automated deployment, and end to end performance optimisation across a complex data landscape.

The Tech Stack & Environment

• Informatica Cloud (IDMC / IICS), Cloud Data Integration (CDI)

• Microsoft Azure (Azure Data Lake Storage, Synapse, Event Hubs)

• Microsoft SQL Server, Snowflake, and Teradata

• Linux/Unix shell scripting, CI/CD pipelines, Git/Bitbucket

What You'll Bring

• Extensive hands on development background in Informatica Cloud (IDMC or IICS), specifically using CDI.

• Practical delivery experience within Microsoft Azure cloud environments.

• Advanced SQL and SQL Server performance tuning, with working knowledge of Snowflake or Teradata.

• Solid Linux shell scripting skills and automated CI/CD pipeline experience.

• Strong track record of enterprise solution design, code reviews, and production troubleshooting.

At Randstad, we are passionate about providing equal employment opportunities and embracing diversity to the benefit of all. We actively encourage applications from any background.

Key Responsibilities

• Design and develop scalable data integration solutions using Informatica Cloud IDMC and CDI
• Implement data integration workflows across Microsoft Azure, SQL Server, Snowflake, and Teradata
• Develop, optimize, and tune complex SQL queries and data-processing workloads
• Implement automated CI/CD pipelines, source control, and deployment processes
• Troubleshoot production performance issues across cloud, database, and Linux environments
• Build reusable automation and frameworks.

Qualification

• Hands-on expertise with Informatica Cloud (IDMC/IICS)
• specifically Cloud Data Integration (CDI)
• Proven experience delivering data integration solutions on Microsoft Azure alongside advanced SQL