Quality Assurance at State Street in Boston, Massachusetts

Job Description:

Quality Assurance (State Street Bank and Trust Company; Boston, MA): Responsible for testing software for advanced internal proprietary, industry-leading client server platforms by coordinating with development, writing test cases, executing tests, contributing to building our automated testing tools and scripts, and conducting product testing supporting the Company's QA environment. Specific duties of the position include: Analyzing testing requirements for State Street's software platforms and designing effective test cases to meet requirements; Developing System and Integration ETL Test plans, ETL Test Strategy and Test scenarios for functional testing, integration testing and regression testing based on the system requirements and the high-level design documents; Writing, reviewing, and implementing test plans and test cases (both manual and automated); Taking ownership of product modules, QA effort estimation, and performance of required testing for all software modifications; Working closely with QA team members and development and other IT teams to ensure quick resolution of reported issues; Writing advanced DML and DDL SQL Queries using tools like TOAD, SQL Developer to check and analyze data integrity; Building complex SQL queries to validate direct mapping, default values and complex transformations as ETL process by Informatica/Talend tools; Implementing/developing QA tools to translate the XML and .DAT files into database tables and building Excel based macros for report comparison in xls and csv format; Monitoring Autosys/Quartz jobs/logs which loads data from source systems to target systems; Implementing Automation testing for end-to-end ETL data validations; Documenting all test artifacts, including test cases and test plans, in the Company's Test Case Management System; Conducting initial assessment on the application and feasibility / risk analysis study for automation; Maintain Traceability Matrix to make sure every test case is implemented according to Business requirement; Using inbuilt / commercial reporting tools to generate, test and validate reports and the data lineage; Leading onsite/ offshore teams to plan and strategize testing of large scale reporting applications; Estimating QA efforts and sizing; Analyzing technologies/ methodologies which will improve the Company's test practices; Using scheduling/delivery tools to validate various delivery mechanisms of reports like SFTP; Maintaining QA environments, and deploying build artifacts to QA on Linux boxes and configuring the test setup; Validating API's, test web services by making REST calls, using SOAP UI or other web services test tools; and Stress testing application to ensure there are no memory leaks or database deadlocks. Telecommuting permitted pursuant to Company policy.

Minimum Requirements: Bachelor's degree in Computer Science, Computer Engineering, Electronics Engineering, or a related technical field, or its equivalent; plus 5 years in any occupation/ title providing experience in software quality assurance engineering and testing. Alternatively, will accept a Master's degree in Computer Science, Computer Engineering, Electronics Engineering, or a related technical field, or its equivalent; plus 3 years in any occupation/title providing experience in software quality assurance engineering and testing.

Must Have: Proven ability to analyze customer requirements and design effective test cases; Proven experience building complex SQL queries to validate direct mapping, default values and complex transformations; Proven experience using Informatica/Talend tools; Proven ability to ensure quick resolution of customer reported issue; Proven ability to write, review, and implement test plans and test cases (both manual and automated); Demonstrated experience taking ownership of product modules, QA effort estimations, and performing the required testing for all software modifications; Proven ability to document all Test artifacts including Test Cases and Test Plans in the Test Case Management System; Proven ability to perform stress test on large scale applications with tools like Jmeter or Load runner; Proven ability using standard UNIX utilities to do testing and debugging; Demonstrated experience with large, complex business applications and distributed systems troubleshooting, debugging, and analysis; Demonstrated experience in understanding the software development lifecycle, especially in Agile; Demonstrated experience with web services, REST, SOAP, XSLT, XSD, and XML; Demonstrated experience with UNIX, Linux, and Windows operating systems; Demonstrated experience with software build and release management processes, such as maintaining QA environments; Demonstrated experience with automation tools and scripting; Experience in strategizing, planning and executing regression tests and exposure to SDLC process; and Experience with validating the Inbuilt or commercial Reporting tools and ensuring that the scheduled reports are delivered through different delivery mechanisms. (Unless otherwise indicated, State Street is seeking the stated ability in the skills listed above with no specific number of years or amount of experience required. All experience can be gained concurrently.)

To apply to this position, you must click the "Apply" button on this page and complete the online application. An EOE.

#LI-DNI

Salary Range:
$130,021 - $190,000 Annual

The range quoted above applies to the role in the primary location specified. If the candidate would ultimately work outside of the primary location above, the applicable range could differ.