Job Title: ETL Professional
This role exists for an experienced data migration specialist to work with a client's banking team, based in Sydney.
You will support data integration and quality initiatives within the program. Your responsibilities will include performing data migrations using Informatica Cloud and PowerCenter, designing and implementing mappings and workflows, and analysing data quality issues.
A successful candidate should have strong knowledge of ETL concepts, SQL, RDBMS, and DWH/BI frameworks, as well as hands-on experience with performance tuning, UNIX environments, and Control-M scheduling.
The ideal candidate will also have excellent problem-solving, communication, and documentation skills, and be able to collaborate effectively with business, data, and technology teams to deliver accurate and secure data solutions.
Key Skills & Experience:
* 5+ years' experience with ETL tools (Informatica IICS/IDMC, PowerCenter).
* Strong knowledge of ETL concepts, SQL, RDBMS, and DWH/BI frameworks.
* Hands-on with performance tuning, UNIX environments, and Control-M scheduling.
* Excellent problem-solving, communication, and documentation skills.
* Preferred: exposure to retail or business banking data models.
Responsibilities:
* Perform data migration and integration using Informatica Cloud (IICS/IDMC) & PowerCenter.
* Design, implement, and document mappings, workflows, and reusable Informatica assets.
* Analyse data quality issues, recommend remediation, and support source-to-target mapping.
* Write SQL queries for data transformation, validation, and performance tuning.
* Develop shell scripts for automation and orchestration.
* Collaborate with business, data, and technology teams to deliver accurate, secure data solutions.