Dotnet Developer

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

Must-have stack: .NET/C# | REST APIs | SQL Server | SQL | SFTP | File Processing

• Experience with Microsoft SQL Server development and backend engineering experience.
• Experience developing data migration scripts, utilities and migration services.
• Strong SQL skills for extraction, transformation, validation and data reconciliation.
• Experience with file-based data migration, including structured file formats.
• Hands-on experience with SFTP-based file transfer and ingestion.
• Experience integrating source systems with target platforms through APIs, batch processing and ETL.
• Ability to build migration engines/services for high-volume backend data movement.
• Strong focus on migration validation, data integrity, reconciliation and error handling.

Key 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 it 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, data-quality issues and interface errors.
• Support migration testing, rehearsal and production cutover activities.