Quality Assurance, Officer
Who we are looking for
State Street is looking for an Officer level QA / Lead analyst to be a part of the agile development team in order to perform Alternate Investment Services platform. This is an opportunity to work within a very strong development team and help to create challenging new solutions in the back office space using cutting edge technology.
What you will be responsible for
As a QA / lead Analyst you will be responsible for the below duties (Officer)
What we value
These skills will help you succeed in this role
Education & Preferred Qualifications
Skill Set Required: ETL, SQL, Snowflake, Azure, Kubernetes, DBT, Oracle, SQL Server
Salary Range:
$70,000 - $107,500 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.
State Street is looking for an Officer level QA / Lead analyst to be a part of the agile development team in order to perform Alternate Investment Services platform. This is an opportunity to work within a very strong development team and help to create challenging new solutions in the back office space using cutting edge technology.
What you will be responsible for
As a QA / lead Analyst you will be responsible for the below duties (Officer)
- Work with the product owner to understand the business requirements for an Iteration story in Backlog refinement, pre-planning and planning Agile ceremonies
- Prepare test data, test scenario's and build test cases and expected results as per the logic defined in the iteration stories
- Once the story is received from developer execute all test cases and add all test cases to automation regression suite
- Demo completed stories to Development team and product owners
- Run regression suite at the end of iteration
- Prepare iseal sign-off and all release documents for BUAT & Production releases
- Participate in peer review meetings and validate your team members test scenario's
- Support BAUT & Production post deployment testing whenever required
- Perform functional, integration and regression testing
- Banking and financial domain knowledge(Capital Markets) is a plus
What we value
These skills will help you succeed in this role
- Strong ETL database SQL Testing experience is a must
- Experience working in Snowflake, Azure, Kubernetes, SQL Server, Oracle & Sybase is preferred
- Familiarity with various data formats (e.g., xml, json, csv, pipe delimited etc.) is preferred
- A great team player, experiences with agile methodology - Scrum/ Kanban etc. will be a strong plus
- Understanding complex data flow through various layers and validating different test scenario's between source db and target db is required
- Cloud experience (AWS, Azure, GCP etc.) is a plus
- Execute manual and automated test cases, document defects and test findings in XRAY/Jira & RTC
- Exceptionally Strong SQL writing skills for Database Testing to ensure data integrity, validating database consistency and verifying accurate transaction
- Validate Iteration stories and maintain regression in cucumber framework (SQL - 70%, Automation - 30%)
- Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
- Hands on with API testing and validating REST services is preferred
- Hands on experience in Azure/Snowflake deployment using Kubernetes is preferred
- Experience validating ODS Base/Business/Consumption view functional validation is required
- Good to have familiarity with data visualization tools (Tableau/Power BI)
- Provide Source to Target data validation for ETL, tables and feed files as per business requirements
- Excellent verbal and written communication skills required
Education & Preferred Qualifications
- B.S or M.S in computer science/Math or relevant fields
- 8 or more years work experience.
- Excellent communication skills in English (written/spoken)
- A great attitude, effective communication skills, and a strong sense of ownership
- Ability to work in an entrepreneurial, fast paced, and collaborative environment.
Skill Set Required: ETL, SQL, Snowflake, Azure, Kubernetes, DBT, Oracle, SQL Server
Salary Range:
$70,000 - $107,500 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.
Job ID R-734017
ABOUT COMPANY
London, United Kingdom
From technology and product innovation to corporate responsibility and community development, we're making our mark on the financial services industry. For more than two centuries, we've been helping our clients safeguard and steward the investments of millions of people - strengthening markets, building communities and creating opportunities for growth.
We owe that longevity to the commitment, expertise and creativity of our employees. Our continued success depends on our ability to attract and develop the best talent in the industry. That's why we're keenly focused on employee development, corporate citizenship and inclusion.
For us, success comes in the mark we make as an organization - for the industry, our clients, our communities and each other.
More jobs From State Street Corporation
State Street Corporation
Princeton, USA
State Street Corporation
Princeton, USA
State Street Corporation
Princeton, USA
State Street Corporation
New York, USA
State Street Corporation
New York, USA
State Street Corporation
Jersey City, USA
State Street Corporation
Clifton, USA
State Street Corporation
New York, USA
State Street Corporation
Clifton, USA
Boost your career
Find thousands of job opportunities by signing up to eFinancialCareers today.More Jobs Like This
