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

Senior UI Test Automation Engineer For Excel-Based Add-In Testing

This statement of work 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.

The engineer will design and implement robust UI test automation solutions for Excel add-in functionalities, ensuring high test coverage and quality assurance throughout the software development lifecycle.

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

The deliverables include a 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, and test documentation including test plans, test case documentation, and test summary reports. Additionally, recommendations for further automation and process improvements will be provided.

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

• 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]