QA Tester - Data Migration / ETL

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.  

• Title: QA Tester – Data Migration / ETL

Location: Remote

Terms: Fulltime

• Clearance: Public Trust (US Citizenship required)

Travel: none

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.  

Project Description:
The scope of this effort is for The Grants Management Modernization (GMM) independent verification and validation (IV&V) and third-party testing activity support. Harmonia is providing Agile testing services and IV&V services to provide release/configuration management support. The goal of this work is to validate that the software delivered by the Program’s development team meets FEMA’s non-functional requirements. The overall scope of these services includes the Program’s target solution. Harmonia uses government and industry best practices to:

• Provide an integrated compliance team for release/configuration management services.
• Independently verify that the Program’s target solution meets documented requirements.
• Validate that the Program’s target solution meets user needs.

Position Description:

Harmonia is seeking a QA Tester to support the Grants Management Modernization (GMM) program by performing Independent Verification and Validation (IV&V), ETL testing, SQL queries, Data Migration Testing, and Test Design and Execution services. This role is critical to ensuring that the software solutions delivered to FEMA meet rigorous non-functional requirements, user expectations, and compliance standards.

The ideal candidate will have experience in Agile environments, a deep understanding of software quality assurance, and a passion for ensuring that mission-critical systems are reliable, compliant, and user-centric.

Responsibilities:

Independent Verification & Validation (Iv&V):

• Conducting independent testing to ensure the Program’s target solution meets FEMA’s documented requirements and non-functional standards.
• Validating that delivered software solutions align with user needs and compliance expectations.

Release & Configuration Management Support:

• Collaborating with the integrated compliance team to support release and configuration management activities.
• Assisting in maintaining quality control throughout software release cycles.

Database & Sql Testing:

• Writing, optimizing, and executing complex SQL queries across platforms (Oracle, SQL Server, PostgreSQL, etc.).
• Performing validation and reconciliation of data across multiple environments.

Etl Testing:

• Testing Extract, Transform, Load (ETL) processes, ensuring data pipelines and data movement between systems meet business and technical requirements.
• Validating data flows, transformations, and accuracy across integration points.

Data Migration Testing:

• Designing and executing test cases based on data mapping documents.
• Identifying and resolving mismatches, missing records, and transformation logic issues.
• Supporting the full data migration lifecycle, including profiling, cleansing, migration, and validation.

Test Design & Execution:

• Creating detailed test scenarios and scripts aligned with mapping and transformation rules.
• Performing reconciliation testing between different data sources and target systems.
• Documenting defects, tracking resolutions, and ensuring corrective actions are implemented.

Agile Qa Practices:

• Participating in Agile ceremonies (sprint planning, stand-ups, retrospectives) to align testing activities with development cycles.
• Continuously improving testing approaches using industry best practices.

Requirements:

• Strong Database Skills:
• Hands-on experience with SQL in different database platforms (e.g., Oracle, SQL Server, PostgreSQL etc).
• Ability to write and optimize complex SQL queries for validation and reconciliation.
• ETL Testing Experience:
• Good understanding of ETL processes, data pipelines, and data movement between systems.
• Experience validating data flows and transformations against business and technical requirements.
• Data Migration Testing Expertise:
• Strong ability to work from mapping documents to design and execute test cases.
• Proficiency in identifying data mismatches, missing records, and transformation logic issues.
• Familiarity with full data migration lifecycle (data profiling, cleansing, migration, and validation).
• Test Design & Execution:
• Ability to create test scenarios and scripts based on mapping and transformation rules.
• Experience executing reconciliation testing between different data sources and target systems.
• Strong defect management and documentation skills.
• Hands-on experience with SQL in different database platforms (e.g., Oracle, SQL Server, PostgreSQL etc).
• Ability to write and optimize complex SQL queries for validation and reconciliation.
• Good understanding of ETL processes, data pipelines, and data movement between systems.
• Experience validating data flows and transformations against business and technical requirements.
• Strong ability to work from mapping documents to design and execute test cases.
• Proficiency in identifying data mismatches, missing records, and transformation logic issues.
• Familiarity with full data migration lifecycle (data profiling, cleansing, migration, and validation).
• Ability to create test scenarios and scripts based on mapping and transformation rules.
• Experience executing reconciliation testing between different data sources and target systems.
• Strong defect management and documentation skills.

Desired:

• Knowledge of automation for data validation (using Python, Shell scripts, or any ETL automation tools) is a plus.

___________________________________________________________________________________________________________

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 w/ Wellness Incentives for employees and family
• 100% employer-paid dental and vision insurance options 
• 100% employer-sponsored STD, LTD, and life insurance
• Veterans Cohort
• Gym membership reimbursement
• 401(k) matching
• Dollar-for-dollar 501(c)(3) donation matching
• Flexible-schedules and teleworking options
• Paid holidays and Flexible Paid Time Off
• Adoption Expense Reimbursement
• Paid Parental Leave
• Professional development and career growth opportunities and paid training days
• Employer-sponsored Employee Assistance Program for employee and family
• 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.