ETL Technical Business Analyst

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 strong 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