• Collaborate with cross-functional teams to define testing scenarios based on business requirements. • Develop and execute test plans and test cases, focusing on both manual and automated testing. • Implement the Test Pyramid in our testing strategy. • Perform manual and automation testing. • Utilize Cypress for end-to-end tests and Postman for API tests. • Experience with BDD with Gherkin • Experience working in a mature DevOps environment, with continuous integration and continuous delivery • Mentor junior team members and share knowledge.

• Ensure the quality, reliability, and performance of software solutions delivered to clients • Design, execute, and automate test cases to validate new implementations, upgrades, and production support enhancements • Collaborate closely with cross-functional teams to identify risks, validate requirements, and ensure that deliverables meet functional, clinical, and performance expectations • Conduct thorough test result reviews to ensure accuracy and consistency before client release • Participate in requirement and design review sessions for new implementations, upgrades, and KP upsells • Act as a direct and reliable partner to Payment Accuracy Advisors (PAA), Business Analysts (BA), Service Operations (SIOps), and Engagement Managers (EM) • Provide input into QA strategy improvements, process enhancements, and automation frameworks • Lead change management efforts, communicating rationale and benefits of adjustments to both internal teams and customers • Perform root cause analysis to identify underlying issues and prevent recurrence • Contribute to the refinement of QA documentation, methodologies, and automation processes

• Develop comprehensive test cases derived from user stories and impact analysis. • Prepare and create mock data to support both positive and negative test scenarios, and configure test data across integrated applications. • Participate in unit, integration, and performance testing of APIs and services. • Author and maintain test automation scripts utilizing SOAP utilities or Rest Assured. • Execute these scripts both manually and via automation tools such as Jenkins, and help establish a CI/CD pipeline to streamline and automate test execution. • Work closely with developers to identify, communicate, and resolve issues, conducting retests as necessary. • Participate in reproducing and testing fixes for production issues. • Publish clear and concise test results, provide release demos to stakeholders, and obtain approvals for releases. • Certify software quality for user story releases, ensuring all tracking entries are up to date. • Ensure adherence to technical and functional standards. • Attend Scrum meetings and contribute to ongoing improvements by researching, defining, documenting, and prototyping enhancements under limited supervision.

Harmonia Holdings Group, LLC is an award-winning, rapidly growing federal government contractor committed to providing innovative, high-performing solutions to our government clients and focused on fostering a workplace that encourages growth, initiative, creativity, and employee satisfaction.   Description Title: ETL Data Migration Validation Engineer (IV&V) Location: Remote Terms: Full-time Clearance: Ability to obtain a Public Trust Travel: 0% Project Description FEMA’s Grants Management Modernization (GMM) initiative is a large-scale effort to consolidate and modernize multiple legacy grant systems into a unified enterprise platform. This includes the migration of active financial and grant transaction systems with high data volumes and complex business rules. The IV&V team operates independently from development teams and is responsible for validating the accuracy, completeness, and integrity of data migrated from legacy environments into the modernized platform. This role is primarily focused on data migration validation and reconciliation. It is not a UI-focused or manual regression testing position. Position Description The ETL Data Migration Validation Engineer will be responsible for independently validating large-scale data migrations across platforms (e.g., Oracle, PostgreSQL, CSV-based sources) involving high-volume datasets (100K–250K+ records). This role requires strong, hands-on SQL expertise and the ability to work directly from mapping documentation—often without direct access to the source database. The ideal candidate must be comfortable designing reconciliation strategies, performing set-based comparisons, validating composite keys, and identifying discrepancies across systems. Approximately 70–80% of this role is dedicated to data migration validation and reconciliation.  Responsibilities:  - Data Migration Validation & Reconciliation - Independently validate data migrated from legacy systems to the GMM platform using complex SQL queries. - Perform set-based comparisons (e.g., EXCEPT/MINUS logic, full outer joins) to identify missing, extra, or mismatched records. - Reconcile high-volume datasets (100K+ records) across source and target environments. - Validate composite key integrity and multi-table joins based on mapping documentation. - Detect and resolve data multiplication caused by improper join logic. - Validate incremental loads versus full data loads. - Identify and analyze discrepancies related to null handling, outer joins, and transformation logic. - Validate cross-platform migrations (e.g., Oracle to PostgreSQL, CSV to database). - Perform validation when direct source database access is unavailable, leveraging staged data, flat files, and documentation. Schema & Data Integrity Validation - Validate schema alignment, data types, constraints, and field-level transformations. - Identify truncated values, formatting discrepancies, whitespace anomalies, and encoding issues. - Support checksum/hash total validation techniques where applicable. - Reverse engineer transformation logic when documentation is incomplete. Independent IV&V Execution - Operate independently from development teams to provide objective validation findings. - Document defects and reconciliation findings clearly and concisely. - Participate in Agile ceremonies to align validation efforts with migration releases. - Provide risk-based recommendations to federal stakeholders regarding data accuracy and integrity. Requirements - U.S. Citizen eligible to obtain and maintain a Public Trust clearance. - 5+ years of hands-on SQL experience, including complex joins, subqueries, aggregates, and set-based comparisons. - Demonstrated experience validating large-scale data migrations (100K+ records). - Direct experience performing source-to-target data reconciliation. - Experience working from mapping documents to validate field-level transformations. - Experience validating composite keys and multi-table relationships. - Experience identifying null-related discrepancies in outer joins. - Experience validating cross-platform migrations (e.g., Oracle, PostgreSQL, SQL Server, CSV).  Desired - Experience supporting federal modernization programs. - Experience validating financial or grant-based transactional systems. - Familiarity with ETL processes and data staging environments. - Experience working in an Independent Verification & Validation (IV&V) capacity. - Exposure to hash/checksum validation techniques. - Familiarity with Agile methodologies. #DICE #LI ___________________________________________________________________________________________________________ Here at Harmonia we are pleased to have been repeatedly recognized for our outstanding work culture, the innovative work we do, and the employees on our team who make a difference each day.  Some of these recognitions include:   - Recognized as a Top 20 "Best Place to Work in Virginia" - Recipient of Department of Labor's HireVets Gold Medallion - Great Place to Work Certification for five years running - A Virginia Chamber of Commerce Fantastic 50 company - A Northern Virginia Technology Council Tech 100 company  - Inc. 5000 list of fastest growing companies for eleven years - Two-time SBA SBIR Tibbett's Award winner - Virginia Values Veterans (V3) Certification We recognize that every bit of our success is the result of our teams of hard-working, motivated, and innovative professionals who are proud to call themselves part of the Harmonia family!   In addition to competitive compensation, a family-focused culture, and a dynamic, productive work environment, we offer all full-time employees a variety of benefits including, but not limited to - Traditional and HSA- eligible medical insurance plans  - 100% employer-paid dental and vision insurance options  - 100% employer-sponsored STD, LTD, and life insurance - 5% 401(k) company matching - Flexible-schedules and teleworking options - Paid holidays and PTO Accrual Plans - Paid Parental Leave - Professional development and career growth opportunities  - Team and company-wide events, recognition, and appreciation-- and so much more!  Check out our LinkedIn, Facebook, and Instagram to find out a little more about who we are and if we are the right next step for your career!    Harmonia is an Equal Opportunity Employer providing equal employment opportunity to all employees and applicants for employment without regard to race, color, religion, national origin, age, gender, gender identity, sexual orientation, disability, or genetics. Harmonia does and will take affirmative action to employ and advance in employment individuals with disabilities and protected veterans.  To perform the above job successfully, an individual must possess the knowledge, skills, and abilities listed; meet the education and work experience required; and must be able to perform each essential duty and responsibility satisfactorily.  Other duties in addition to those listed may be assigned as necessary to meet business needs.  Reasonable accommodation will be made to enable an applicant with a disability to successfully apply for and/or perform the essential duties of the job.  If you are in need of an accommodation, please contact HR@harmonia.com.