Data Masking Consultant

Duration 4 months, with possible extension. Required Skills Strong verbal and written communication skills Ability to collaborate and work in teams 3 to 5 years of experience in the IT industry, specifically in test data masking. Knowledge of the healthcare industry and HIPAA and privacy acts is a plus. 3 years of experience using IBM Optim (version 11.3) for data masking and subsetting techniques; experience writing user‑defined functions in IBM Optim is a plus. 3 years of experience with RDBMS (Oracle and SQL Server). SQL Server experience is required; cross‑platform/database expertise 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, and scripts using tools such as SQL, Excel, shell, XML, etc. Technical knowledge of data models, data‑flow diagrams and database design development. Good understanding of data masking, scrubbing, quality, and integration techniques. Proficiency in MS Word, Excel, Visio, project planning, and PowerPoint. Responsibilities Reporting to the Lead Test Data Specialist, the Data Masking Consultant will focus on requirements gathering, design, development, implementation, and support of Blue Shield of California’s test‑data masking needs. The consultant will support automation framework and solutions for test data masking and subsetting using IBM Optim. The role will work closely with application development, project managers, QA/Test, database administrators, data modelers, and data quality teams to define requirements and develop data masking solutions. The consultant will also support applications that have existing standard masking artifacts and processes. Understand the current process and execution of standard masking techniques across applications and projects. Gather data masking and subsetting requirements from application SMEs and testing SMEs. Plan demand and provide level‑of‑effort estimates based on available information. Develop and implement automation of data masking processes. All your information will be kept confidential according to EEO guidelines. #J-18808-Ljbffr