Test Data Architect, AVP (State Street Bank and Trust Company; North Quincy, MA): Work within State Street's Test Data Management team to design, build, and test data management solutions. Specific duties of the position include: architecting the masking solution for production copy and Golden Data Set creation; architecting Solutions for the requirements put forth by testing teams and Enterprise Data Governance; working with teams to gather requirements and transform them into TDM requirements; working with State Street's TDM team to build solutions; estimating, planning, designing, and implementing across applications; implementing, masking, and profiling through the Portal and creation of an external tool, to address issues in the product; reviewing work products and deliverables; delivering one of the tracks; installing the Test Data Management tool, including setup, configuration, and maintenance of the tool; directing stake holder management and reporting; engaging with SQA teams for requirement gathering and defining the scope of Test Data Management across multimillion-dollar accounting and fund management system; profiling production data, creating data subsets, and masking rules for synthesizing test data using CA Data Maker; designing end-to-end data extraction and masking scripts in Javelin (based on .Net tool) for test data on demand jobs; guiding the QA team on CA Agile requirements designer tool for creating business flows and generating optimized Manual test cases and TAF automation scripts; utilizing experience in Test Data Management tools and processes; utilizing experience in Data warehouse ETL Development; working with RDBMS and Non-RDBMS databases with advanced SQL querying and PL/SQL Development; testing applications utilizing various testing processes; developing Dot Net applications; and designing and developing Oracle /DB2 databases.
Minimum requirements are: Bachelor's degree in Computer Science, Computer Information Systems, or a related field, or its equivalent; plus 5 years of experience implementing TDM.
Must have: demonstrated hands on experience with Test Data Management Tool - CA TDM; proven knowledge of test data management processes; demonstrated experience with data warehouse ETL Development; demonstrated experience working with RDBMS and Non-RDBMS databases including strong advanced SQL querying and PL/SQL Development; demonstrated experience in application testing and proven knowledge of testing processes; demonstrated experience in design and dev Oracle /DB2 databases; and proven ability to communicated professionally both written and orally. (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.)
A pply online at statestreet.com/careers . State Street Job ID: R-662868 . An EOE.