ETL Test Automation - Senior Test Engineer

We are looking for a highly skilled and experienced ETL Test Automation as a Senior Test Engineer.

Technical Expertise

• Experience should have 3 years to 5 years of ETL/DW test automation.
• Strong knowledge of ETL processes, data warehouse concepts and database testing.
• Experience in big data testing, focusing on both automated and manual testing for data validation.
• Proficient in writing complex SQL queries (preferably BigQuery) and understanding database concepts.
• Understanding of GCP tools: BigQuery, Dataflow, Dataplex, Cloud Storage.
• Ability to transform simple/complex business logic into SQL queries.
• Hands-on experience in Python for test automation. Familiarity with test automation frameworks.
• Excellent communication and client-facing skills.
• Experience with version control systems like GITlab and test management tools such as JIRA and confluence.
• Demonstrated experience working in an Agile/SCRUM environment.
• GCP certifications or training in cloud data engineering.
• Familiarity with data governance, metadata management, and data forms.
• Exposure to real-time/streaming data systems, including monitoring, validation, and scaling strategies.
  

Key Responsibilities

• Design, execute, and maintain QA strategies for ETL/Data Warehouse workflows on Google Cloud Platform (GCP).
• Validate large-scale data migrations to ensure accuracy and completeness between source and target systems.
• Develop and maintain automation scripts using Python or any relevant automation tool.
• Identify, investigate and resolve data anomalies and quality issues
• Write and optimize complex SQL queries (preferably for BigQuery) to validate transformations, mapping, and business rules.
• Work closely with data engineers, architects and analysts to understand data requirements and support data quality initiatives.
• Collaborate in an Agile/SCRUM development environment.
• Perform manual and automated data validations for high-volume pipelines.
• Track and manage defects using JIRA and maintain transparency via Confluence.