Test Data Management Consultant
San Francisco, CA

Job Description

The Test Data Management Consultant will focus on requirements gathering, design, development, implementation and support of Blue Shield of California's (BSC) Test Data Masking and test data generation needs. The individual will support automation framework and solutions for test data masking and subsetting using IBM Optim tool. The position will work closely with Applications Development, Project Managers, QA/Test, Database Administrators, Data Modelers and Data Quality teams to define requirements and develop data masking solutions. Additionally, support applications that have existing standard artifacts and processes.

* understand the current process in place and execution of standard masking techniques across the applications and projects


* demand planning and providing level of effort based on the available information


* develop and implement automation of the data masking processes


* 3 years of experience in IT industry specifically in Test Data Masking and test data creation based on the requirements; Healthcare industry background with understanding of HIPAA and Privacy acts is a plus


* 3 years of test data fabrication using standard data generation tools such as CA TDM, Informatica data generator etc


* 3 years of experience in using IBM Optim (version 11.3) Data Masking and Subsetting techniques; writing user defined functions in IBM Optim is a plus


* Strong verbal and written communication skills


* Ability to collaborate and work in teams


* 3 years of experience on RDBMS (Oracle); Experience in SQL Server and Netezza is a plus; Expertise in database backups is a plus


* 2 years of experience with UNIX/Linux/Windows and Flat file systems; Knowledge of capacity planning is a plus;


* 1 to 3 years of experience with Shell and Perl Scripting


* Ability to write queries/macros/scripts using tools like SQL, Excel, Shell, XML etc


* Technical knowledge regarding data models, data flow diagrams and database design development


* Good understanding of data masking, data generation, quality and integration techniques


* Proficient in MS Word, Excel, Vizio, Project Planning and PowerPoint

Education:


*
* Bachelor's degree and three years related experience and/or training; or equivalent combination of education and experience.
*