ETL / Data Warehouse Tester

Kforce Inc; New York (NY); Remote; USD 10,000 - 60,000; Full time

Job summary

A leading company seeks an ETL/Data Warehouse Tester for a remote contract opportunity. The position requires advanced SQL skills to create test automation scripts, validate data, and ensure testing efficiency. Candidates should possess a strong background in data warehousing and cloud technologies, with a focus on quality engineering improvements.

Benefits

Medical/Dental/Vision Insurance

401(k) Plan

Paid Time Off for salaried personnel

Qualifications

• Deep understanding of data warehousing concepts.
• Advanced SQL knowledge and strong data warehouse/ETL testing experience.
• Experience working on cloud technologies like Snowflake.

Responsibilities

• Create test automation scripts and validate data functionality.
• Build and execute test cases for production solutions on the enterprise data platform.
• Document and analyze test results, recommending corrective action.

Skills

SQL

Python

Data Warehousing Concepts

Test Automation

Tools

Snowflake

SQL Server

Oracle

Informatica

DataStage

Job description

This range is provided by Kforce Inc. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$74.00/hr - $84.00/hr

Responsibilities

Kforce has a client that is seeking an ETL/Data Warehouse Tester with Advanced SQL skills. This is a 100% remote contract to hire opportunity for a client based in NYC. Responsibilities:

• Create test automation scripts and leverage tools for validating data and application functionality
• Build and execute test cases to ensure the integrity of all production solutions deployed on the enterprise data platform including data pipelines, data warehouses, data marts and data sharing repositories
• Document and analyze test results and recommend corrective action
• Isolate, reproduce, manage, and maintain defects and test case databases, and verify fixes
• Support user acceptance testing conducted by business partners or end users
• Identify opportunities to reduce testing time and effort by automating repeatable tests
• Define and champion quality and testing best practices among development teams
• Identify opportunities for productivity gains through quality engineering process improvements and in the Agile development lifecycle; Develop procedures and proposals and lead the implementation of these changes
  
  

Requirements

• Deep understanding of data warehousing concepts
• Expert in SQL and knowledge on Python will be required
• Advanced SQL knowledge and strong data warehouse/ETL testing experience
• Data validation automation experience
• Experience working on cloud technologies like Snowflake
• Strong knowledge of SDLC process
• Experience with Enterprise Database technologies like SQL Server, Oracle, Data Integration (Informatica, DataStage), business intelligence, and reporting tools
• Experience creating test automation frameworks and test cases
• Demonstrated experience performing functional, end-to-end and regression testing
  
  

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.

We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.

Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.

This job is not eligible for bonuses, incentives or commissions.

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

By clicking “Apply Today” you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Contract

Job function

• Job function

  Business Development and Sales

• Industries

  Alternative Medicine, Hospitals and Health Care, and Mental Health Care

Referrals increase your chances of interviewing at Kforce Inc by 2x

Sign in to set job alerts for “ETL Specialist” roles.

Senior ETL Developer Lead with Guidewire Experience - Remote

Yonkers, NY $110,000.00-$120,000.00 1 week ago

Manhattan, NY $110,000.00-$160,000.00 4 days ago

Gen AI With Cloud- 100% Remote (Fulltime)

New York, NY $145,000.00-$260,000.00 7 months ago

New York City Metropolitan Area 4 hours ago

Senior Informatica Developer with expertise in IICS - Remote

New York, NY $110,000.00-$140,000.00 12 hours ago

New York City Metropolitan Area 2 weeks ago

New York, NY $120,000.00-$132,000.00 18 hours ago

New York, NY $139,500.00-$271,566.94 6 days ago

New York City Metropolitan Area $135,000.00-$160,000.00 4 weeks ago

Jersey City, NJ $110,000.00-$115,000.00 4 weeks ago

New York, NY $140,000.00-$185,000.00 2 days ago

Software Engineer, Web Core Product & Chrome Extension

New York, NY $140,000.00-$200,000.00 1 month ago

Salesforce Lead Developer (Full Time) - Remote

New York City Metropolitan Area 3 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.