XPT Software Australia Pty Ltd | Contract

ETL Technical Business Analyst

Sydney, Australia

- 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

Must Have Skills:

The role involves analysingdata requirements, defining transformation logic, and ensuring high-qualitydata integration across systems. The ideal candidate must have strongexpertise in data analysis, ETL processes, and stakeholder engagement

Nice to Have Skills: Understandingof ETL concepts (Extract, Transform, Load)

Experience with ETL tools such as Informatica MDM,PowerCenter, Talend, DataStage, SSIS, or equivalent

Data Warehousing concepts (EDW, Data Marts,Star/Snowflake Schema)

Data Mapping and Source-to-Target Mapping (STM)documentation

Detailed Job Description We are seeking a skilled Onshore ETL TechnicalBusiness Analyst to bridge the gap between business stakeholders and dataengineering teams. The role involves analysing data requirements,



definingtransformation logic, and ensuring high-quality data integration acrosssystems. The ideal candidate will have solid expertise in data analysis,ETL processes, and stakeholder engagement.

KeyResponsibilities

Requirements & Analysis

- Gather and analyze business and datarequirements from stakeholders
- Translate business needs intofunctional and technical specifications
- Define and document Source-to-TargetMapping (STTM)

Data Analysis &Profiling;

- Analyze source systems, schemas, anddata flows
- Perform data profiling, validation,and quality assessment
- Identify data issues, gaps, andinconsistencies

ETL & Data Integration Support

- Collaborate with ETL developers to:
- Ensure data lineage andtraceability
- Support integration across multiplesystems

Documentation

- Create and maintain:
- Data dictionaries and metadata
- Process and data flow diagrams
- Document business rules andtransformation logic

Testing & Validation

- Support SIT and UAT cycles
- Validate ETL outputs againstbusiness requirements and data rules

Stakeholder Management

- Act as a liaison between business,data engineers, and QA teams
- Facilitate discussions, clarifyrequirements, and resolve issues
- Provide regular status updates anddocumentation

#J-18808-Ljbffr

📌 ETL Technical Business Analyst (New South Wales)
🏢 Xpt Software Australia
📍 New South Wales