Job Description :
Position : Data Masking with IBM Optim Expert
Location : El Dorado Hills, CA
Duration : 6+ months Contract
Job Description:
Reporting to the Lead Test Data Specialist, the Data Masking Consultant will focus on requirements gathering, design, development, implementation and support of Client Test Data Masking needs.
The individual will support automation framework and solutions for test data masking and sub setting 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