Data/Migration Engineer - Integral

OpenTalent; Tysons (VA); On-site; USD 120,000 - 170,000; Full time

Job summary

OpenTalent is seeking a Data/Migration Engineer to execute and support data migration, cleansing, profiling, and transformation for VA OIT PDS BAM MBS programs, ensuring secure and reliable IT solutions.

The role requires a Bachelor's in CS or IT and 10+ years' experience with ETL/ELT, DDL/DML, cloud migration (AWS/VAEC), data masking, and BI support; familiarity with Liquibase, Flyway, DMS, GoldenGate; and a Public Trust.

Qualifications

• Bachelor’s degree in computer science or IT required.
• 10+ years of experience in data migration and related analytics.
• Experience with ETL/ELT processing and data transformation.
• Experience implementing data masking/sanitization and DDL/DML updates.
• Experience supporting cloud migration (AWS, VAEC) and legacy modernization.
• Knowledge of data governance, BI support, and data quality monitoring.
• Public Trust clearance or eligibility.

Responsibilities

• Execute data migration, cleansing, profiling, and transformation tasks.
• Prepare test data and manage database refresh operations.
• Support data migration strategies, planning, and testing across environments.
• Develop and maintain data models, dictionaries, catalogs, and migration documentation.
• Mask/sanitize data during production refreshes and maintain repeatable processes.
• Provide BI integration support and FinOps data analysis.
• Maintain and review architecture artifacts and participate in peer reviews.

Skills

Data migration

ETL/ELT processing

Data cleansing

Data profiling

Test data creation

Data governance

Database performance

Compliance

Education

Bachelor’s Degree in Computer Science or IT

Tools

Liquibase

Flyway

DMS

GoldenGate

AWS Glue

Oracle

Job description

The Data/Migration Engineer is responsible for executing and supporting all data migration, cleansing, profiling, and transformation activities required to modernize systems and move data between environments (production lower environments, legacy modern VA platforms such as BIP/AWS VAEC) for the Department of Veterans Affairs (VA), Office of Information and Technology (OIT), Product Delivery Services (PDS), Benefits and Memorials (BAM), Memorial and Benefit Services (MBS) deliver secure, reliable, and effective Information Technology (IT) solutions that support the Department’s mission.

• Ensures data quality, prepares test data, manages database refresh operations, and supports BI, FinOps, and data governance initiatives.
• Execute data profiling, cleansing, and migration strategies, including creation of test data.
• Support development and implementation of data migration strategies, plans, requirements, and testing across environments.
• Maintain repeatable processes and scripts to mask/sanitize data when databases are refreshed from production.
• Detect and resolve data quality issues, performing analysis on causes, impacts, and remediation.
• Maintain Architecture Document Artifacts and participate in peer reviews.
• Support creation and maintenance of Data Models, Data Dictionaries, Data Catalogs, and migration documentation
• Manage DDL/DML updates, database refreshes, and masking/sanitization processes.
• Execute data profiling, cleansing, migration strategies, and test data creation.
• Manage DDL/DML updates, database refreshes, and masking/sanitization processes.
• Support BI integration, FinOps reporting analysis, and data quality monitoring.

Required:

• Bachelor’s Degree in computer science or IT with 10+ years' experience
• Experience in data migration, data cleansing, profile analysis, ETL/ELT processing, and transformation.
• Experience executing DDL/DML updates, performing database refreshes, and implementing data masking/sanitization processes.
• Experience supporting cloud migration efforts (AWS, VAEC) and legacy data modernization.
• Experience providing BI support, FinOps data analysis, and quality monitoring activities.
• Experience developing test data, managing database performance, and supporting migration tools
• Knowledge of database migration tools (Liquibase, Flyway, DMS, GoldenGate, etc.) and cloud data services
• Strong understanding of masking/sanitization techniques and compliance requirements for handling VA data
• Public Trust

Preferred:

• Use of Oracle; DMS, GoldenGate, AWS Glue, Pentaho; legacy modernization