Job Description
XPT Software Australia Pty Ltd | Contract
Sydney , Melbourne , Brisbane, Australia | Posted on 10/06/2026
XPT SoftwareAustralia PTY Ltd, incorporated in ****, is a Software Services company
XPT works with topclients across Australia in Banking, Insurance, Telecom,Retail, Energy, Mining andManufacturingdomains.
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 DescriptionJob Overview
We are seeking an experiencedRedshift Data Engineerwith8+ years of experiencein data engineering and strong hands-on expertise withAmazon Redshift.
The ideal candidate will be responsible for designing, developing, optimizing, and maintaining scalable data platforms and ETL/ELT pipelines on AWS.
Key Responsibilities
Design and develop scalabledata pipelines and ETL/ELT workflowsusing AWS services.
Develop and optimize complexSQL queries, stored procedures, views, and data modelsin Amazon Redshift.
PerformRedshift performance tuning, query optimization, distribution/sort key optimization, and workload management.
Build and maintain data ingestion pipelines from multiple sources intoAmazon Redshift.
Work withAWS Glue, S3, Lambda, Step Functions, and CloudWatchfor data integration and orchestration.
Develop robust data transformation processes usingPython and SQL.
Implement data quality, validation, reconciliation, and monitoring frameworks.
Design and maintaindimensional data models, including fact and dimension tables.




Work with large datasets and optimize data processing for performance and cost.
Implement incremental data loading and CDC (Change Data Capture) strategies.
Troubleshoot data pipeline failures, performance issues, and production incidents.
Collaborate with Data Architects, Business Analysts, Developers, and other stakeholders.
Follow best practices fordata security, governance, access control, and AWS IAM.
Participate in code reviews, technical design discussions, and Agile delivery processes.
Mandatory Skills
8+ years of experience in Data Engineering
Strong hands-on experience withAmazon Redshift
AdvancedSQLskills
StrongPythonprogramming/scriptingexperience
Strong experience withAWS
Hands-on experience withAmazon S3
Experience withAWS Glue
Experience with data warehousing anddimensional data modeling
Solid knowledge ofRedshift performance tuning
Experience with large-scale data processing
Experience with CI/CD andGit
Good understanding of data quality and data governance
Good to Have
Experience withAWS Lambda, Step Functions, EMR, Athena, and CloudWatch
Experience withApache Spark / PySpark
Experience withAirflow
Knowledge ofKafka / streaming data
Experience with CDC tools such asAWS DMS, Debezium, or equivalent
Experience withTerraform / Infrastructure as Code
Exposure toDatabricks, Snowflake, or other cloud data platforms
Experience working inAgile/Scrumenvironments
Technical Skills
Cloud:AWS, S3, Glue, Lambda, Step Functions, CloudWatch
Programming:Python, SQL
DevOps:Git, CI/CD, Terraform
Data Modeling:Star Schema, Snowflake Schema, Dimensional Modeling
#J-*****-Ljbffr

📌 Data Engineer -Redshift (Melbourne)
🏢 Zoho
📍 Melbourne