Informatica DQ Engineer | Azure Synapse & SQL

XPT Software Australia Pty Ltd; 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 | Contract

Brisbane, Australia | Posted on 07/02/2025

• XPT SoftwareAustralia PTY Ltd, incorporated in 2016, is a Software Services company
  
• XPT works with topclients across Australia in Banking, Insurance, Telecom,Retail, Energy, Mining and Manufacturingdomains.
  
• We have 120+technocrats in Australia working at our clientlocations.
  
• XPT SoftwareAustralia is part of group companies which has globalpresence across India & Europe.
  
• We have served100+ clients globally, fulfilling their onsite-offshoreneeds.
  

Job Description

Primary skill-

Informatica DQ and writing, debugging, and optimizing SQL scripts for data extraction, transformation, and validation

Experience with cloud data platforms (Azure Synapse, ADF).

Detailed JD -

• Strong expertise to develop and maintain ETL workflows usingInformatica 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, job failures
  
• Proficiency inwriting, debugging, and optimizing SQL scriptsfor data extraction, transformation, and validation.
  
• Work with relational databases (e.g., SQL Server, Oracle, Azure Data Studio) to support data engineering tasks.
  
• Work closely 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).