Job Description
XPT Software Australia Pty Ltd | Contract
n
Sydney , Melbourne , Brisbane, Australia | Posted on 10/06/2026
n
n
XPT SoftwareAustralia PTY Ltd, incorporated in ****, is a Software Services company
n
XPT works with topclients across Australia in Banking, Insurance, Telecom,Retail, Energy, Mining and
Manufacturingdomains.
n
We have 120+technocrats in Australia working at our clientlocations.
n
XPT SoftwareAustralia is part of group companies which has globalpresence across India & Europe.
n
We have served100+ clients globally, fulfilling their onsite-offshoreneeds.
n
Job DescriptionJob Overviewn
n
We are seeking an experienced
Redshift Data Engineer
with
8+ years of experience
in data engineering and strong hands-on expertise with
Amazon Redshift
. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining scalable data platforms and ETL/ELT pipelines on AWS.
Key Responsibilitiesn
n
n
Design and develop scalable
data pipelines and ETL/ELT workflows
using AWS services.
n
Develop and optimize complex
SQL queries, stored procedures, views, and data models
in Amazon Redshift.
n
Perform
Redshift performance tuning
, query optimization, distribution/sort key optimization, and workload management.
n
Build and maintain data ingestion pipelines from multiple sources into
Amazon Redshift
.
n
Work with
AWS Glue, S3, Lambda, Step Functions, and CloudWatch
for data integration and orchestration.
n
Develop robust data transformation processes using
Python and SQL
.
n
Implement data quality, validation, reconciliation, and monitoring frameworks.
n
Design and maintain
dimensional data models
, including fact and dimension tables.
n




Work with large datasets and optimize data processing for performance and cost.
n
Implement incremental data loading and CDC (Change Data Capture) strategies.
n
Troubleshoot data pipeline failures, performance issues, and production incidents.
n
Collaborate with Data Architects, Business Analysts, Developers, and other stakeholders.
n
Follow best practices for
data security, governance, access control, and AWS IAM
.
n
Participate in code reviews, technical design discussions, and Agile delivery processes.
n
Mandatory Skillsn
n
n
8+ years of experience in Data Engineering
n
Strong hands-on experience with
Amazon Redshift
n
Advanced
SQL
skills
n
Strong
Python
programming/scripting
experience
n
Strong experience with
AWS
n
Hands-on experience with
Amazon S3
n
Experience with
AWS Glue
n
Experience with data warehousing and
dimensional data modeling
n
Strong knowledge of
Redshift performance tuning
n
Experience with large-scale data processing
n
Experience with CI/CD and
Git
n
Good understanding of data quality and data governance
n
Positive to Haven
n
n
Experience with
AWS Lambda, Step Functions, EMR, Athena, and CloudWatch
n
Experience with
Apache Spark / PySpark
n
Experience with
Airflow
n
Knowledge of
Kafka / streaming data
n
Experience with CDC tools such as
AWS DMS, Debezium, or equivalent
n
Experience with
Terraform / Infrastructure as Code
n
Exposure to
Databricks, Snowflake, or other cloud data platforms
n
Experience working in
Agile/Scrum
environments
n
Technical Skillsn
n
Cloud:
AWS, S3, Glue, Lambda, Step Functions, CloudWatch
n
Programming:
Python, SQL
n
DevOps:
Git, CI/CD, Terraform
n
Data Modeling:
Star Schema, Snowflake Schema, Dimensional Modeling
#J-*****-Ljbffr

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