Harmonia is hiring: QA Tester Data Migration / ETL in Falls Church
Harmonia, Falls Church, VA, US
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: Full-time 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.
- 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.
- 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.
- 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
- 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!