> Markdown version of [/jobs/ext/1388543-data-qa-etl-test-engineer](https://www.wearedevelopers.com/jobs/ext/1388543-data-qa-etl-test-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data QA / ETL Test Engineer - **Company:** PamTen - **Location:** United States - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Agile Methodology, Data Analysis, JIRA, Big Data, Software Bug Management, Data Validation, Information Engineering, Extract Transform Load (ETL), Data Warehousing, Database Queries, Database Testing, Apache Hive, Python (Programming Language), Log Analysis, Regression Testing, SQL Databases, Software Testing Automation Framework, Data Streaming, Test Execution Engine, Strategies of Testing, Freeform SQL, Performance Testing, Snowflake, Apache Spark, Data Pipelines - **Published:** July 22, 2026 - **Apply:** https://www2.jobdiva.com/portal/?a=rijdnwzhw0mz36cpr0zwxqcj9yt1m405eam52pzlcqh06kjpfrmqaa2uyt3eiarf&compid=0/jobs/32436980#/jobs/32436980 ## About the Role * 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 Client 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. Soft Skills & Ownership Expectations * Strong ownership mindset with the ability to drive tasks to closure independently. * Excellent communication skills, especially in an onsite role coordinating with multiple stakeholders. * Ability to clearly document and present findings, risks, and recommendations. * Strong analytical and problem-solving skills with attention to detail. * Proven experience working in Agile teams within an onsite-offshore model. * Collaborative team player who can mentor offshore team members and set clear expectations. ## Description 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., * 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. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Continuous testing - run automated tests for every change!](https://www.wearedevelopers.com/videos/190-continuous-testing-run-automated-tests-for-every-change) ## Related Articles - [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Integration And E2E Testing: Are They Complementary or Interchangeable?](https://www.wearedevelopers.com/magazine/86-integration-and-e2e-testing-are-they-complementary-or-interchangeable) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)