ETL Tester

Job Title: Senior ETL Tester

Contract: W2 Only

Position Summary

We are seeking an experienced Senior ETL Tester to join our data engineering and analytics team. The ideal candidate will have deep expertise in validating complex data pipelines, ETL processes, and data transformations across big data and cloud platforms. You will play a key role in ensuring data accuracy, integrity, and compliance by developing robust test strategies, executing automation frameworks, and collaborating with cross-functional teams in an Agile environment.

Key Responsibilities

• Review business and technical requirements to derive comprehensive test scenarios and plans.
• Design, develop, and execute test cases for ETL pipelines and data workflows.
• Write advanced SQL queries to validate large datasets in a big data ecosystem.
• Perform thorough regression, integration, and E2E testing of data transformations and reporting pipelines.
• Identify, document, and track bugs using defect tracking tools and participate in root cause analysis.
• Create and maintain automated testing scripts using tools such as Selenium (Java) or PySpark (Python).
• Collaborate with data engineers, business analysts, and product owners to validate system requirements and data mappings.
• Work with modern data visualization tools such as Tableau, Power BI, or Alteryx to validate data integrity.
• Develop reusable testing frameworks to improve test coverage and accelerate testing cycles.
• Contribute to Agile ceremonies and act as both an individual contributor and team collaborator.

Required Qualifications

• 12 14 years of experience in software testing with at least 4+ years in ETL/Data Warehouse Testing.
• Strong command of SQL and the ability to write complex queries for large datasets.
• Proven experience working on AWS Cloud platforms and big data environments.
• Solid understanding of ETL concepts, data profiling, and data quality assurance.
• Hands-on experience with test automation tools: Selenium with Java or PySpark with Python.
• Experience working on Agile/Scrum teams and using tools like JIRA, TestRail, or similar.
• Strong analytical and problem-solving skills, with the ability to debug and resolve data issues.
• Excellent verbal and written communication skills for interacting with stakeholders across teams.
• Ability to independently define and drive test strategy and execution plans.

Preferred Qualifications

• Experience in Healthcare or Insurance domain is a strong plus.
• Proficiency in data visualization tools such as Tableau, Power BI, or Alteryx.
• Familiarity with the full Software Development Life Cycle (SDLC) and QA methodologies.
• Working knowledge of change management and defect tracking systems.
• Prior experience with CI/CD pipelines and automated data regression frameworks.