Senior UI Test Automation Engineer

This Statement of Work (SOW) outlines the roles, responsibilities, and deliverables for the engagement of a Senior UI Test Automation Engineer. The engineer will focus on developing, maintaining, and executing automated UI test cases for an Excel-based add-in, utilizing Unified Functional Testing (UFT) and scripting languages such as VBScript for FDR squad.

 

• Scope of Work
  
   

2.1 Objectives

 

• Design and implement robust UI test automation solutions for Excel add-in functionalities.
• Ensure high test coverage and quality assurance throughout the software development lifecycle. 
  
   

2.2 Key Responsibilities

 

• Analyze business and technical requirements for the FDR Excel-based add-in.
• Develop and maintain automated UI test scripts using UFT.
• Write reusable, maintainable, and scalable code in VBScript and/or JavaScript.
• Integrate automated tests with CI/CD pipelines as required.
• Execute automated test suites and analyze test results.
• Identify, report, and track defects in collaboration with the development team.
• Create and maintain test documentation, including test plans, test cases, and test summary reports.
• Provide recommendations for process improvements and automation best practices.
• Mentor junior team members as needed. 
  
   

2.3 Deliverables

 

• Robust Automation framework for the Excel add-in application - FDR Editor
• Automated test scripts for all key UI workflows in the Excel add-in.
• Test execution reports and defect logs.
• Test documentation including:
• Recommendations for further automation and process improvements.
• Skillset & Experience Requirements
• 5+ years in UI test automation, preferably with Excel add-in experience.
• Proficient in UFT (Unified Functional Testing).
• Strong expertise in VBScript and/or JavaScript.
• Experience with Excel object model and Office automation.
• Familiarity with CI/CD tools (e.g., Bamboo, Github) is a plus.
• Excellent problem-solving and communication skills.
• Tools & Environment
• Unified Functional Testing One or Opentext Functional Testing 24.4
• Microsoft Excel (Office 365 version)
• Scripting Languages: VBScript, SQL
• Source Control: Bitbucket, Github
• CI/CD: [e.g., Bamboo, Github actions]
• Defect Tracking: [e.g., JIRA]