Sueprannuation ETL Development and reconciliation
15th February, 2025
About the Role
We are seeking a highly skilled ETL Developer with strong SQL expertise and experience or willingness to learn industry-leading ETL transformation tools such as Informatica and Databricks. This role is crucial in delivering high-quality data migration and transformation solutions within the Superannuation domain, with a strong preference for candidates with Superannuation registry experience.
An ideal candidate will have experience in data reconciliation and the ability to develop reconciliation frameworks to validate ETL processes, ensuring data integrity and accuracy.
Key Responsibilities
1. Design, develop, and optimize ETL pipelines for data migration and transformation.
2. Write complex SQL queries, stored procedures, and scripts to manipulate, validate, and transform large datasets.
3. Work with Informatica, Databricks, and other ETL tools to build scalable data processing solutions.
4. Ensure data reconciliation by developing robust reconciliation frameworks to validate transformed data against source systems.
5. Collaborate with business and technical teams to understand requirements and translate them into efficient ETL solutions.
6. Maintain data quality and consistency, ensuring compliance with Superannuation industry standards and regulations.
7. Troubleshoot ETL processes, identify issues, and optimize performance.
Key Skills & Experience
1. Experience in or ability to learn Informatica, Databricks, or similar ETL tools.
2. Superannuation domain expertise is essential, with Superannuation registry experience preferred.
3. Experience in data reconciliation and validation frameworks to ensure accuracy and completeness of ETL processes.
4. Hands-on experience in data migration projects, especially in financial services or Superannuation.
5. Ability to analyze large datasets, troubleshoot ETL failures, and resolve data quality issues.
6. Strong analytical and problem-solving skills, with attention to detail.
7. Excellent communication skills to work effectively with stakeholders.
#J-18808-Ljbffr