Test Data Manager

Position Title: Test Data Management
Location Rancho Cucamonga, CA
Contract: 12 Months

Job Description:
The Engineer III - Test Data Management is the lead position assisting the Manager, Technical Test Data & Environment in leading the enterprise-level test data Management (ensuring the protection of PHI data) on several Test environments. It consists of using procedures, data masking tools, and resources to manage multiple components like software, hardware, test data, and applications. This position works in collaboration with TEM Engineers to ensure Test Environments are ready with necessary test data for Test execution and Delivery teams on all IT projects. This is a senior position and trains and guides Engineer I/IIs in the Test Data management area.

• Analyze existing Test data in several environments and identify test data and security gaps.
• Develop and execute Test Data Management Strategy and plans based on the assessment
• Lead enterprise-level Test Data management across several applications and test environments.
• Provision On-demand, self-service test data.
• Perform in-flight data masking, also for unstructured data, while ensuring referential integrity
• Set test data based on user-defined criteria on various projects
• Synthesize test data based on production data.
• Integrate TDM into CI/CD pipelines with an open API.
• Set up integrated test data in multiple test environments of integrated applications.
• Use APIs to refresh to the latest data, rewind for cleanup, branch datasets, and version data alongside code.
• Research and implement automatic test data generation tools .
• Find then mask sensitive data value automatically.
• Resolve application team/business team queries related to obfuscated data for all non-prod databases.
• Deliver virtual data to environments for development, testing, integration, and UAT automatically.
• Store and version control virtual datasets efficiently. Bookmark data and pair with specific test cases.
• Create test data generation templates for QE Engineers to generate test data files in several formats (HL7/ CCDA/X12 etc.) based on various test scenarios
• Build complex data reconciliation scripts for volume data validation in ETL and Data integration testing processes
• Collaborate with Test Environment Management team, Application support team, Product vendors, internal database, and Data integration teams to support the Test Delivery on several projects in a timely manner.
• Train and guide Engineer I/IIs in the Test Data management.

Experience Qualifications
A minimum of eight (8) years of Information systems and Quality Engineering experiences. Minimum five (5) years of experience working in Test Data Management. Demonstrated ability in the creation of data quality standards and methodologies. Demonstrated ability in Design and developing test Data Management Strategies and plans. Experience in data masking and setting up test data in integrated test environments of multiple applications. Experience writing and executing complex SQL query commands. Experience in coordination with external vendor teams. Test Automation and CI/CD experience. Experience in Test Automation tools. Experience communicating with management on topics related to Test Data roadblocks and risks. Strong technical background. A demonstrated track record of organizing test data at various stages of test life cycle and on multiple integrated systems across multiple projects. Proven experience with Data Masking.

Thorough understanding of Test Data Management tools

• knowledge of TDM, data Obfuscation and Test Lifecycle
• knowledge of Agile, SDLC, and ITIL
• Understanding of Agile environment and DevOps
• Extensive familiarity with quality assurance processes and procedures, and the ability to devise methods to enforce data quality standards
• Should have an overall grasp of the work effort involved to set up Test data for end-to-end testing environments.
  Skills Requirement
• The ability to use Test Data Management tools
• Strong planning, organization, critical thinking, decision-making and communication (verbal and written) skills.
• Strong interpersonal skills
• Robust analytical skills for both existing processes and identifying areas of opportunity
• Excellent decision-making, problem-solving, team and time management skills
• Good interpersonal, communication and organizational skills

Abilities Requirement

• Ability to clearly articulate both problems and proposed solutions
• Ability to prioritize personal and team workloads to best meet organizational objectives
• Ability to work effectively on a high-performing team

Analytical and process skills

• Effective problem resolution
• Resiliency and Ability to adapt in a dynamic environment
• Present issues and challenges in senior management forums.
• Work with a team of professionals from various disciplines. 
• Express action-oriented and creative approaches to IT system issues and problems.
• Ability to lead, guide and train other resources
• Motivated by delivery and speed to outcome
• Ability to effectively prioritize and execute tasks in a high-pressure environment

Education: At least a bachelor’s degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or closely related field is required.