Data Migration Validation Analyst / Database Test Analyst (Hybrid position)

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

Job summary

Ellumen seeks an experienced Data Migration Validation Analyst to support a federal healthcare IT program. The role focuses on executing database queries, validating migrated data, and documenting results to resolve discrepancies.

You will work with MongoDB and PostgreSQL, develop SQL/PLSQL tests, and manage validation tickets in JIRA/Confluence in a hybrid office near Frederick, MD.

Qualifications

• Demonstrated experience with DML/SQL and database testing.
• Experience writing and executing PL/SQL queries 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/Agile environment.
• Strong understanding of relational databases, data structures, and data integrity concepts.
• Ability to identify, document, track, and communicate data discrepancies and defects.
• Strong attention to detail and organizational skills.
• Ability to manage multiple tickets and validation activities while maintaining status documentation.
• Strong written and verbal communication skills.
• Hybrid environment near Frederick, MD with team collaboration.

Responsibilities

• Perform data migration testing and validation to ensure data completeness, accuracy, consistency, and integrity.
• Develop and execute SQL and PL/SQL queries to validate source-to-target data during migration.
• Perform database-level testing using DML/SQL to identify data discrepancies and transformation issues.
• Compare source and target datasets and document validation results.
• Collaborate with developers, DBAs, testers to troubleshoot data-related issues.
• Create, maintain, and update JIRA tickets for testing, defects, and remediation.
• Maintain validation docs, status updates, and supporting materials in Confluence.
• Track multiple validation activities and ensure tickets/status are current.
• Assist data team with validation involving MongoDB and/or PostgreSQL.
• Participate in migration planning, testing activities, and status reporting.

Skills

DML/SQL

PL/SQL

Data validation

Database testing

MongoDB

PostgreSQL

Tools

JIRA

Confluence

Job description

Position Overview

We are seeking an experienced Data Migration Validation Analyst / Database Test Analyst to support a federal healthcare IT program. This individual will play a key role in supporting data migration activities by executing database queries, validating migrated data, documenting results, and ensuring discrepancies are identified and tracked through resolution.

The ideal candidate will have hands‑on experience with DML/SQL, PL/SQL, database testing, and data validation, along with strong organizational skills and experience working within JIRA and Confluence. Experience with MongoDB and/or PostgreSQL is highly desirable.

Key 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.

Required Qualifications

• Demonstrated 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.
• Strong understanding of relational databases, data structures, and data integrity concepts.
• Ability to identify, document, track, and communicate data discrepancies and defects.
• Strong attention to detail and organizational skills.
• Ability to manage multiple tickets, validation activities, and priorities while maintaining accurate status documentation.
• Strong written and verbal communication skills.
• Ability to work effectively in a hybrid environment supporting the team near Frederick, MD.

Preferred Qualifications

• Experience with PostgreSQL.
• Experience with MongoDB or other NoSQL databases.
• Previous experience supporting federal government, DoD, or federal healthcare IT programs.
• Experience with large-scale system modernization or legacy‑to‑modern platform data migrations.
• Familiarity with Agile/Scrum development and testing environments.
• Experience developing validation scripts, reconciliation queries, or repeatable database testing processes.