Data Migration Validation Analyst — Hybrid (SQL & PostgreSQL)

Ellumen; Country Side (MD); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Healthcare benefits

Hybrid work near Frederick, MD

Job summary

Ellumen is seeking an experienced Data Migration Validation Analyst / Database Test Analyst to support a federal healthcare IT program in a hybrid role near Frederick, MD. The role focuses on executing database queries, validating migrated data, documenting results, and tracking discrepancies to resolution.

You will develop and run SQL/PLSQL queries, perform DML/SQL level testing, compare source and target datasets, and collaborate with developers, database engineers, testers, and other team

Qualifications

• Experience with DML/SQL and database testing.
• Experience writing and executing PL/SQL queries, particularly for data validation or migration testing.
• Hands-on experience performing data migration validation, data reconciliation, or source-to-target testing.
• Experience using JIRA and Confluence in a technical or Agile environment.

Responsibilities

• Perform data migration testing and validation to ensure completeness, accuracy, consistency, and integrity of migrated data.
• Develop and execute SQL and PL/SQL queries to validate source-to-target data before, during, and following migration activities.
• Perform database-level testing using DML/SQL to identify data discrepancies, transformation issues, missing records, and other migration defects.
• Compare source and target datasets and document validation results.
• Work closely with developers, database engineers, testers, and other technical team members to troubleshoot and resolve data-related issues.
• Create, maintain, and update JIRA tickets associated with testing, defects, validation activities, and remediation.
• Maintain validation documentation, status updates, and supporting materials within Confluence.
• Track multiple validation activities simultaneously and ensure tickets, testing status, and outstanding issues remain current.
• Assist the data team with validation activities involving MongoDB and/or PostgreSQL, as applicable.
• Participate in technical meetings, migration planning sessions, testing activities, and status reporting.
• Provide clear documentation and communication regarding defects, risks, testing results, and outstanding migration issues.

Skills

DML/SQL

Database testing

Data validation

PL/SQL

Tools

JIRA

Confluence

MongoDB

PostgreSQL

Job description

Ellumen is seeking an experienced Data Migration Validation Analyst / Database Test Analyst to support a federal healthcare IT program in a hybrid role near Frederick, MD. The role focuses on executing database queries, validating migrated data, documenting results, and tracking discrepancies to resolution.

You will develop and run SQL/PLSQL queries, perform DML/SQL level testing, compare source and target datasets, and collaborate with developers, database engineers, testers, and other team