QA Data Test Lead

Innovim Technology Solutions; Connecticut; On-site; USD 110,000 - 140,000; Full time

Job summary

Innovim Technology Solutions seeks a QA Data Test Lead to drive data quality across large-scale ETL pipelines and validate data integrity from source to target.

The role requires strong SQL, Hive, Spark, and Snowflake experience, plus familiarity with data testing tools. You will collaborate with data engineers and business stakeholders to ensure reliable data products and scalable validation processes.

Qualifications

• 6 years of total technical experience on ETL testing.
• Experience in developing ETL test plans, test cases and validating large scale data migrations.
• Strong understanding of ETL processes, SQL, Spark, Hive and data migration.
• Experience with Guidewire Claims.
• Advanced proficiency in writing SQL queries, hands-on experience with Hive, Spark, Spark SQL and data frame API.
• Experience with Snowflake data warehousing.
• Experience in testing using Informatica, IDMC, CDV, CDQ.
• Experience with data quality automation tools and frameworks.
• Excellent verbal and written communication skills.

Responsibilities

• The candidate will work on large datasets, ETL testing, and validate between source and target.
• Develop and execute test plans, test cases, and scripts to validate data accuracy, completeness, and integrity.
• Perform functional, integration, regression, and performance testing of data pipelines, ETL processes, and databases.
• Identify and investigate data anomalies, inconsistencies, and discrepancies; troubleshoot data quality issues.
• Collaborate with data engineers, data architects, business analysts, and stakeholders to understand data requirements and ensure data quality standards.
• Document test plans, test results, and data quality issues; communicate findings and recommendations effectively to technical and non-technical stakeholders.
• Recommend and implement improvements to data quality processes, tools, and methodologies.
• Automate data validation and testing processes where possible to improve efficiency and accuracy.

Skills

ETL testing

SQL

Data quality

Data validation

Communication

Team player

Tools

Hive

Spark

Spark SQL

Snowflake

Informatica

IDMC

CDV

CDQ

data frame API

Job description

Title: QA Data Test Lead

Location: Cincinnati, Ohio

• The Candidate is expected to work on large datasets and will be involved in ETL testing, and thorough validation between the source and target
• Develop and execute test plans, test cases, and scripts to validate data accuracy, completeness, and integrity.
• Perform functional, integration, regression, and performance testing of data pipelines, ETL processes, and databases.
• Identify and investigate data anomalies, inconsistencies, and discrepancies; troubleshoot and resolve data quality issues.
• Collaborate with data engineers, data architects, business analysts, and other stakeholders to understand data requirements and ensure data quality standards are met.
• Document test plans, test results, and data quality issues; communicate findings and recommendations effectively to technical and non-technical stakeholders
• Recommend and implement improvements to data quality processes, tools, and methodologies.
• Automate data validation and testing processes where possible to improve efficiency and accuracy.

Requirements - Must Have Skills:

• 6 years of total technical experience on ETL testing
• Experience in developing ETL test plans, test cases and validating large scale data migrations.
• Strong understanding of ETL processes, SQL, Spark, Hive and data migration
• Experience with Guidewire Claims.
• Advanced proficiency in writing SQL queries, hands-on experience with Hive, Spark, Spark SQL and data frame API.
• Experience with Snowflake data warehousing.
• Experience in testing using Informatica, IDMC, CDV, CDQ
• Experience with data quality automation tools and frameworks.
• Ability to document and present findings clearly and concisely.
• Excellent verbal and written communication skills.
• Strong analytical and problem-solving skills.
• Need to be excellent team player.