Job Details:
Design and implement batch, incremental and CDC-based data ingestion solutions across enterprise source systems.
Build and support data acquisition pipelines using Fivetran; alternatively robust experience with Oracle GoldenGate or IBM GDC is suitable.
Configure source/target connectivity, CDC, replication, scheduling, monitoring and recovery mechanisms.
Work with application, data platform and security teams to onboard current data sources and datasets.
Manage schema changes, data reconciliation, ingestion failures, reprocessing and operational monitoring.
Ensure ingestion solutions meet enterprise requirements for security, resilience, auditability and data quality.
Troubleshoot production ingestion issues and contribute to performance and reliability improvements.
Maintain technical documentation, operational procedures and deployment artefacts.
Core Skills
Strong hands-on experience in Fivetran or Oracle GoldenGate or IBM GDC.
Solid understanding of CDC, database replication, batch/incremental ingestion and data integration patterns.
Experience with databases such as Oracle, SQL Server, PostgreSQL or similar enterprise RDBMS platforms.
Good SQL and data troubleshooting skills.
Experience working with cloud-based data platforms and enterprise data environments.
Understanding of CI/CD, monitoring, access management and production support practices.
Preferred
Experience within insurance, banking or other regulated Australian enterprises.
Exposure to cloud data platforms such as Databricks, Snowflake or Azure data services.
Experience working with high-volume operational data and business-critical source systems.
📌 Data Acquisition Engineer Fivetran Southern Sydney
🏢 XPT Software
📍 Southern Sydney
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.