senior data integration engineer

HR Partners; Sydney; On-site; AUD 140,000 - 190,000; Full time

Job summary

HR Partners is seeking an experienced data integration engineer to design, build, and support scalable data pipelines that bridge legacy data stores with modern cloud infrastructure. You will own mapping architectures, taskflow development, and integration frameworks, ensuring production reliability and automated deployment across a complex data landscape.

You bring hands-on Informatica Cloud CDI development, Azure cloud delivery, and advanced SQL tuning.

Qualifications

• Hands-on Informatica Cloud CDI development and delivery experience.
• Azure cloud implementation and delivery experience.
• Advanced SQL with SQL Server performance tuning; Snowflake/Teradata knowledge a plus.
• Strong Linux shell scripting and automated CI/CD pipeline experience.
• Experience in enterprise solution design, code reviews, and production troubleshooting.

Responsibilities

• Design, build, and support scalable data integration solutions.
• Own mapping architectures, taskflow development, and integration frameworks.
• Ensure production reliability and automated deployment across a complex landscape.
• Optimise end-to-end performance and maintainability in cloud data pipelines.

Skills

Informatica Cloud CDI

Azure cloud

SQL performance tuning

Linux shell scripting

CI/CD pipelines

Code reviews

Production troubleshooting

Enterprise solution design

Tools

Git/Bitbucket

CI/CD tooling

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

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.