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

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 ContractOver all 12+ yearsPurposeThis 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 WorkObjectivesDesign and implement robust UI test automation solutions for Excel add-in functionalities.Ensure high test coverage and quality assurance throughout the software development lifecycle.Key ResponsibilitiesAnalyze 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.DeliverablesRobust Automation framework for the Excel add-in application – FDR EditorAutomated test scripts for all key UI workflows in the Excel add-in.Test execution reports and defect logs.Test documentation including:Test plansTest case documentationTest summary reportsRecommendations for further automation and process improvements.Skillset & Experience Requirements5+ 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 & EnvironmentUnified Functional Testing One or Opentext Functional Testing 24.4Microsoft Excel (Office 365 version)Scripting Languages: VBScript, SQLSource Control: Bitbucket, GithubCI/CD: [e.g., Bamboo, Github actions]Defect Tracking: [e.g., JIRA]