Test Analyst (Informatica ETL/Data Warehouse)

Talent International Uk

United States

4 days ago

Apply on computerjobs.com

Prepare application

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

computerjobs.com

Tech stack

Agile Methodology Artificial Intelligence Amazon Web Services Amazon S3 Automation of Tests Microsoft Azure Batch Processing Big Data Cloud Computing Continuous Integration Data Validation Information Engineering

+24 more

Extract Transform Load (ETL) Data Warehousing DevOps Python (Programming Language) Unix Shell Load Testing Oracle Databases Power BI SAS (Software) System Integration Testing System Testing Systems Integration Test Data Strategies of Testing Informatica Powercenter Gitlab Git SC Clearance AI Platforms Pyspark Atlassian Tools Data Management Cloudwatch Terraform

Job description

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., * 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.

Requirements

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 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 modelling, 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.