Senior Test Analyst (Informatica)

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 & 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 & 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.

Required Skills & 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

• Big Data & Cloud Processing: Hands-on experience with AWS (EMR, S3, Lambda, Redshift, Athena, CloudWatch) and PySpark/Python for large-scale batch processing.
• DevOps & CI/CD: Familiarity with automated testing pipelines, Infrastructure as Code (Terraform), and Git/GitLab workflows.
• Data Engineering & 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 it's 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