Remote ETL Testing Lead

Post Date

Oct 08, 2023

Location

Cincinnati,
Ohio

ZIP/Postal Code

45242
US
Jul 21, 2025 Insight Global

Job Type

Perm

Category

QA

Req #

CIN-656296

Pay Rate

$110k - $165k (estimate)

Job Description

An employer is looking for a Senior ETL Tester to sit remotely in the following cities only: Cincinnati, Ohio; Charlotte, North Carolina; Chicago, Illinois; Boca Raton, Florida; San Jose, California; or Portland, Oregon. The client is an enterprise grocery store chain and this role will primarily focus on leading all ETL testing efforts across various programs/pillars and performing all facets of data testing. Conduct requirement analysis, create test strategies, and execute test plans that will validate the projects data quality and data integrity as the data is transitioned through the ETL data warehouse process. Create test data to exercise data validations and test the compliance of information flows and data stores against data quality standards, and effectively communicate test progress, test results to the project stakeholders and management.



Key Responsibilities:



Guide testing efforts involving coaching, mentoring, code reviews, and contributing to improvements to frameworks, tools, processes and best practices



Provide oversight to ensure automation test suites are well maintained and operational



Provide accurate estimates for QA efforts including test case design/scripting, test data management, execution and defect correction



Understand Kroger's core quality metrics and how to utilize them to foster quality improvement



Design, develop, analyze, document and support CoE activities that drive continuous improvement across the organization



Manage quality assurance and testing projects, schedules, tasks and deliverables



Communicate quality issues and recommendations to improve quality to senior level management



Consult with technical development leads on feature designs to ensure product testability and identify coverage gaps in existing test tools or technologies



Develop and maintain software quality dashboards aligned with committed software quality SLAs and KPIs



Automate test cases and functional libraries using open source and commercial tools



Lead and coach CI/CD and SDLC/TDLC concepts: code review best practices, code coverage analysis, continuous test and delivery



Consult on automation tools/techniques, feasibility/implementation, process improvements and maintenance plans



Drive creative and innovative technical concepts to automate workflows from ideation to operational tools, designed with the capability to be reusable, maintainable and efficient



Support complex systems with significant integration points, external Third-Party systems through RESTful, and other protocol APIs and multi-step authorization factors



Develop and/or recommend tools to assist test engineers in test planning, execution and reporting



Exhibit strong stakeholder relationship, interpersonal, analytical and problem-solving skills



Must be able to perform the essential job functions of this position with or without reasonable accommodation

Required Skills & Experience

8+ years of software product development and delivery experience.



5+ years of ETL testing/SQL experience.



3+ years of Informatica Power Center, IDQ & IICS/IDMC experience.



3+ years' experience overseeing the development of data test plans, test scenarios, test cases, execution of test case and documentation of test results



2+ years of experience in some of the Azure Cloud tools: ADF, Pyspark, databricks notebooksExperience with Python and libraries like Panads, Numpy & Matplotlib



Ability to interpret and draw System & Architecture diagrams



Experience in summarizing large number of metrics into meaningful graphs and reports



Familiar with Latest Cloud Technologies

Nice to Have Skills & Experience

Bachelor's Degree in Computer Science or related information technology field



Any experience with automated testing in a cloud environment



Any experience working in environments utilizing the OKR work process



Any experience with creating and using test data management tools



Familiarity with NoSQL Databases

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.