Data Migration Architect — Azure, SQL & ETL

Creative Information Technology India; Falls Church (VA); On-site; USD 110,000 - 140,000; Full time

Job summary

Creative Information Technology Inc (CITI) in Falls Church, VA is seeking a Data Conversion Specialist to design, develop, test, and implement data migration solutions from legacy systems to enterprise platforms. The role emphasizes data accuracy, governance, and collaborative delivery with clients.

The ideal candidate brings 6+ years in data migration/ETL, strong SQL Server and Azure Data Factory expertise, and excellent client communication skills.

Qualifications

• 6+ years of experience in data migration, ETL, data engineering, or data conversion projects.
• Strong expertise in SQL Server (T-SQL, Stored Procedures) and Azure SQL Database.
• Experience with data validation, reconciliation, and data quality management.
• Excellent client-facing communication skills.

Responsibilities

• Design, develop, test, and execute data migration and conversion solutions moving data from legacy to enterprise systems.
• Lead end-to-end data migration and conversion activities with client and project-team collaboration.
• Analyze source/target data models and develop mapping and transformation rules.
• Develop migration routines, stored procedures, functions, views, and ADF pipelines using SQL Server and Azure.
• Perform data profiling, cleansing, validation, integrity testing, and reconciliation.
• Create and maintain migration documentation, mapping specs, validation reports, and deployment runbooks.
• Build scalable ETL/ELT solutions using Azure Data Factory and optimize data ingestion workflows.
• Ensure data quality, lineage, and governance throughout lifecycle.

Skills

SQL Server

Azure SQL

Azure Data Factory

Python

Data validation

Data reconciliation

Data quality

Data cleansing

Client-facing communication

Stakeholder management

Education

Bachelor’s or Master’s degree in Computer Science or related field

Tools

Azure SQL Database

Azure Data Factory

Microsoft SQL Server

Job description

Creative Information Technology Inc (CITI) in Falls Church, VA is seeking a Data Conversion Specialist to design, develop, test, and implement data migration solutions from legacy systems to enterprise platforms. The role emphasizes data accuracy, governance, and collaborative delivery with clients.

The ideal candidate brings 6+ years in data migration/ETL, strong SQL Server and Azure Data Factory expertise, and excellent client communication skills.