Environment and Test Data Management Lead

Capio Group•Sacramento, CA

3d•$117,000 - $122,000

About The Position

Capio Group is seeking an experienced Environment and Test Data Management Lead to provide quality assurance and quality control services for enterprise applications. The role supports end-to-end test planning, execution, automation, performance engineering, environment and test data coordination, and defect management. Work is conducted under client direction using approved tools such as Azure DevOps, Jira, ALM, UFT, and LoadRunner Enterprise. Automation may use UFT (VBScript), Selenium, and/or Katalon integrated with CI/CD. The Lead provides test-cycle summary reports, coverage dashboards, and defect metrics, including density, leakage, and aging. The role coordinates, provisions, and manages non-production testing environments and the test data needed across the software development lifecycle. Duties include environment configuration and provisioning, availability monitoring, scheduling and conflict resolution, cross-system integration validation, incident management and recovery, test data creation and provisioning, masking and anonymization, data refresh and synchronization, synthetic data generation, privacy and security compliance, and support for data-driven testing. The Lead works with infrastructure and development teams to maintain environments, coordinate configuration changes and deployments, manage access and security controls, resolve environment issues, and document configurations and dependencies. They identify test data needs for functional, integration, automation, and performance testing; create and maintain datasets; validate masking to prevent exposure of personally identifiable information; coordinate refresh cycles; and ensure compliance with client policies. For UAT, the Lead defines data requirements, provisions and masks datasets, seeds or refreshes data to align with UAT windows, prepares a data-readiness checklist, and obtains business sign-off before UAT begins. Capio Group is a California-based information technology consulting firm serving the public sector since 2010. The company describes itself as a small, rapidly growing firm offering a flexible workplace and work-life balance.

Requirements

Within the last 10 years, at least 7 years of experience in electronic data processing systems study, design, and programming.
Within the last 10 years, at least 4 years of experience in electronic data processing systems study, design, and programming in a lead capacity.
Bachelor’s degree in an IT-related or Engineering field; additional qualifying experience may substitute year-for-year. A copy of the degree must be provided upon request.
Within the last 10 years, at least 7 years of experience supporting enterprise IT systems.
Within the last 10 years, at least 4 years of experience in a lead role managing test environments and test data across SDLC phases.
Within the last 10 years, at least 4 years of experience coordinating environment provisioning and configuration.
Within the last 10 years, at least 4 years of experience implementing test data management strategies, including data subsetting and extraction, data masking, and refresh cycles.
Within the last 10 years, at least 4 years of experience monitoring environment availability and stability, including defining and managing SLAs.
Within the last 10 years, at least 4 years of experience managing data dependencies across integrated systems.
Within the last 10 years, at least 4 years of experience managing environment incidents, including rollback and recovery.
Within the last 10 years, at least 4 years of experience working with databases and cloud platforms such as AWS and/or Azure.
Within the last 10 years, at least 4 years of experience integrating environment provisioning and test data management into CI/CD pipelines to enable automated, repeatable deployments across non-production environments.
Must be able to provide client/user reference contact information for each applicable qualifying project upon request and submit completed reference forms when requested. References must be signed by a management- or supervisory-level representative of the company for which the project was developed.

Nice To Haves

At least 10 years of experience supporting enterprise application environments.
Within the last 10 years, at least 2 years of experience supporting large-scale enterprise benefit systems, such as Unemployment Insurance or Disability Insurance, meeting the stated large-scale enterprise system criteria.
Within the last 10 years, at least 4 years of experience with test data tools and platforms such as AWS S3, AWS RDS, MS SQL, and AWS EC2.
Within the last 10 years, at least 4 years of experience with Infrastructure as Code tools such as Terraform, ARM, or CloudFormation.
Within the last 10 years, at least 4 years of experience achieving environment availability SLAs of 99% or greater during testing cycles.
One or more of the following certifications: HashiCorp Terraform Associate or AWS Certified Solutions Architect Associate. A copy of the certification must be provided upon request.
Master’s degree in Business Administration, IT, or Engineering. A copy of the degree must be provided upon request.

Responsibilities

Provide QA/QC services for enterprise application support teams across test planning, execution, automation, performance engineering, environment and test data coordination, and defect management.
Use client-approved tools and provide per-cycle test summary reports, coverage dashboards, and defect metrics.
Coordinate, provision, and manage non-production testing environments across the SDLC.
Coordinate with infrastructure and development teams to provision and maintain testing environments.
Monitor environment availability and stability and coordinate configuration updates and deployments for testing cycles.
Schedule environments, resolve scheduling conflicts, manage access requests, and ensure appropriate security controls.
Validate integrations across systems and identify and resolve environment-related issues affecting testing.
Manage environment incidents, recovery, and documentation of configurations and dependencies.
Identify test data requirements for functional, integration, automation, and performance testing.
Create, provision, and maintain test data across supported testing environments.
Mask and anonymize data, sample and validate masking to prevent PII exposure, and provide masking validation reports.
Coordinate test data refresh and synchronization, generate synthetic data or production-data subsets as needed, and support data-driven testing.
Ensure test data management complies with client security and privacy policies.
Define UAT data requirements, provision and mask datasets, seed or refresh data for UAT windows, deliver a UAT data-readiness checklist, and obtain business sign-off before UAT starts.