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.
|
Ellumen
$95,000.00 - $105,000.00 / yr
Sep 08, 2026