Data Masking Consultant

PT Systems; California (MO); On-site; USD 70,000 - 90,000; Full time

Job summary

PT Systems is seeking a Data Masking Consultant in California to focus on requirements gathering, design, and automation of data masking using IBM Optim. The role requires strong communication skills and collaboration with application development teams.

Ideal candidates will have 3-5 years of experience in the IT industry, specifically in test data masking, and proficiency in SQL and RDBMS. Join us to support Blue Shield of California’s test-data masking needs.

Qualifications

• 3-5 years of experience in the IT industry, specifically in test data masking.
• Experience using IBM Optim (version 11.3) for data masking.
• 3 years of experience with RDBMS (Oracle and SQL Server).

Responsibilities

• Focus on requirements gathering and design for test data masking needs.
• Develop and implement automation of data masking processes.
• Work closely with application development and project managers.

Skills

Strong verbal and written communication skills

Collaboration and teamwork

3-5 years in IT industry (test data masking)

3 years with IBM Optim (version 11.3)

3 years experience with RDBMS (Oracle and SQL Server)

2 years experience with UNIX/Linux/Windows

1-3 years of shell and Perl scripting

Ability to write queries, macros, and scripts

Technical knowledge of data models and database design

Proficiency in MS Office tools

Job description

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.