Informatica DQ Engineer | Azure Synapse & SQL

XPT Software Australia Pty Ltd; City of Brisbane; On-site; AUD 90,000 - 120,000; Full time

Job summary

XPT Software Australia Pty Ltd is seeking an experienced Data Integration Engineer to develop and maintain ETL workflows using Informatica DQ and to optimize SQL-based data extractions. You will design ingestion pipelines from databases and flat files, manage batch jobs, and monitor Informatica services in a cloud-enabled environment.

The role requires hands-on experience with Azure Synapse and Azure Data Factory, strong problem-solving abilities, and collaboration with business and technical

Qualifications

• Strong expertise to develop and maintain ETL workflows using Informatica DQ (Informatica Developer) tool.
• Implement data ingestion and transformation pipelines from diverse sources (databases, flat files).
• Manage and monitor Informatica services, batch jobs and scheduling using Informatica Admin Console.
• Troubleshoot performance issues and job failures.
• Proficiency in writing, debugging, and optimizing SQL scripts for data extraction, transformation, and validation.
• Work with relational databases (e.g., SQL Server, Oracle, Azure Data Studio) to support data engineering tasks.
• Collaborate with business analysts, data analysts, and other technical teams to understand data requirements.
• Strong problem-solving and communication skills.
• Experience with cloud data platforms (Azure Synapse, ADF).

Responsibilities

• Develop and maintain ETL workflows using Informatica DQ.
• Implement data ingestion and transformation pipelines from diverse sources.
• Manage and monitor Informatica services, batch jobs and scheduling.
• Troubleshoot performance issues and job failures.
• Collaborate with business analysts and data teams to understand data requirements.

Skills

SQL scripting

Data extraction

Data transformation

Data validation

Tools

Informatica DQ

Informatica Developer

Azure Synapse

Azure Data Factory

Job description

XPT Software Australia Pty Ltd is seeking an experienced Data Integration Engineer to develop and maintain ETL workflows using Informatica DQ and to optimize SQL-based data extractions. You will design ingestion pipelines from databases and flat files, manage batch jobs, and monitor Informatica services in a cloud-enabled environment.

The role requires hands-on experience with Azure Synapse and Azure Data Factory, strong problem-solving abilities, and collaboration with business and technical