QA Tester – Data Migration​/ETL

Title

QA Tester – Data Migration / ETL

Harmonia Holdings Group, LLC

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 fostering a workplace that encourages growth, initiative, creativity, and employee satisfaction.

Remote

Full-time

Public Trust (US Citizenship required)

None

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 scope includes the Program’s target solution.

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.

• Conduct independent testing to ensure the Program’s target solution meets FEMA’s documented requirements and non‑functional standards.
• Validate that delivered software solutions align with user needs and compliance expectations.
• Collaborate with the integrated compliance team to support release and configuration management activities.
• Assist in maintaining quality control throughout software release cycles.
• Write, optimize, and execute complex SQL queries across platforms (Oracle, SQL Server, Postgre
  
  SQL, etc.) and perform validation and reconciliation of data across multiple environments.
• Test Extract, Transform, Load (ETL) processes, ensuring data pipelines and data movement between systems meet business and technical requirements and validate data flows, transformations, and accuracy across integration points.
• Design and execute test cases based on data mapping documents, identify and resolve mismatches, missing records, and transformation logic issues, and support the full data migration lifecycle, including profiling, cleansing, migration, and validation.
• Create detailed test scenarios and scripts aligned with mapping and transformation rules, perform reconciliation testing between different data sources and target systems, document defects, track resolutions, and ensure corrective actions are implemented.
• Participate in Agile ceremonies (sprint planning, stand‑ups, retrospectives) to align testing activities with development cycles and continuously improve testing approaches using industry best practices.

• Strong Database
  
  Skills:
  
  
  • Hands‑on experience with SQL in different database platforms (e.g., Oracle, SQL Server, Postgre
    
    SQL).
  • 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.

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

• Competitive compensation and flexible schedules.
• Traditional and HSA‑eligible medical insurance plans with wellness incentives for employees and family.
• 100%…