Senior UI Test Automation Engineer for Excel-Based Add-in Testing (UFT)

Role: Senior UI Test Automation Engineer for Excel-Based Add-in Testing (UFT)

Location: NYC – Remote from EST (Preferred candidates from NYC or nearby states)

Duration: Long Term Contract

Over all 12+ years

1. Purpose

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.

2. 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:
  • Test plans
  • Test case documentation
  • Test summary reports
• Recommendations for further automation and process improvements.

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

4. 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]