Summary: The role of Informatica Tester requires strong expertise in ETL/Data Warehouse testing, particularly with Informatica PowerCentre and Oracle SQL. Candidates should have hands-on experience in UNIX/Linux Shell Scripting and data validation. The position emphasizes the importance of security clearance, with a commitment to inclusivity and accessibility in the recruitment process.
Key Responsibilities:
- Perform ETL/Data Warehouse testing.
- Utilize Informatica PowerCentre for data processing.
- Validate data using Oracle SQL.
- Execute UNIX/Linux Shell Scripting for testing purposes.
- Conduct data reconciliation and transformation validation.
- Test batch processing and ETL pipelines.
Key Skills:
- Strong experience in ETL/Data Warehouse testing.
- Hands-on experience with Informatica PowerCentre (v10.6 preferred).
- Solid experience with Oracle SQL for data validation and testing.
- Experience in UNIX/Linux Shell Scripting.
- Proven ability to perform data reconciliation and transformation validation.
- Experience in testing batch processing and ETL pipelines.
- Working knowledge of SAS.
- Experience in validating SAS to Informatica migration projects.
- Familiarity with data modelling concepts.
- Experience with test management tools (e.g., HP ALM, Jira).
- Exposure to data quality frameworks and governance controls.
Salary (Rate): £537 per day
City: London
Country: UK
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Must-Have Skills and Experience
Strong experience in ETL/Data Warehouse testing
Hands-on experience with Informatica PowerCentre (v10.6 preferred)
Solid experience with Oracle SQL for data validation and testing
Experience in UNIX/Linux Shell Scripting
Proven ability to perform data reconciliation and transformation validation
Experience in testing batch processing and ETL pipelines
Desirable Skills
Working knowledge of SAS (statistical analysis system)
Experience in validating SAS to Informatica migration projects
Familiarity with data modelling concepts (dimensional models, star schema)
Experience with test management tools (eg, HP ALM, Jira)
Exposure to data quality frameworks and governance controls
Due to the nature and urgency of this post, candidates holding or who have held high level security clearance in the past are most welcome to apply. Please note successful applicants will be required to be security cleared prior to appointment which can take a minimum 10 weeks. LA International is an award-winning partner of choice for many of the world's most influential companies and government organisations. Holding Enhanced Government Security Accreditation, we are recognised as the European market leader in the delivery of Security Cleared talent to organisations that demand the very highest levels of security, compliance and assurance.
An award-winning organisation, having secured the prestigious Queens Award for Enterprise: International Trade over multiple years. We are committed to fostering an inclusive, equitable and accessible workplace where everyone feels valued and supported. We welcome applications from all individuals, regardless of background or identity, and we encourage candidates who may not meet every listed requirement to still apply. If you require any adjustments or support during the recruitment process, please let us know and we will work with you to ensure a fair and accessible experience.
Please Note: If a high volume of applications is received, only candidates shortlisted will be contacted.