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.
show more