ETL Test Engineer
Anveta
Role: Senior Data QA / ETL Test Engineer
Location: NJ or PA - Onsite
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.
- 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...SuggestedLocal areaRemote work
- ...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...SuggestedShift work
- ...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...SuggestedContract work
- ...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...SuggestedLong term contract
$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...SuggestedFull timeH1bLocal areaImmediate startRemote workVisa sponsorship$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$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 timeH1bLocal areaImmediate startRemote workVisa sponsorship- ...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 workFlexible hours2 days per week
- ...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 timeContract work
$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 timeTemporary workFor contractors- ...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...
$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 timeTemporary workPart timeFor contractorsWork experience placementLocal areaRemote workRelocation packageFlexible hours- ...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
- ...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...
$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 workFor contractorsFor subcontractorWork at officeLocal areaRemote work- ...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
- ...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
- ...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 timeWork experience placement
$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- ...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
- ...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
- ...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 timeContract workMonday to Friday
- ...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
- ...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....
$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 workWorldwideFlexible hoursShift workNight shift$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 areaWorldwideFlexible hoursShift workNight shift$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...$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 contractorsSummer holidayFlexible hours- ...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...
- ...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 officeLocal areaRelocationRelocation package2 days per week
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to ETL Test Engineer. Be the first to apply!






