Data Engineer - Fivetran

Cognizant

Sydney

On-site

AUD 120,000 - 180,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Education support
Dedicated training programs
Wellness packages

Job summary

Cognizant Technology Solutions Corporation is seeking a Data Engineer with strong Fivetran experience in Sydney to design, operate, and optimize source-to-destination data ingestion pipelines. You will configure connectors, manage syncs, validate data, monitor performance, and collaborate with analytics teams to deliver trusted data.

The role focuses on connector configuration, initial and incremental syncs, data validation, and issue resolution, with emphasis on production readiness and

Qualifications

  • Hands-on experience implementing and supporting Fivetran connectors in production.
  • Strong understanding of ELT architecture, source-to-destination ingestion, initial loads, incremental replication, and re-sync procedures.
  • Experience configuring source authentication, permissions, schema and table selection, destinations, and sync schedules.
  • Troubleshoot connector failures, API limits, sync delays, and data integrity issues using sync history and diagnostics.
  • Strong SQL skills for data validation, reconciliation, and troubleshooting with relational data structures.
  • Practical experience with at least one cloud data warehouse or lakehouse destination and its ingestion requirements.
  • Understanding of Fivetran MAR usage and how to investigate usage changes.
  • Experience documenting integrations, managing production incidents, and implementing data access and security controls.
  • Strong analytical, communication, and stakeholder-management skills.

Responsibilities

  • Configure, deploy, and maintain Fivetran connectors for sources and destinations.
  • Set up source access, select schemas and tables, and define sync schedules.
  • Manage initial loads, incremental syncs, and re-syncs with connector behavior in mind.
  • Monitor sync status, duration, and data volumes; troubleshoot failures and connectivity issues.
  • Assess schema changes and coordinate downstream changes to preserve data integrity.
  • Use SQL to validate data completeness and freshness; investigate discrepancies.
  • Monitor MAR usage and optimize ingestion with business stakeholders.
  • Collaborate with analytics engineers on downstream transformations and schedules.
  • Maintain connector inventories, runbooks, and incident records with source owners.
  • Apply access control, security, and governance throughout onboarding and operations.

Skills

Fivetran
ELT
SQL
Data Warehousing
Cloud
Monitoring
Data Governance

Tools

Fivetran
Redshift
Databricks
Airflow

Job description

Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.), Cognizant combines a passion for client satisfaction, technology innovation, deep industry and business process expertise, and a global, collaborative workforce that embodies the future of work. Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 2000, and the Fortune 500 and is ranked among the top performing and fastest growing companies in the world.

Our Culture:

Your passion, integrity and experience are integral to Cognizant's success. You will join a dynamic and expanding global leader in IT and Business consultancy where you will be valued for who you are. We take pride in our partnership with our clients, so your ability to add value and provide exceptional service to our clients is fundamental to your success. In return, you will be presented with opportunities to develop your career and collaborate with talented colleagues in a supportive, diverse environment.

At Cognizant we recognize that companies that are open and welcoming to a multi-culturally diverse workforce will thrive with fresh perspectives and collaborative knowledge. Cognizant focuses on promoting & increasing gender diversity and providing a workplace which encourages great participation and an equal playing field, where merit and accomplishment are the only criteria for success.

Job Summary:

We are seeking a Data Engineer with strong hands-on Fivetran experience to implement, operate, and optimize reliable source-to-destination data ingestion pipelines. The role focuses on connector configuration, initial and incremental syncs, data validation, monitoring, troubleshooting, and usage optimization. The ideal candidate combines production Fivetran expertise with strong SQL skills and collaborates with source-system owners and analytics teams to deliver trusted, timely data. Experience with Amazon Redshift or Databricks is valuable but secondary to Fivetran expertise.

Key Responsibilities:
  • Configure, deploy, and maintain Fivetran connectors for business applications, databases, and file-based sources according to integration requirements.
  • Set up source access and destination connections, select required schemas and tables, and define sync schedules aligned with data freshness requirements.
  • Manage initial loads, incremental syncs, and controlled re-syncs; understand connector-specific replication behavior and limitations.
  • Monitor sync status, duration, and data volumes; investigate failures, authentication issues, source permissions, connectivity problems, and API limits.
  • Assess schema changes and coordinate source and downstream changes to protect data integrity and reporting continuity.
  • Use SQL to reconcile source and destination data, validate completeness and freshness, and investigate discrepancies.
  • Monitor Monthly Active Rows (MAR), investigate unexpected usage changes, and optimize ingestion scope in partnership with business stakeholders.
  • Partner with analytics engineers on downstream SQL transformations and coordinate transformation schedules with ingestion dependencies.
  • Maintain connector inventories, configuration documentation, operational runbooks, and incident records; coordinate recovery and escalations with source owners and Fivetran support.
  • Apply access control, security, and governance requirements throughout connector onboarding and ongoing operations.
Required Qualifications:
  • Demonstrated hands-on experience implementing and supporting Fivetran connectors in production.
  • Strong understanding of ELT architecture, source-to-destination ingestion, initial loads, incremental replication, and re-sync procedures.
  • Experience configuring source authentication, permissions, schema and table selection, destinations, and sync schedules.
  • Ability to troubleshoot connector failures, API limits, sync delays, and data integrity issues using sync history and operational diagnostics.
  • Strong SQL skills for data validation, reconciliation, and troubleshooting, with a working knowledge of relational data structures.
  • Practical experience with at least one cloud data warehouse or lakehouse destination and its ingestion requirements.
  • Understanding of Fivetran MAR usage and the ability to investigate usage changes and identify unnecessary ingestion.
  • Experience documenting integrations, managing production incidents, and implementing data access and security controls.
  • Strong analytical, communication, and stakeholder-management skills, including collaboration with source-system administrators and analytics teams.
Preferred Qualifications:
  • Experience with Amazon Redshift or Databricks as a Fivetran destination.
  • Python scripting and familiarity with REST APIs for integration automation and operational support.
  • Experience with database change data capture (CDC) and connector-specific replication prerequisites.
  • Experience with Git, CI/CD, orchestration tools, and cloud services such as AWS S3, IAM, and CloudWatch.
  • Knowledge of data cataloging, lineage, privacy, and governance practices.
Benefits:

Joining Cognizant will give you the opportunity to learn and collaborate with some of the most talented people in the industry, while having your finger on the pulse of emerging industry trends and working on the cutting edge of technology in your field of expertise.

We recognize that our people perform at their best when they feel valued as significant contributors and that is why at Cognizant, taking care of our employees is a priority:

  • You can pursue innovative career tracks and opportunities here
  • You can enhance your professional development through education and dedicated training
  • We’ll give you the skills you need to keep pace with the changing workplace while our compensation, benefits and wellness packages help you stay healthy and plan for the future.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data Engineer
Lead Data Engineer

Cognizant Technology Solutions Corporation • Sydney

On-site
AUD 120,000 - 160,000
Fivetran Data Engineer: ELT Pipelines & Data Quality
Fivetran Data Engineer: ELT Pipelines & Data Quality

Cognizant • Sydney

On-site
AUD 120,000 - 180,000
Education support
Dedicated training programs
Wellness packages
Test Manager - Data Platform
Test Manager - Data Platform

Cognizant Technology Solutions Corporation • Sydney

On-site
AUD 140,000 - 190,000
Career tracks
Education & training
Competitive compensation
Test Manager - Data Platform
Test Manager - Data Platform

Cognizant • Sydney

On-site
AUD 120,000 - 170,000
Solution Architect - Data
Solution Architect - Data

Cognizant • Sydney

On-site
AUD 180,000 - 240,000
Career development
Education & training
Wellness packages
Solution Architect - Data
Solution Architect - Data

Cognizant Technology Solutions Corporation • Sydney

On-site
AUD 150,000 - 190,000
Career development
Training opportunities
Wellness benefits
Revenue Operations Manager
Revenue Operations Manager

Fivetran, Inc. • Sydney

Hybrid
AUD 170,000 - 210,000
100% employer-paid medical insurance
Generous paid time away (PTO)
RSU stock grants
+4
Revenue Operations Manager
Revenue Operations Manager

Fivetran • Sydney

Hybrid
AUD 180,000 - 280,000
100% employer-paid medical insurance
Generous paid time off
Professional development
+1
Test Manager
Test Manager

Xpt Software Australia Pty • Sydney

On-site
AUD 120,000 - 180,000
Learn from industry experts
Innovative technology environment
Wellness and compensation benefits
Manager, Customer Support Engineering
Manager, Customer Support Engineering

Fivetran, Inc. • Alice Springs

On-site
AUD 150,000 - 230,000
Top locations