Fenergo Developer: Fenx Integrations & Data Migration

Tata Consultancy Services; Sydney; On-site; AUD 120,000 - 180,000; Full time

Benefits offered by this job

Enterprise transformation program

Collaborative environment with diverse

Challenging migration work

Azure cloud technologies

Job summary

Tata Consultancy Services is seeking an experienced Senior Data Migration Specialist / Engineer to support a major state government transformation program in Sydney. You will analyse source/target data, design migration approaches and work across business and technical teams to deliver reliable migration outcomes.

You will implement transformation rules, develop validation processes and lead test migrations while coordinating with architects, vendors and testers to ensure data integrity through

Qualifications

• Advanced SQL expertise with staging tables in SQL Server.
• Experience on Azure/AWS data platforms and cloud migrations.
• Proven track record delivering complex data migration projects.
• Experience migrating data between AWS and Azure environments.

Responsibilities

• Analyse source and target data using SQL and mapping documentation.
• Define transformation rules and validate migration approaches.
• Execute migrations and perform post‑migration validation.
• Collaborate with architects, developers, vendors and testers to deliver outcomes.
• Develop SQL‑based validation and reconciliation processes.
• Support cutover planning and production migration activities.

Skills

SQL

Azure/AWS

Data migration

Data governance

Stakeholder engagement

ETL mapping

Tools

Azure Data Factory

Azure Databricks

Azure Blob Storage

AWS S3

SQL Server

APIs

Job description

Senior Data Migration Specialist / Engineer

Contract Opportunity | Sydney, NSW

Join a state government transformation program and play a critical role in delivering complex data migration outcomes. We are seeking an experienced Senior Data Migration Specialist / Engineer who combines strong analytical capability with hands‑on technical expertise to support large‑scale migration initiatives.

About the Company

Our client is a well‑established State Government organisation undertaking a significant technology and business transformation program. The project involves modernising critical platforms and migrating large volumes of business data across enterprise environments.

About the Role

As the Senior Data Migration Specialist / Engineer, you will be responsible for analysing source and target data, designing and validating migration approaches, executing migration activities, and ensuring the quality and integrity of migrated data. You will work across business and technical teams, collaborating with stakeholders, architects, developers, vendors, and testers to deliver successful migration outcomes.

Key Responsibilities

• Analyse source and target datasets using SQL.
• Investigate anomalies, data quality issues, and complex data relationships.
• Trace and diagnose data issues across multiple systems.
• Develop and review source‑to‑target mapping documentation.
• Define transformation rules and manage exceptions.
• Translate business requirements into practical migration solutions.
• Support migration load development and execution.
• Perform test migrations and assess outcomes.
• Troubleshoot migration failures and implement corrective actions.
• Develop SQL‑based validation and reconciliation processes.
• Investigate discrepancies between source and target data.
• Produce evidence confirming successful migration outcomes.
• Support migration testing cycles and dress rehearsals.
• Participate in cutover planning and execution.
• Conduct post‑migration validation and reconciliation activities.

Essential Skills & Experience

• Advanced SQL expertise, including creating and managing staging tables within SQL Server.
• Strong experience with Azure, Azure Blob Storage, AWS S3, SQL databases, or similar data platforms.
• Demonstrated experience delivering complex data migration and transformation projects.
• Experience with AWS‑to‑Azure migration programs or comparable cloud migration initiatives.
• Strong understanding of relational databases and complex data structures.
• Experience with APIs, integrations, and data transformation solutions.
• Excellent data quality, validation, reconciliation, and troubleshooting skills.
• Strong understanding of data governance, security, and access management.
• Ability to operate across both technical implementation and business analysis functions.
• Outstanding communication and stakeholder engagement skills.

Highly Desirable

• Experience migrating documents from AWS S3 to Azure environments.
• Experience using AzCopy, Azure Databricks, and Azure Data Factory.
• Experience working with vendors and third‑party integration partners.
• Exposure to complex enterprise transformation programs.
• Migration cutover planning and production migration experience.
• Experience developing repeatable and automated migration processes.

What’s on Offer

• Opportunity to work on a significant enterprise transformation program.
• Collaborative environment with architects, engineers, business stakeholders, and vendors.
• Challenging and technically complex migration work.
• Exposure to modern Azure and cloud‑based technologies.