​.NET Data Migration Engineer | ETL & API Integrations

Ad Astra Consultants; Sydney; On-site; AUD 110,000 - 160,000; Full time

Job summary

Ad Astra Consultants is seeking an experienced data migration engineer to develop backend components for a large-scale migration programme. You will build SQL Server/.NET utilities, create migration scripts and APIs, and handle SFTP file ingestion and ETL interfaces to ensure data integrity throughout migration cycles.

The role focuses on data validation, reconciliation and resolving interface errors, with involvement in testing, rehearsal and production cutover activities.

Qualifications

• Must-have backend and SQL Server experience.
• Data migration scripts, utilities and services.
• Strong SQL for extraction, transformation and reconciliation.
• File-based data migration with structured formats.
• SFTP-based transfer and ingestion expertise.
• APIs, batch processing and ETL for source-to-target integration.
• Migration engines/services for high-volume data movement.
• Data validation, reconciliation and error handling focus.

Responsibilities

• Develop backend components for a large-scale system migration programme.
• Build SQL Server and .NET-based migration utilities/services.
• Develop migration scripts and APIs to extract, transform and load data.
• Process data received through SFTP/files and load into target systems.
• Build and support ETL/batch interfaces between source and target platforms.
• Implement data validation and reconciliation across migration stages.
• Troubleshoot migration failures and data-quality issues.
• Support migration testing, rehearsal and production cutover activities.

Skills

.NET/C#

REST APIs

SQL Server

SQL

SFTP

File Processing

Job description

Ad Astra Consultants is seeking an experienced data migration engineer to develop backend components for a large-scale migration programme. You will build SQL Server/.NET utilities, create migration scripts and APIs, and handle SFTP file ingestion and ETL interfaces to ensure data integrity throughout migration cycles.

The role focuses on data validation, reconciliation and resolving interface errors, with involvement in testing, rehearsal and production cutover activities.