Senior Database QA Automation Engineer, AVP

Charles River Development (CRD) is the FinTech division of State Street. Together with State Street’s Middle and Back-office services, Charles River’s cloud-based Front Office technology forms the foundation of the State Street Alpha® Platform, the first front-to-back solution in the industry.

CRD Engineering organization is innovating and transforming the platform by moving away from monolithic software to utilizing next generation cloud-based technology that leverages Microsoft Azure, Kafka, Snowflake, etc.

State Street is one of the largest custodian banks, asset managers and asset intelligence companies in the world, providing investment servicing, data & analytics, investments research & trading and investment management to institutional clients.

• At least 5 years of experience in software testing in a process driven technology environment.
• Demonstrated experience programming with any modern OOP language (like: Java, C#, SQL, Python).
• Very good knowledge about databases, including SQL query language.
• Demonstrated experience implementing and executing automation test scripts against web, native/desktop applications, APIs and batch applications.
• Demonstrated ability translating business requirements into comprehensive functional and technical test plans.
• Demonstrated experience using test cases, scripts, and automated test tools for verifying requirements on multi-tier applications.
• Demonstrated experience implementing automation tests with industry relevant tools.
• Effective written and verbal communication.

Nice to have:

• Experience in contributing to Unit tests.
• Experience working as a software tester in a database project (like data warehouse, data lake, ETL processes).
• Experience writing complex SQL queries for data validation.
• Experience in database performance testing and optimization.
• Understanding database security best practices.
• Familiarity with AI tools like Copilot to increase productivity.

• Work as a senior member of a Scrum team to execute the overall quality plan for one of Charles River’s products.
• Provide support and assistance to customers and other teams within Charles River.
• Work closely with the scrum master, product owner, architect, business analysts, product specialists, developers and other project team members to assist in carrying out the software quality responsibilities of the Scrum team.
• Create comprehensive test automation scripts from business requirements and functional specifications documents for product features of moderate complexity.
• Execute manual and automated functional, integration, regression, and performance tests.
• Maintain automated and manual test script libraries for functional, integration, regression, and performance testing.
• Align with the Software Development Life Cycle practices, comply with Information Security and Data Governance practices.
• Interpret results of automation tests and document software defects in issue tracking system; proactively communicate issues with developers and other project team members.
• Provide testing leadership by identifying opportunities for improvement in the Scrum team’s QA methodology.
• Innovate by researching and recommending new approaches to automation of testing, including use of Artificial Intelligence.
• Adhere to a testing schedule to ensure efficient and effective product delivery.
• Actively participate in the agile software development process by adhering to the CRD Scrum methodology including attending all daily standups, sprint planning, backlog grooming, and retrospectives.
• Participate in “testathon” activities as required by releases.
• Guide and mentor junior staff in proper creation of automated test scripts.

Employees are expected to work from the office per country-specific company guidelines. The role requires minimum of three days working from the office.