Job Description : 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 issuesWrite 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.Skills Required
Metadata Management, Big Data Testing, BigQuery, Agile Scrum, Gitlab, Data Warehouse, Jira, Sql, Database Testing, Cloud Storage, Confluence, DataFlow, Data Governance, Python, Etl