Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

ETL Test Engineer

Anveta

Role: Senior Data QA / ETL Test Engineer


Location: NJ or PA - Onsite

Role Overview


The Data QA / ETL Test Engineer will own end-to-end data testing activities for large-scale data platforms supporting P&C insurance solutions. This role requires strong hands-on experience in ETL testing, data validation, and automation, along with the ability to work closely with onsite stakeholders and offshore teams. The candidate is expected to take ownership of data quality, testing strategy, defect triage, and communication across teams.

Key Responsibilities

  • Own onsite data QA activities, acting as the primary point of contact for data testing and quality assurance.
  • Validate large datasets across source-to-target systems, ensuring accuracy, completeness, and integrity.
  • Develop, review, and execute ETL test plans, test cases, and test scenarios covering functional, integration, regression, and performance testing.
  • Perform thorough data validation on ETL pipelines including extraction, transformation, and loading processes.
  • Write and execute complex SQL queries for data analysis, reconciliation, and validation.
  • Test and analyse batch job runs, review logs, and troubleshoot data and ETL failures.
  • Perform root cause analysis (RCA) for data defects and ETL issues, and work with data engineering teams to drive resolution.
  • Automate data validation and testing processes using SQL, Python, or similar scripting tools to improve efficiency and coverage.
  • Ensure data flows correctly through various stages of the pipeline and meets defined quality standards.
  • Collaborate closely with data engineers, architects, business analysts, and offshore QA teams to clarify requirements and prioritize defects.
  • Review offshore test execution, provide guidance, and ensure alignment with onsite expectations.
  • Document test plans, test results, data quality issues, and communicate findings clearly to both technical and non-technical stakeholders.
  • Drive continuous improvement in data quality processes, tools, and testing methodologies.
  • Ensure adherence to Agile practices, quality standards, and best practices in an onsite-offshore delivery model.
Must-Have Skills & Experience
  • Hands-on experience in ETL and data testing.
  • Strong understanding of ETL processes, data migrations, and data warehousing concepts.
  • Advanced proficiency in SQL, including writing complex queries for data validation.
  • Hands-on experience with Hive, Spark, Spark SQL, and DataFrame APIs.
  • Experience working with Snowflake data warehouse.
  • Experience testing data pipelines built on modern big data platforms.
  • Knowledge of ETL tools such as IDMC / IICS and familiarity with Informatica-based ecosystems.
  • Experience with data quality automation tools and frameworks.
  • Strong troubleshooting skills, including log analysis and RCA for data and ETL issues.
  • Experience with defect tracking and test management tools such as Jira or HP ALM.
  • Solid understanding of regression testing in data-centric systems.
  • Good understanding of Property & Casualty (P&C) insurance data, models, and workflows is a strong advantage.
Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the ETL Test Engineer in Edison, NJ vacancy
  •  ...Job Description Job Description Job Description: Test Data QA Engineer Role: Test Data QA Engineer Location: Copell, TX/ NYC, NY /St...  ...different testing environments. Perform data validation for ETL/data pipelines and application integrations. Develop and... 
    Suggested
    Local area
    Remote work

    Han IT Staffing

    Iselin, NJ
    21 days ago
  •  ...Job Description Job Description ob Description QA Test Automation Engineer Location: Delaware- 5 Days (Nearby states only) Number of positions: 5 Overall: 10 Key Responsibilities Design, develop, and maintain automated test scripts for web, API, and... 
    Suggested
    Shift work

    Han IT Staffing

    Iselin, NJ
    21 days ago
  •  ...Job Description Job Description QA Automation Engineer (Java Selenium) Healthcare Location: New York City, NY (Onsite/Hybrid)...  ...have hands-on experience in automation framework development, API testing, and validating healthcare applications while working in an Agile... 
    Suggested
    Contract work

    Han IT Staffing

    Iselin, NJ
    21 days ago
  •  ...Job Description Job Description Job Title: QA Engineer (Karate Automation) Location: Jersey City, NJ (Hybrid/Onsite) Duration...  ...experienced QA Engineer with strong expertise in Karate Automation Testing to join our team. The ideal candidate will be responsible for... 
    Suggested
    Long term contract

    Han IT Staffing

    Iselin, NJ
    21 days ago
  • $115k - $165k

     ...technology initiatives in a collaborative environment with opportunities for professional growth. J ob Title: Performance Test Engineer Location: Remote Position Type: Full-time, Direct W2 - [Not open to C2C or 1099] Salary Range: $115,000-$165,000... 
    Suggested
    Full time
    H1b
    Local area
    Immediate start
    Remote work
    Visa sponsorship

    Bright Vision Technologies

    Middlesex, NJ
    1 day ago
  • $100k - $120k

     ...Job Description Job Description Job Title: Quality Engineer Job Description The Quality Engineer leads the implementation, maintenance...  ...in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer... 
    Permanent employment

    Actalent

    Edison, NJ
    2 days ago
  • $115k - $165k

     ...to technology initiatives in a collaborative environment with opportunities for professional growth. Job Title: Accessibility Test Engineer Location: Remote Position Type: Full-time, Direct W2 - [Not open to C2C or 1099] Salary Range: $115,000–$165,000 Annually... 
    Full time
    H1b
    Local area
    Immediate start
    Remote work
    Visa sponsorship

    Bright Vision Technologies

    Edison, NJ
    5 days ago
  •  ...Job Description Job Description Position: senior test engineer Days onsite: 2 days a week onsite Location: 95 christopher columbus Blvd in Jersey city, NJ or 1 World trade center in NYC. Contract: 3 months extendable Interview process: 1 and done but... 
    Contract work
    Flexible hours
    2 days per week

    Expert In Recruitment Solutions

    Summit, NJ
    21 days ago
  •  ...Mechanical Engineer – Automotive About the Company: KKR Consulting partners with businesses to solve challenges, streamline processes,...  ...analysis, GD&T, and DFM/DFA reviews Support prototype builds, testing, and validation (DV/PV) Participate in FMEA, root cause analysis... 
    Full time
    Contract work

    KKR Consulting

    Woodbridge, NJ
    4 days ago
  • $103.71k - $138.28k

     ...ownership, deliver meaningful impact, and help shape the future of AI‑ready connectivity, join us today. The Role The Field Engineering Quality Control Engineer is responsible for overseeing and managing quality assurance processes that support Field Engineering... 
    Full time
    Temporary work
    For contractors

    Lumen

    Edison, NJ
    1 day ago
  •  ...Job Description Job Description Automation Engineer Network Observability Pyramid Level: P3C Experience: 6 years in Network Automation or Infrastructure Automation Job Summary We are looking for an Automation Engineer to develop and maintain automation... 

    Vantage Point Consulting

    Iselin, NJ
    19 days ago
  • $124k - $186k

    New Jersey, United States of America Job Family Group: Discipline Engineering Worker Type: Regular Posting Start Date: November 11, 2026 Business Unit: Trading and Supply Experience Level: Experienced Professionals Job Description: What'... 
    Full time
    Temporary work
    Part time
    For contractors
    Work experience placement
    Local area
    Remote work
    Relocation package
    Flexible hours

    Shell

    Sewaren, NJ
    10 days ago
  •  ...significant six-figure earning potential! Own Your Territory. Control Your Income. Dartronics is seeking a motivated Technical Sales Engineer to develop and grow a high-potential territory. This is a true hunter role. You'll build your own pipeline, develop new... 
    Live in

    Dartronics, Inc.

    Edison, NJ
    18 days ago
  •  ...Job Title: QA Automation Engineer Location: Berkeley Heights, NJ Job Summary: We are seeking a skilled QA Automation Engineer with...  ...Playwright to design, develop, and maintain scalable automated test frameworks for web applications. The ideal candidate should have... 

    Smart IT Frame LLC

    Berkeley Heights, NJ
    4 days ago
  • $100k - $125k

     ...About the Role  Albireo Energy is seeking an Automation Design Engineer to design, develop, and deliver automation and monitoring...  ...practices, including VLANs, segmentation, and redundancy.  Testing and Commissioning  ~ Develop test procedures and checklists for... 
    Temporary work
    For contractors
    For subcontractor
    Work at office
    Local area
    Remote work

    Albireo Energy

    Edison, NJ
    5 days ago
  •  ...About Photon Photon is a Digital Engineering and Digital Modernization company founded in 1999, partnering with leading global enterprises...  ...digital platforms and experiences. Job Title Test Automation Engineer | Berkeley Heights, NJ Job Summary... 
    Contract work

    Photon

    Berkeley Heights, NJ
    12 days ago
  •  ...Job Description Job Description Director of Industrial Engineering & Automation About the Opportunity We are seeking an experienced...  ...RFPs, technical evaluations, contract negotiations, testing, and commissioning. Establish performance, reliability, uptime... 
    Contract work

    TriSearch

    Perth Amboy, NJ
    8 days ago
  •  ...Job Title::Quality Assurance Engineering Job location: Berkeley Heights NJ Onsite Job Type: Full Time Industry experience in Software testing in Banking / Finance (preferably in Card/Payment) domain. Preferably having knowledge of Switch and Tandem Concepts... 
    Full time
    Work experience placement

    Envision Technology Solutions

    Berkeley Heights, NJ
    1 day ago
  • $120k - $130k

     ...USD Annually Description: Job Title: Quality Assurance Engineering Location: Berkeley Heights, NJ / Alpharetta, GA (Onsite 5...  ...do: Lead the execution of detailed quality assurance testing for complex software products. Develop and implement comprehensive... 
    Full time

    Judge Group, Inc.

    Berkeley Heights, NJ
    15 hours ago
  •  ...Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity. We work with a wide range of clients across many industries including... 
    Work at office

    Orion Innovation

    Edison, NJ
    2 days ago
  •  ...Process Engineer II - EDI Edison, New Jersey Full Time Benefits: 401(k) Health insurance Paid time off Summary: The purpose of the Process Engineer's role will be to provide technical leadership to operate a major asset (typical annual revenue of $50MM to $200MM) at target... 
    Full time

    Veracity Ventures Inc.

    Edison, NJ
    4 hours ago
  •  ...life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and...  ...help close out qualification packages.  ~ Work with client engineering and quality teams on site, representing Eurofins... 
    Full time
    Contract work
    Monday to Friday

    Eurofins USA BioPharma Services

    Edison, NJ
    4 days ago
  •  ...Job Description Job Description Job Title: HiL Validation Engineer Location: Lisle, IL (Day 1 Onsite) Job Type: Contract(C2C)...  ...experience in automotive ECU validation and Hardware-in-the-Loop (HiL) testing. The ideal candidate should have hands-on experience with... 
    Contract work

    Kasmo Inc

    Edison, NJ
    21 days ago
  •  ...frameworks. Karate Framework Expertise: Strong hands-on expertise and practical experience with the Karate framework. Senior SDET Experience: Senior-level SDET experience with ownership of projects and the ability to develop effective and comprehensive test strategies.... 

    Han IT Staffing

    Iselin, NJ
    21 days ago
  • $90k - $112.5k

     ...Our buildings deliver tens of thousands of products to hundreds of countries worldwide, every day. The Reliability & Maintenance Engineering (RME) team are the business partners that work tirelessly behind the scenes to make it happen. We drive continuous improvement, and... 
    Remote work
    Worldwide
    Flexible hours
    Shift work
    Night shift

    Amazon

    Avenel, NJ
    15 hours ago
  • $135k - $175.5k

     ...Our buildings deliver tens of thousands of products to hundreds of countries worldwide, every day. The Reliability & Maintenance Engineering (RME) team are the business partners that work tirelessly behind the scenes to make it happen. We drive continuous improvement, and... 
    Local area
    Worldwide
    Flexible hours
    Shift work
    Night shift

    Amazon

    Edison, NJ
    4 days ago
  • $94k - $101k

     ...Job Description Job Description The Quality Assurance Engineer I is responsible for conducting ongoing analysis of the production...  ...processes.  Performs inspections and sets quality assurance testing models for analysis of raw materials, materials in process, and... 

    Micro Stamping Corporation

    Somerset, NJ
    26 days ago
  • $104.8k - $192.2k

     ...wherever you want it to go.  Join EY and help to build a better working world. We are seeking an experienced  Identity Verification Engineer with hands-on expertise in 1Kosmos or Microsoft Verified ID Identity Platform , identity proofing, passwordless authentication,... 
    For contractors
    Summer holiday
    Flexible hours

    EY

    Iselin, NJ
    4 days ago
  •  ...Job Title : Sr Lab System Support Engineer Location : Rahway, NJ - onsite Job Description: Job Summary Sr Lab System Support Engineer plays a key role in supporting laboratory operations by ensuring the smooth functioning of lab systems, analytical... 

    Ruri Software Technologies LLC

    Avenel, NJ
    2 days ago
  •  ...person interview in New York City, NY. DIRECTV is seeking a System Engineer 2 with strong full stack software development and applied AI...  ...what you'll do: Full Stack AI Product Development * Design, code, test, deploy, and operate complete AI-enabled applications, including... 
    Work at office
    Local area
    Relocation
    Relocation package
    2 days per week

    DIRECTV

    Avenel, NJ
    4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to ETL Test Engineer. Be the first to apply!