Job Closed
This listing is no longer active.
ETL Data Migration Validation Engineer
Location
United States
Posted
87 days ago
Salary
0
Seniority
Mid Level
Job Description
ETL Data Migration Validation Engineer
Harmonia Holdings Group
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. Description Title: ETL Data Migration Validation Engineer (IV&V) Location: Remote Terms: Full-time Clearance: Ability to obtain a Public Trust Travel: 0% Project Description FEMA’s Grants Management Modernization (GMM) initiative is a large-scale effort to consolidate and modernize multiple legacy grant systems into a unified enterprise platform. This includes the migration of active financial and grant transaction systems with high data volumes and complex business rules. The IV&V team operates independently from development teams and is responsible for validating the accuracy, completeness, and integrity of data migrated from legacy environments into the modernized platform. This role is primarily focused on data migration validation and reconciliation. It is not a UI-focused or manual regression testing position. Position Description The ETL Data Migration Validation Engineer will be responsible for independently validating large-scale data migrations across platforms (e.g., Oracle, PostgreSQL, CSV-based sources) involving high-volume datasets (100K–250K+ records). This role requires strong, hands-on SQL expertise and the ability to work directly from mapping documentation—often without direct access to the source database. The ideal candidate must be comfortable designing reconciliation strategies, performing set-based comparisons, validating composite keys, and identifying discrepancies across systems. Approximately 70–80% of this role is dedicated to data migration validation and reconciliation. Responsibilities: - Data Migration Validation & Reconciliation - Independently validate data migrated from legacy systems to the GMM platform using complex SQL queries. - Perform set-based comparisons (e.g., EXCEPT/MINUS logic, full outer joins) to identify missing, extra, or mismatched records. - Reconcile high-volume datasets (100K+ records) across source and target environments. - Validate composite key integrity and multi-table joins based on mapping documentation. - Detect and resolve data multiplication caused by improper join logic. - Validate incremental loads versus full data loads. - Identify and analyze discrepancies related to null handling, outer joins, and transformation logic. - Validate cross-platform migrations (e.g., Oracle to PostgreSQL, CSV to database). - Perform validation when direct source database access is unavailable, leveraging staged data, flat files, and documentation. Schema & Data Integrity Validation - Validate schema alignment, data types, constraints, and field-level transformations. - Identify truncated values, formatting discrepancies, whitespace anomalies, and encoding issues. - Support checksum/hash total validation techniques where applicable. - Reverse engineer transformation logic when documentation is incomplete. Independent IV&V Execution - Operate independently from development teams to provide objective validation findings. - Document defects and reconciliation findings clearly and concisely. - Participate in Agile ceremonies to align validation efforts with migration releases. - Provide risk-based recommendations to federal stakeholders regarding data accuracy and integrity. Requirements - U.S. Citizen eligible to obtain and maintain a Public Trust clearance. - 5+ years of hands-on SQL experience, including complex joins, subqueries, aggregates, and set-based comparisons. - Demonstrated experience validating large-scale data migrations (100K+ records). - Direct experience performing source-to-target data reconciliation. - Experience working from mapping documents to validate field-level transformations. - Experience validating composite keys and multi-table relationships. - Experience identifying null-related discrepancies in outer joins. - Experience validating cross-platform migrations (e.g., Oracle, PostgreSQL, SQL Server, CSV). Desired - Experience supporting federal modernization programs. - Experience validating financial or grant-based transactional systems. - Familiarity with ETL processes and data staging environments. - Experience working in an Independent Verification & Validation (IV&V) capacity. - Exposure to hash/checksum validation techniques. - Familiarity with Agile methodologies. #DICE #LI ___________________________________________________________________________________________________________ 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 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 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 - 100% employer-paid dental and vision insurance options - 100% employer-sponsored STD, LTD, and life insurance - 5% 401(k) company matching - Flexible-schedules and teleworking options - Paid holidays and PTO Accrual Plans - Paid Parental Leave - Professional development and career growth opportunities - Team and company-wide events, recognition, and appreciation-- and so much more! Check out our LinkedIn, Facebook, and Instagram to 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 veterans. To 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 HR@harmonia.com.
Related Guides
Related Categories
Related Job Pages
More QA Engineer Jobs
Senior Construction Engineer
Lumen TechnologiesLumen Technologies is self-described as a global company of 40,000+ professionals empowering businesses, government, and communities to “produce amazing things.” Driven by the
About Lumen Lumen connects the world. We are igniting business growth by connecting people, data and applications – quickly, securely, and effortlessly. Together, we are building a culture and company from the people up – committed to teamwork, trust and transparency. People power progress. We’re looking for top-tier talent and offer the flexibility you need to thrive and deliver lasting impact. Join us as we digitally connect the world and shape the future. The Role The Senior Construction Engineer reports directly to the Manager of Engineering. They will be responsible for all aspects of completing the delivery of new telecommunications networks multiple locations through vendor management and vendor engagement; including supervising the estimating, design, engineering, scheduling and construction implementation of multiple network infrastructure deployment projects. The Main Responsibilities - Defines and reviews comprehensive plans for large, complex, highly technical projects that cover the following: phased delivery plan; resource requirements, project costs, project schedule; risk assessment and mitigation; opex and capital budget requirements; team structure and accountability matrix; project governance and reporting; forecasting of upcoming projects and corresponding materials. - Effectively leads a cross-functional team in the planning and execution of large projects. The team may include company employees from various internal departments as well as outside contractors and engineering firms. Construction Engineer must establish and drive clear accountabilities for all outside vendors and create an environment that enables high performance. - Ability to drive vendors to complete projects on time and meet aggressive timelines. Must be able to prioritize a heavy workload and stay flexible on meeting internal schedules. - Leads the solution deployment. Covering everything from the network architecture, construction methodologies, material selection, acquisition and handling, field installation activities, project acceptance activities, customer and operational hand-over activities. - Responsible for in-scope, on schedule, on budget delivery. Establishes the appropriate project team structure, reporting and metrics to measure, monitor performance against plan reporting frequent status updates to internal stakeholders. - Demonstrated ability to lead and positively motivate cross-functional teams of engineers, construction managers, contractors and consulting employees to successful completion of such projects. What We Look For in a Candidate - Bachelor’s degree or 5 plus years of relevant job experience. Relevant job background, knowledge, and experience is described as: - A knowledge base full of OSP Engineering standards and practices along with all forms of Outside Plant (OSP) construction (e.g. proper boring and trenching, fiber pulling in duct, including overpulling, general Telecommunications Aerial and Underground construction standards). - Experience with civil engineering and construction for site development. - Personal experience in the full life cycle of OSP and/or Civil Projects (e.g. estimating, engineering, permitting and constructing). - Strong computer skills with emphasis using Microsoft Word, Excel and Project as well as a variety of mapping programs. - Positive and professional attitude. - Experience in strategic customer relationship management. - Proven results in building strong peer level relationships-coordination and alignment with the managers who will ultimately operate the network is considered imperative to overall success of these projects. - Strong general business acumen. - Exceptional organizational, prioritization and written/verbal communication skills. - Proven creative problem solver. - Experience in OSP operations, administration, and maintenance. - The principles and practices behind Fiber Network Management (e.g. route planning, fiber assignments, capacity management, fiber types, splicing requirements, testing requirements, and power requirements). Compensation This information reflects the anticipated base salary range for this position based on current national data. Minimums and maximums may vary based on location. Individual pay is based on skills, experience and other relevant factors. Location Based Pay Ranges: $82,969 - $110,625 in these states: AL, AR, AZ, FL, GA, IA, ID, IN, KS, KY, LA, ME, MO, MS, MT, ND, NE, NM, OH, OK, PA, SC, SD, TN, UT, VT, WI, WV, and WY. $87,117 - $116,156 in these states: CO, HI, MI, MN, NC, NH, NV, OR, and RI. $91,266 - $121,688 in these states: AK, CA, CT, DC, DE, IL, MA, MD, NJ, NY, TX, VA, and WA. Lumen offers a comprehensive package featuring a broad range of Health, Life, Voluntary Lifestyle benefits and other perks that enhance your physical, mental, emotional and financial wellbeing. We're able to answer any additional questions you may have about our bonus structure (short-term incentives, long-term incentives and/or sales compensation) as you move through the selection process. Learn more about Lumen's: - Benefits - Bonus Structure #LI-Remote Requisition #: 341326 Background Screening If you are selected for a position, there will be a background screen, which may include checks for criminal records and/or motor vehicle reports and/or drug screening, depending on the position requirements. For more information on these checks, please refer to the Post Offer section of our FAQ page. Job-related concerns identified during the background screening may disqualify you from the new position or your current role. Background results will be evaluated on a case-by-case basis. Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. Equal Employment Opportunities We are committed to providing equal employment opportunities to all persons regardless of race, color, ancestry, citizenship, national origin, religion, veteran status, disability, genetic characteristic or information, age, gender, sexual orientation, gender identity, gender expression, marital status, family status, pregnancy, or other legally protected status (collectively, “protected statuses”). We do not tolerate unlawful discrimination in any employment decisions, including recruiting, hiring, compensation, promotion, benefits, discipline, termination, job assignments or training. Disclaimer The job responsibilities described above indicate the general nature and level of work performed by employees within this classification. It is not intended to include a comprehensive inventory of all duties and responsibilities for this job. Job duties and responsibilities are subject to change based on evolving business needs and conditions. In any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information. Please be advised that Lumen does not require any form of payment from job applicants during the recruitment process. All legitimate job openings will be posted on our official website or communicated through official company email addresses. If you encounter any job offers that request payment in exchange for employment at Lumen, they are not for employment with us, but may relate to another company with a similar name.
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description This role involves providing quality expertise supporting the development and commercialization of Kyverna’s products in compliance with relevant US, EU, and ICH requirements. - Manage and maintain processes, SOPs, and workflows for Deviations, Investigations, CAPA, Change Control, Quality Metrics, and other core QMS programs. - Lead or support the implementation, configuration, validation, and optimization of the electronic Quality Management System (eQMS). - Provide hands-on expertise in the day-to-day execution, review, and management of QMS records within the eQMS. - Partner with internal stakeholders to define data governance, system configuration, user roles, and reporting requirements for quality systems. - Ensure data integrity, traceability, and compliance of quality system data in accordance with regulatory expectations (e.g., ALCOA+ principles). - Monitor overall quality system effectiveness, identify gaps or inefficiencies, and drive continuous improvement initiatives. - Recommend updates to quality policies and procedures and implement process improvements aligned with organizational growth and regulatory readiness. - Develop, compile, analyze, and present quality metrics and KPIs for routine management review. - Perform trending and data analysis to identify risks, systemic issues, and opportunities for improvement. - Create and deliver training programs related to QMS processes, data integrity, and eQMS functionality. - Support inspection readiness and ensure adherence to cGMPs, regulatory mandates, and internal quality standards. - Build and maintain strong cross-functional relationships and foster a culture of engagement, transparency, and quality ownership. - Perform other duties as assigned. Qualifications - Bachelor’s degree in Computer Science, Life Sciences, or a related field, or equivalent relevant experience. - Minimum of 8 years of experience in the pharmaceutical or biotechnology industry, including 6+ years in Quality Systems / Quality Assurance. - Demonstrated experience implementing, administering, and improving an eQMS, including system configuration, validation support, and lifecycle management. - Strong working knowledge of quality system data management, reporting, and data integrity principles. - First-hand experience managing and reviewing deviations, investigations, CAPAs, and change controls in a regulated environment. - Experience using validated computerized systems to manage regulated quality records. - Proven ability to develop and implement enhancements to electronic Quality Systems to improve usability, compliance, and reporting. - Strong proficiency with Microsoft Office Suite and related business applications. - Ability to manage multiple priorities in a fast-paced, evolving environment with strong attention to detail. - Highly organized, self-motivated, and capable of working independently while effectively collaborating cross-functionally. - Excellent written and verbal communication skills, with the ability to influence and interact effectively at all levels of the organization. Requirements - The National salary range for this position is from $160,000 - $180,000 USD annually. - This position is also eligible for bonus, benefits, and participation in Company’s stock plan.
• Provide QA oversight for the planning, execution, and reporting of clinical trials for biologic programs. • Ensure compliance with ICH-GCP, FDA 21 CFR Parts 50/54/56/312, EMA regulations, and other international clinical trial requirements. • Support audit readiness of investigator sites, Clinical Research Organizations (CROs), and internal clinical teams. • Participate in vendor qualification and ongoing oversight of CROs, ensuring compliance with contractual and regulatory obligations. • Review and manage deviations, CAPAs, and change controls associated with Clinical activities. • Ensure quality documentation is complete, accurate, and compliant with corporate standards and global regulations. • Support continuous improvement initiatives across Clinical QA functions. • Provide quality input into regulatory submissions, including INDs, BLAs/MAAs, and safety updates. • Serve as a QA liaison between Clinical Operations, Regulatory Affairs, and external partners (CROs, Safety Vendors). • Support training and awareness of GCP and corporate quality policies across internal teams and contractors. • Facilitate effective communication between internal stakeholders and global regulatory authorities during audits and inspections.
• Provide strategic quality oversight for the intake, investigation, and management of clinical-stage combination product complaints. • Ensure compliance with global GMP, GCP, and pharmacovigilance requirements. • Collaborate closely with key stakeholders to ensure timely, compliant investigations, effective CAPAs, and inspection-ready documentation. • Safeguard patient safety, product quality, and regulatory compliance throughout clinical development. • Interact with all areas of Clinical, Regulatory Affairs, and Pharmacovigilance. • Engage with CROs and CMOs for regulatory inspections and audits.


