QA Tester - Data Migration / ETL jobs in United States
cer-icon
Apply on Employer Site
company-logo

Harmonia Holdings Group, LLC · 2 weeks ago

QA Tester - Data Migration / ETL

Harmonia Holdings Group, LLC is an award-winning, rapidly growing federal government contractor committed to providing innovative solutions to government clients. They are seeking a QA Tester to support the Grants Management Modernization program by performing Independent Verification and Validation (IV&V), ETL testing, and Data Migration Testing to ensure software solutions meet rigorous requirements and user expectations.

ComputerRoboticsSoftware
badNo H1BnoteU.S. Citizen Onlynote

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

SQLETL TestingData Migration TestingTest Design & ExecutionAgile QA PracticesDatabase SkillsDefect ManagementData ProfilingData CleansingData Validation AutomationDocumentation Skills

Required

Public Trust clearance (US Citizenship 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

Preferred

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

Company

Harmonia Holdings Group, LLC

twittertwitter
company-logo
Harmonia Holdings Group is a computer software company that provides application development services.

Funding

Current Stage
Growth Stage
Total Funding
unknown
Key Investors
Madison Dearborn Partners
2024-09-07Private Equity

Leadership Team

leader-logo
Damon Griggs
CEO and Chairman
linkedin
leader-logo
Kirstin Shelton
Chief Human Resources Officer
linkedin
Company data provided by crunchbase