Informatica Developer

FR Consultancy; Sydney; On-site; AUD 120,000 - 150,000; Full time

Job summary

FR Consultancy in Sydney seeks an experienced Senior ETL Developer to design, develop and maintain ETL workflows using Informatica PowerCenter or IICS.

The role involves writing complex SQL for data extraction and loading, collaborating with data architects, analysts and stakeholders, and ensuring data quality through profiling and validation. Independent delivery within deadlines is expected.

Qualifications

• Design, develop and maintain ETL workflows using Informatica PowerCenter or IICS.
• Write and optimise complex SQL queries for data extraction, transformation and loading.
• Collaborate with data architects, analysts and stakeholders to understand requirements.
• Perform data profiling, cleansing and validation to ensure data quality and integrity.
• Monitor and troubleshoot ETL jobs and resolve performance issues.
• Participate in code reviews and follow coding standards and best practices.
• Prepare technical specifications, data flow diagrams and operational documentation.
• Work independently to deliver quality solutions within deadlines.

Responsibilities

• Design, develop and maintain ETL workflows using Informatica PowerCenter or IICS.
• Write and optimise complex SQL queries for data extraction, transformation and loading.
• Collaborate with data architects, analysts and stakeholders to understand requirements.
• Monitor and troubleshoot ETL jobs and resolve performance issues.
• Prepare technical specifications and data flow diagrams.
• Work independently to deliver quality solutions within deadlines.

Skills

ETL Development

SQL querying

Stakeholder collaboration

Tools

Informatica PowerCenter

Informatica IICS

Job description

Status: Valid visa with full working rights

Experience: 5+ years

Requisites:

• Design, develop and maintain ETL workflows using Informatica PowerCenter or IICS.
• Write and optimise complex SQL queries for data extraction, transformation and loading.
• Work with data architects, analysts and business stakeholders to understand requirements.
• Perform data profiling, cleansing and validation to ensure data quality and integrity.
• Monitor and troubleshoot ETL jobs and resolve performance issues.
• Participate in code reviews and follow coding standards and best practices.
• Prepare technical specifications, data flow diagrams and operational documentation.
• Work independently to deliver quality solutions within agreed deadlines.