Data Engineer - ETL/ELT, BigQuery & Informatica Pro

Paxus; City of Melbourne; On-site; AUD 124,000 - 193,000; Full time

Job summary

Paxus in Melbourne is seeking an experienced Data Engineer to design and operate scalable ETL/ELT pipelines. You will work with Informatica, BigQuery, SQL and Python to build robust data workflows across on-prem and cloud.

The role focuses on performance optimization, cost control and reliable data delivery. Applicants should have 4-7 years in data engineering, strong knowledge of Informatica and Google BigQuery, and the ability to document processes and collaborate with analytics teams.

Qualifications

• 4-7 years hands-on data engineering experience with production pipelines.
• Strong Informatica development, scheduling and monitoring skills.
• Proven BigQuery design, datasets, partitioning and performance tuning.
• Advanced SQL skills including complex joins and window functions.
• Python for data processing, automation and utilities.
• Experience with cloud data integration and hybrid on-prem/cloud setups.
• Ability to document mappings, runbooks and diagrams.

Responsibilities

• Build and maintain scalable ETL/ELT workflows using Informatica (mappings, workflows, scheduling and monitoring).
• Manage BigQuery datasets and tables, including partitioning and clustering for large-scale analytics.
• Write and optimise advanced SQL to improve performance and reduce compute cost.
• Develop Python scripts for file parsing, orchestration and integration with cloud APIs.
• Automate operational routines using Unix shell scripting (file transfers, pre/post-load steps, batch sequencing).
• Schedule, monitor and troubleshoot integrated batch workflows across on-prem and cloud schedulers.
• Implement robust data validation, error handling and logging to improve data quality and reliability.
• Diagnose and resolve bottlenecks across Informatica, BigQuery SQL and scripting components.
• Maintain technical documentation (mapping specs, runbooks, diagrams) and collaborate with analysts/testing/business stakeholders.

Skills

Informatica

BigQuery

SQL

Python

ETL pipelines

Data workflows

Education

Bachelor's degree in Computer Science / IT / Data Eng

Tools

Informatica

Google BigQuery

Unix shell

Python scripting

Job description

Paxus in Melbourne is seeking an experienced Data Engineer to design and operate scalable ETL/ELT pipelines. You will work with Informatica, BigQuery, SQL and Python to build robust data workflows across on-prem and cloud.

The role focuses on performance optimization, cost control and reliable data delivery. Applicants should have 4-7 years in data engineering, strong knowledge of Informatica and Google BigQuery, and the ability to document processes and collaborate with analytics teams.