Informatica Engineer

XPT Software; Sydney; On-site; AUD 120,000 - 160,000; Full time

Job summary

XPT Software Australia PTY Ltd is seeking an experienced Informatica DQ specialist to design and maintain ETL workflows, implement data ingestion and transformation pipelines, and manage batch jobs.

You'll work with SQL Server, Oracle and Azure Data Studio, collaborate with business and data analysts, and apply cloud data platform skills in Azure Synapse and ADF. Strong problem-solving and communication skills are essential.

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, job failures.
• Proficiency inwriting, 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.
• 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).

Responsibilities

• Develop and maintain ETL workflows using Informatica DQ.
• Ingest and transform data from diverse sources.
• Monitor batch jobs and scheduling via Admin Console.
• Troubleshoot performance issues and failures.
• Collaborate with analytics teams to understand data requirements.
• Support data engineering tasks on SQL Server, Oracle, and Azure Data Studio.

Skills

Informatica DQ

SQL scripting

ETL development

Azure Synapse

Tools

Informatica Admin Console

Azure Data Studio

Azure Synapse

ADF

Job description

• 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.

Primary skill

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

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).