QA Tester Data Migration ETL
Share
Job Location:
Washington, AR - USA
Monthly Salary:
Not Disclosed
Posted on:
21 days ago
Vacancies:
1 Vacancy
Job Summary
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 Programs development team meets FEMAs non-functional requirements. The overall scope of these services includes the Programs target solution. Harmonia uses government and industry best practices to:
- Provide an integrated compliance team for release/configuration management services.
- Independently verify that the Programs target solution meets documented requirements.
- Validate that the Programs 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 Programs target solution meets FEMAs 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.
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 Labors 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 Tibbetts 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 ourLinkedInFacebook andInstagramto 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 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.
Key Skills
- SQL
- Pentaho
- PL/SQL
- Microsoft SQL Server
- SSIS
- Informatica
- Shell Scripting
- T Sql
- Teradata
- Data Modeling
- Data Warehouse
- Oracle
About Company
Join Our Team Are you an innovative thinker ready to make an impact on how government agencies meet their missions? Do you want to work for a company that values your ideas and grows your technical expertise? Join our team and watch your career advance!
