Apply on Employer Site

Harmonia Holdings Group, LLC · 2 weeks ago

QA Tester – Data Migration / ETL

McLean, VA

Full-time

Onsite

Entry, Mid Level

Harmonia Holdings Group, LLC is an award-winning, rapidly growing federal government contractor committed to providing innovative, high-performing solutions to our government clients. They are seeking a QA Tester to support the Grants Management Modernization program by performing Independent Verification and Validation, ETL testing, and Data Migration Testing to ensure software solutions meet compliance standards and user needs.

ComputerRoboticsSoftware

No H1B

U.S. Citizen Only

Responsibilities

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

Collaborating with the integrated compliance team to support release and configuration management activities

Assisting in maintaining quality control throughout software release cycles

Writing, optimizing, and executing complex SQL queries across platforms (Oracle, SQL Server, PostgreSQL, etc.)

Performing validation and reconciliation of data across multiple environments

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

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

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

Participating in Agile ceremonies (sprint planning, stand-ups, retrospectives) to align testing activities with development cycles

Continuously improving testing approaches using industry best practices

Qualification

ETL TestingData Migration TestingSQL QueriesTest Design & ExecutionAgile EnvironmentDefect ManagementDocumentation SkillsCollaboration SkillsCommunication Skills

Required

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