Skip to Content

QA Data Test Lead

--Cincinnati, Ohio (Hybrid)--

Job Title: QA Data Test Lead

📍 Location: Cincinnati, Ohio (Hybrid)

Job Description

The Candidate is expected to work on large datasets and will be involved in ETL testing, and thorough validation between the source and target.

Responsibilities

  • 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

Required Skills & Experience

  • 6+ years of total technical experience in ETL testing
  • Experience in developing ETL test plans, test cases, and validating large-scale data migrations
  • P&C experience is mandatory
  • Strong understanding of ETL processes, SQL, Spark, Hive, and data migration
  • 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
  • Excellent team player

📩 Interested candidates can share their updated resume along with:

  • Current Location
  • Work Authorization / Visa Status
  • Availability
  • Expected Rate
  • LinkedIn Profile