ETL Test Engineer

Roles and Responsibilities

• Design, develop, and execute comprehensive test plans for ETL processes using Airflow and BigQuery.
  
• Collaborate with cross-functional teams to identify data requirements and ensure seamless integration of new features into existing systems.
  
• Develop and maintain complex SQL queries to troubleshoot issues related to data quality, integrity, and performance.
  
• Conduct thorough regression testing on large datasets to ensure accuracy and completeness of insurance claims processing.
  
• Participate in story testing sessions to gather feedback from stakeholders on product functionality.
  

Desired Candidate Profile

• 5-8 years of experience in ETL Testing or Data Testing with expertise in Airflow, BigQuery, GCP, Insurance Domain.
  
• Strong understanding of SQL concepts including joins, aggregations, subqueries etc. .
  
• Experience working with cloud-based technologies such as Google Cloud Platform (GCP) is required.