This hands-on role will focus on ensuring data quality, validating ETL pipelines, and embedding automation into the testing lifecycle within an Agile delivery team.
Key Responsibilities:
- Design, develop and maintain automated test frameworks and test packs for ETL and data pipelines
- Create and execute component and integration test cases, including automated test scripts
- Validate data transformations, mappings and integrity across Talend and Oracle RDS systems
- Support QA-led test phases, including system testing, integration testing and performance testing
- Identify, log, track and support resolution of defects throughout the delivery lifecycle
- Collaborate with Data Engineers to understand pipelines and ensure test coverage aligns to requirements
- Contribute to test data creation and management for component and automated testing
- Support performance testing activities, including validation of large-scale data processing
- Review requirements and design artefacts to ensure testability and completeness
- Provide input into CI/CD pipeline integration for automated testing (e.g. GitLab pipelines)
- Maintain documentation of test scenarios, results and automation coverage
- Participate in Agile ceremonies and contribute to continuous improvement of QA practices
- Provide guidance and mentoring to junior QA engineers where required
Essential Skills & Experience:
- Proven experience as a QA/Test Automation Engineer in enterprise environments
- Strong experience testing ETL/data integration solutions (Talend preferred)
- Experience with data validation, reconciliation and database testing
- Strong SQL skills (Oracle preferred)
- Experience working with Oracle databases (including Oracle RDS)
- Experience building and maintaining automated test frameworks
- Familiarity with CI/CD tools and integrating automated tests into pipelines (e.g. GitLab)
- Experience working in Agile delivery teams
- Strong defect management and root cause analysis skills
- Active SC clearance
Desirable / Optional Skills:
- Experience with ETL tools such as Pentaho or Informatica
- Experience working in similar government programmes
- Exposure to performance testing tools and approaches
- Familiarity with CRS/FATCA or financial compliance data domains
- Experience with test data management tools or approaches
- Knowledge of DevOps and continuous testing practices
