This job has closed.

Damco Solutions · 2 months ago

Mid QA Engineer – Data & ETL Testing

New Jersey, NJ

Full-time

Hybrid

Entry, Mid Level

$65K/yr - $80K/yr

2+ years exp

Damco Solutions is seeking a Mid QA Engineer specializing in Data & ETL Testing to ensure the quality and reliability of data across enterprise data warehouse environments. The role involves validating data movement, testing ETL processes, and collaborating with data engineers and analysts to implement QA best practices.

Enterprise SoftwareInformation TechnologyInsuranceSoftwareSoftware EngineeringWeb Development

H1B Sponsor Likely

Responsibilities

Perform source-to-target testing for EDW systems using SQL (manual and automated)

Validate data transformations, manipulations, and data quality/completeness across data pipelines

Conduct comprehensive testing of ETL processes, dimensional data models, and reports

Execute ETL workflows and data validation processes using scheduling tools

Develop and execute test plans to validate data within on-prem and cloud data warehouses

Identify, document, and resolve data quality issues in collaboration with data engineering teams

Ensure consistency and accuracy of data across various sources and reporting systems

Contribute to the continuous improvement of QA testing strategies and methodologies

Implement QA automation frameworks and best practices for data validation

Partner with Client, data engineers, architects, and QA leads to define test requirements and deliverables

Work with the Lead Data QA Engineer to maintain and support testing infrastructure

Prepare detailed reports on data quality findings, metrics, and improvement recommendations

Qualification

Data WarehousingETLSQLETL validationData QualityTableauPower BISSISMS SQL ServerSnowflakeDBTQA automation toolsInsurance data

Required

Bachelor's or master's degree in computer science or a related field

2-7 years of experience in data warehouse testing or development

Strong understanding of Data Warehousing (DW), ETL, and Data Quality concepts

Proficiency in SQL, RDBMS, and ETL validation

Experience validating reports and dashboards using Tableau, Power BI, or similar tools

Exceptional attention to detail with a strong, results-driven approach

Excellent verbal and written communication skills

Self-starter with strong ownership, accountability, and collaboration skills

Willingness to provide off-hour support as needed

Preferred

Experience with SSIS and MS SQL Server

Exposure to Snowflake and DBT environments

Familiarity with QA automation tools and frameworks

Understanding of ETL workflows, data warehouse testing procedures, and cloud data ecosystems

Experience with Insurance data and hybrid (on-prem/cloud) architectures is a plus

Company

Damco Solutions

Glassdoor3.9

Damco Solutions is a provider of IT solutions, services, and products.

Founded in 1996

Plainsboro, New Jersey, USA

1001-5000 employees

https://www.damcogroup.com/

H1B Sponsorship

Damco Solutions 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 (5)

2024 (8)

2023 (13)

2022 (11)

2021 (4)

2020 (7)