What are the responsibilities and job description for the Data QA / ETL Test Engineer position at PamTen Inc?
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.
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.