Previous Job
Service Virtualization Expert
Ref No.: 18-15625
Location: San Francisco / El Dorado Hills, CA, California
Job Description
Reporting to the Lead Test Data Specialist, the Data Masking Consultant will focus on requirements gathering, design, development, implementation and support of Cross of California's (BSC) Test Data Masking 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. Support applications that have existing standard masking artifacts and processes.
· understand the current process in place and execution of standard masking techniques across the applications and projects
· gathering data masking and subsetting requirements from application SMEs and testing SMEs
· demand planning and providing level of effort based on the available information
· develop and implement automation of the data masking processes
This position requires following skills
· Strong verbal and written communication skills
· Ability to collaborate and work in teams
· 3 to 5 years of experience in IT industry specifically in Test Data Masking; Healthcare industry background with understanding of HIPAA and Privacy acts is a plus
· 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
· 3 years of experience on RDBMS (Oracle and SQL Server); Experience in SQL Server is a must; Expertise in cross platform/database 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, scrubbing, quality and integration techniques
· Proficient in MS Word, Excel, Vizio, Project Planning and PowerPoint