ETL Tester (Claims)

Duties and responsibilities

• Constantly develop a deeper understanding of available data.
• Work to understand multiple operational departments and how data is captured and used within the organization.
• Become an expert in business rules, system functionality and architecture.
• Aptitude to evolve the current data quality processes into an enterprise data quality practice.
• Write complex SQL queries for source and target systems to verify the data for the ETL processes.
• Review business requirements, functional specifications, use cases, design, and architecture documents in order to create effective, value add test plans.
• Independently develop, modify, and execute test plans based on requirements and design documents including, but not limited to, the following methods: Duplicate run testing, Negative testing with invalid test data, Build and execute regression test scenarios.
• Provide estimates and timeframe necessary for testing a project to ensure a high-quality implementation.
• Contribute to and maintain project documentations.
• Identify, report and track defects and User Experience issues through a system of record.
• Collaborate with external teams on root cause analysis.
• Maintain close interaction with business and technical peers during the project life cycle.
• Actively participate in requirements and code reviews.
• Actively participate and drive improvements in Agile Scrum delivery.
• Ability to handle multiple projects simultaneously and meet deadlines in a fast-paced environment.
• Be a thought leader in the test design and execution arena (manual and automated).
• Identify process bottlenecks and suggest improvement actions.

Position Requirements

• Experience with dimensional databases.
• Ability to thrive in a project-based environment with evolving requirements.
• Strong analytical skills with the ability to collect, aggregate, analyze, and wrangle significant amounts of information with attention to detail and accuracy.
• Hands-on experience validating End User reports.
• Hands-on experience in ETL process testing is a must.
• Strong hands-on experience using SQL complex queries for results validation, data mining and evaluating foreign key dependencies.
• Strong ability to troubleshoot issues, identifying root causes and support external teams in development of resolutions.
• Hands-on experience with one or more scripting languages (C#, Visual Basic, Python, JS, PowerShell etc.) is a strong plus.
• Hands-on experience in Regression Test Strategies, Regression suite maintenance and execution.
• Hands-on experience with SSIS packages is a strong plus.
• Deep understanding of Development and Test cycles, including respective best practices.
• Strong hands-on experience in Agile and Waterfall methodologies.
• Strong communication and Client/Business interfacing and interpersonal skills are a must.
• Experience using QA/test automation frameworks (Selenium or ReadyAPI) will be a plus.
• Experience leveraging any AI tools or command prompting for QA testing will be a plus.

Pay

$65-75/hour (depends on experience level).

Schedule

This is a contract position with candidates expected to work 40 hours/week.

About The Company

Peterson Technology Partners (PTP) is an Equal Opportunity Employer committed to creating a transparent, inclusive, and human-centered hiring experience. For more than 28 years, PTP has operated as one of the top IT staffing and recruiting firms in the USA built on trust, long-term partnerships, and technical excellence. Based in the Chicago suburb of Park Ridge, IL, our team of more than 500 employees and consultants is dedicated to: Helping every client make the best hiring decisions possible Matching professionals with the right IT jobs and career opportunities As part of that commitment, we believe in providing clear information about how our hiring technologies work and how your data is used. The following section outlines our AI-assisted interview process and your rights as a candidate.

AI-Assisted Interview Experience

To provide a consistent, fair, and flexible experience for all candidates, we use AI-assisted tools to support parts of the interview process. This includes our proprietary AI platform Pete & Gabi, which includes AI recruiter Rebecca. These AI hiring tools help us: Conduct recorded video interviews Transcribe interviews Summarize candidate responses Generate job-related insights Streamline communication and scheduling Please note that: The AI does NOT make hiring decisions; all decisions are made by our human recruiters, hiring managers, or client partners. The AI does not evaluate facial expressions, emotions, or physical traits; it is used only to support fairness, consistency, and efficiency. If you prefer a non-AI interview format, we will gladly provide an alternative.

Technical or Case Interviews

When applying for certain tech jobs, you may participate in: A technical interview A coding challenge A case study A client-specific assessment We will always explain what to expect in advance so you can prepare with confidence.

Human Review & Selection

Every candidate's profile including interviews, conversations, and assessments is reviewed by experienced recruiters and hiring leaders. AI insights may assist with organization and evaluation, but final decisions are always human-driven.

Your Rights as a Candidate

At PTP, every candidate has the right to: Request a non-AI interview path Ask how your data is being used Request access to transcripts or interview recordings Request deletion of your AI-recorded interview Receive clear, timely communication Our goal is to ensure you feel respected, informed, and supported throughout your experience. Our Commitment: For more than 28 years, PTP has focused on putting people first candidates, consultants, employees, and clients. We're committed to a hiring process that is: Transparent Compliant Equitable Powered by innovative technology that enhances not replaces human judgment Welcome to the future of hiring at Peterson Technology Partners. We're excited to learn more about you. Equal Employment Opportunity: Peterson Technology Partners is an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, color, religion, national origin, gender identity, sexual orientation, disability, veteran status, or any other protected characteristic.