
ETL Lead (Informatica)
- Sydney, NSW
- Contract
- Full-time
- 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.
- 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.