Data Quality Assurance Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

TEKsystems · 17 hours ago

Data Quality Assurance Engineer

TEKsystems is a leading provider of business and technology services, and they are seeking a Data Quality Assurance Engineer. The successful candidate will be responsible for ETL process data testing within the Master Data Management system and Data Warehouse, ensuring high overall product quality through both manual and automated testing activities.

Information Technology
check
H1B Sponsor Likelynote

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: o Load balance testing o Duplicate run testing o Negative testing with invalid test data o Performance/volume testing o 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

ETL process testingSQLData quality frameworkAutomation testingData validationRegression testingQuality assurancePythonManual testingAPITest automationAutomated testingDimensional databasesAmazon RedshiftTableauPowerBIC#JavaScriptPowerShellKoddaSSIS

Required

Must have experience with dimensional databases
Experience with Amazon Redshift, MPP Databases, or other cloud warehouses
Hands-on experience with Hex, Tableau, PowerBI or other analytics applications is a strong plus
Hands-on experience validating End User reports
Hands-on experience in ETL process testing is a must
Strong hands-on experience using complex sql queries for results validation, data mining and evaluating foreign key dependencies
Strong ability to troubleshoot issues, identify root causes, and support external teams in development of resolutions
Hands-on experience with one or more scripting languages (C#, Python, JS, PowerShell, etc.) is a strong plus
Hands-on experience in Regression Test Strategies, Regression suite maintenance and execution
Hands-on experience with Kodda or SSIS packages is a strong plus
Quality assurance
Automation
Quality assurance testing
Sql
Python
Manual testing
Test automation
Api
Automation testing
Automated testing

Benefits

Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)

Company

TEKsystems

company-logo
At TEKsystems, they understand people. Every year they deploy over 80,000 IT professionals at 6,000 client sites across North America,

H1B Sponsorship

TEKsystems 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 (46)
2024 (52)
2023 (33)
2022 (22)
2021 (36)
2020 (53)

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Ryan Skains
Vice President, TEKsystems Global Services
linkedin
Company data provided by crunchbase