Talent
Senior Test Analyst (Informatica)
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Job Description
Senior Test Analyst (Informatica ETL / Data Warehouse)
Contract Duration: 6 months (Initial term)
Location: Remote
Day Rate: £545 per day. (Inside IR35)
Security Clearance: Active SC Clearance Required (BPSS minimum acceptable for onboarding)
Start Date: Immediate
Role Overview
We are seeking an active SC-cleared Senior Test Analyst to lead quality assurance for a high-priority Data Warehouse migration project within a UK public sector department. The role focuses on validating the migration from SAS to Informatica ETL pipelines, ensuring high data quality, robust system integration, and reliable performance across complex enterprise data environments.
Key Responsibilities
- Test Strategy and Execution: Prepare comprehensive Test Plans and Test Cases for System Testing, System Integration Testing (SIT), and User Acceptance Testing (UAT).
- ETL Pipeline Testing: Perform end-to-end testing on Informatica ETL pipelines, validating data transformations during SAS-to-Informatica migration.
- Data Management and Quality: Prepare, manage, and govern test data, conducting interface testing, data quality validations, and load testing.
- Sign-off Governance: Own test reporting and deliver formal test sign-offs for production readiness.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Required Skills And Experience
Mandatory Technical Experience
- Extensive hands-on experience with Informatica PowerCenter (v10.6 strongly preferred).
- Strong SQL capabilities with Oracle databases.
- Proficiency in UNIX shell scripting for test automation and pipeline verification.
- Direct experience with SAS to Informatica ETL migration within a Data Warehouse context.
Mandatory Certifications / Clearance
- Active SC Clearance.
- AWS Certified Cloud Practitioner (or higher).
- Azure AI Fundamentals (or practical awareness of ML/AI services).
Desirable Experience
Get help with your application
Your very own career expert that helps elevate your application to the next level.
- Big Data and Cloud Processing: Hands-on experience with AWS (EMR, S3, Lambda, Redshift, Athena, CloudWatch) and PySpark/Python for large-scale batch processing.
- DevOps and CI/CD: Familiarity with automated testing pipelines, Infrastructure as Code (Terraform), and Git/GitLab workflows.
- Data Engineering and Governance: Experience in dimensional modeling, data-quality management, and basic Power BI for end-to-end flow validation.
- Delivery Methodologies: Working in Agile public sector environments using Jira and Confluence.
£72.66 / hr
Talent International UK and its subsidiaries, Digital Gurus, Infinite Talent, and Rethink act as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this opportunity, you accept the T&C's, Privacy Policy, and Disclaimers which can be found at talentinternational.co.uk.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location