ETL Lead (Informatica)

We are seeking a highly skilled and experienced ETL Lead with a strong background in Informatica to support data migration, integration, and quality initiatives for our client's UNITE program.

The ideal candidate will be a hands-on technical leader, ready to take ownership of end-to-end data processes and collaborate with cross-functional teams to deliver accurate and secure data solutions.

Key Skills and Experience

• 5+ years of experience with ETL tools, specifically Informatica IICS/IDMC and PowerCenter.
• A strong understanding of ETL concepts, SQL, RDBMS, and DWH/BI frameworks.
• Hands-on experience with performance tuning, UNIX environments, and Control-M scheduling.
• Proven experience in large-scale data migration programs, including archiving and purging initiatives.
• Excellent problem-solving, communication, and documentation skills.
• Prior exposure to retail or business banking data models.

Key Responsibilities

• Perform data migration and integration using Informatica Cloud (IICS/IDMC) and PowerCenter.
• Design, implement, and document mappings, workflows, and reusable Informatica assets.
• Analyse data quality issues, recommend remediation strategies, and support source-to-target mapping.
• Write and optimise SQL queries for data transformation, validation, and performance tuning.
• Develop shell scripts for automation and orchestration tasks.
• Collaborate with business, data, and technology teams to deliver secure and high-quality data solutions.

If you're an experienced ETL lead ready to take on complex challenges and drive impactful solutions, we encourage you to apply or send your CV to jorden.ortez@randstaddigital.com.au.

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