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