Need ETL Test Lead - Jersey City , NJ (Hybrid)

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 6 month(s)
No Travel Required

Skills

Python
sql
ETL
Lead
Data
Test

Job Details

Role Name: ETL Lead Tester
Location: Jersey City, NJ (3 days in office)
Duration: 6-12 Months

Key Skills:
  • ETL Testing & Data Validation
  • Python (for automation and validation frameworks)
  • Strong SQL (data extraction, validation, and transformation logic)
  • Experience in data migration projects
  • Data Quality & Integrity Checks
  • Test Planning, Strategy, and Execution
  • Test Case Development and Documentation
  • Requirement Analysis & Stakeholder Communication

Job Description:

We are seeking an experienced ETL Test Lead / Data Quality Analyst to manage and lead data testing efforts across data migration and transformation initiatives. The ideal candidate will have a strong command of ETL testing principles, data quality validation, and hands-on skills in Python and SQL, with the ability to guide teams and collaborate effectively with stakeholders.

Responsibilities:

  • Lead and manage end-to-end testing efforts for ETL processes, ensuring data accuracy, consistency, and performance during data migrations and transformations.
  • Define and execute test strategies, test plans, and test cases tailored to validate complex data flows and transformations.
  • Collaborate with data engineers, developers, business analysts, and stakeholders to understand requirements and translate them into robust test scenarios.
  • Design and implement automated test frameworks and scripts using Python to streamline testing efforts and improve validation coverage.
  • Perform thorough data quality checks and validation routines to ensure integrity and completeness across data sources and destinations.
  • Monitor, track, and resolve data-related issues, escalating as necessary to ensure timely resolution.
  • Use tools like Pentaho Data Integration (PDI) or custom Python-based ETL frameworks to understand and validate data workflows.
  • Provide technical guidance and mentorship to ETL testing team members, ensuring adherence to best practices and quality standards.
  • Engage with customers and stakeholders to gather requirements, provide regular updates, and ensure satisfaction with deliverables.
  • Drive continuous improvement initiatives within the ETL testing lifecycle, enhancing automation, efficiency, and overall quality.

Qualifications:

  • Bachelor's degree in Computer Science, Information Systems, or related field.
  • 10+ years of experience in ETL/Data Warehouse testing.
  • Proficient in SQL and Python, with experience in writing custom test scripts.
  • Strong background in data migration projects and data validation across multiple platforms.
  • Experience with test automation tools or frameworks related to ETL validation.
  • Prior experience with Pentaho Data Integration (PDI) is a plus.
  • Excellent verbal and written communication skills.
  • Strong analytical thinking and problem-solving ability.
  • Ability to work independently and as part of a cross-functional team.

Best Regards,

Chetna

-D

-Fax

Truth Lies in Heart

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.