onsite
Data/ETL Engineer - Westpac Group
Data Engineer
Data/ETL Engineer responsible for end‑to‑end migration of enterprise data using Informatica, designing transformation logic, optimizing database performance, and building Power BI dashboards to deliver actionable insights.
About the role
Key Responsibilities
- Lead end‑to‑end data migration projects using Informatica, including source analysis, mapping, and load execution.
- Collaborate with business and technical stakeholders to understand data structures and define integration requirements.
- Apply database architecture principles to design, tune, and optimise target schemas for performance and scalability.
- Develop and maintain transformation scripts and workflows to ensure accurate, efficient data movement.
- Build and refine Power BI dashboards and reporting solutions to provide real‑time visibility into migration progress and data quality.
Requirements
- Proven experience with Informatica PowerCenter or similar ETL tools.
- Strong knowledge of relational database design, SQL, and performance tuning.
- Hands‑on experience building Power BI reports and dashboards.
- Excellent communication skills and ability to work cross‑functionally with stakeholders.
- Experience in large‑scale data migration projects is a plus.