Motion Recruitment · 1 week ago
Data/ETL Quality Assurance Engineer - 100% remote
United States
Contract
Remote
Mid Level
$65/hr - $70/hrMotion Recruitment is seeking two Data Quality Assurance/ETL Engineers for a cloud migration project. The role involves testing ETL processes within a Master Data Management system and ensuring high product quality through manual and automated testing.
Information TechnologyRecruitingStaffing Agency
Hiring Manager
Dean Truemper
Responsibilities
Constantly develop a deeper understanding of available data
Work to understand multiple operational departments and how data is captured and used within the organization
Become an expert in business rules, system functionality and architecture
Understand the current state to develop and/or enhance the data quality framework to support the Data Architecture and Data Analytics teams
Aptitude to evolve the current data quality processes into an enterprise data quality practice
Write complex SQL queries for source and target systems to verify the data for the ETL processes
Review business requirements, functional specifications, use cases, design, and architecture documents to create effective test plans for both ETL and data migration activities providing robust coverage
Independently develop, modify, and execute test plans based on requirements and design documents including, but not limited to, the following methods:
Load balance testing
Duplicate run testing
Negative testing with invalid test data
Performance/volume testing
Build and execute regression test scenarios
Provide estimates and timeframe necessary for testing a project to ensure a high-quality implementation
Participate in data migration testing activities, including data validation, integrity checks, and reconciliation across source and target systems
Contribute to and maintain project documentation
Identify, report and track defects and User Experience issues through a system of record
Collaborate with external teams on root cause analysis
Maintain close interaction with business and technical peers during the project life cycle
Actively participate in requirements and code reviews
Actively participate and drive improvements in Agile Scrum delivery
Be a thought leader in the test design and execution arena (manual and automated)
Identify process bottlenecks and suggest improvement actions
Creation and input of test data, either manually or by using tools, programs or masked production data to execute test cases
Qualification
Required
Strong hands-on experience using complex SQL queries for results validation, data mining and evaluating foreign key dependencies
Must have experience with dimensional databases. They have SQL Server, Oracle and PostgreSQL
Hands-on experience validating End User reports
Hands-on experience in ETL process testing is a must
Strong ability to troubleshoot issues, identify root causes, and support external teams in development of resolutions
Hands-on experience in Regression Test Strategies, Regression suite maintenance and execution
Ability to thrive in a project-based environment with evolving requirements
Strong analytical skills with the ability to collect, aggregate, analyze, and wrangle significant amounts of information with attention to detail and accuracy
Deep understanding of Development and Test cycles, including respective best practices
Strong hands-on experience in Agile and Waterfall methodologies
Preferred
Hands-on experience with one or more scripting languages (C#, Python, JS, PowerShell, etc.) is a strong plus
Hands-on experience with Kodda or SSIS packages is a strong plus
Company
Motion Recruitment
Motion Recruitment, a Kelly® Company, delivers IT Talent Solutions for Contract, Direct Hire, Managed Solutions and Statement of Work to all of North America from our 21 delivery centers.
Founded in 1989
501-1000 employees
H1B Sponsorship
Motion Recruitment has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (11)
2024 (12)
2023 (1)
2021 (1)
2020 (1)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Littlejohn & Co
2024-05-03Acquired
2018-04-30Private Equity
1998-06-04Private Equity
Leadership Team
Beth Gilfeather
CEO
Brad Page, MBA
Chief Financial Officer
Recent News
Kelly Services, Inc.
2025-10-28
TradingView
2025-02-14
Business Journals
2024-05-05
Company data provided by crunchbase