Environment and Test Data Management Lead

Capio Group is looking for an experienced Environment and Test Data Management Lead!

Full-time employee - Sacramento
Salary: $117,000 - $122,000

Capio Group is a California-based Information Technology Consulting firm serving the public sector since 2010. We assist the Government in delivering large, complex systems and solutions. Capio Group is a small, but quickly growing firm that mixes good ideas, with great people, to achieve extraordinary results for our clients. We offer the salary and benefits of the bigger companies, with the added bonus of a flexible workplace and a great work-life balance.

Scope of Work:

Capio Group is looking for an experienced Environment and Test Data Management Lead to provide QA/QC services to support teams for enterprise applications, covering end to end test planning, execution, automation, performance engineering, environment/test data coordination, and defect management. Activities will be conducted under client direction using approved tools (e.g., Azure DevOps/Jira/ALM/UFT/LoadRunner Enterprise), with automation on UFT (VBScript), Selenium, and/or Katalon integrated to CI/CD. The Environment and Test Data Management Lead shall provide per cycle test summary reports, coverage dashboards, and defect metrics (density, leakage, aging) to the client.

The Environment and Test Data Management Lead will be responsible for services including but not limited to:

• Coordination, provisioning, and management of non-production testing environments across the SDLC.
• Management of test data required to support testing activities across environments.
• Activities will include but not limited to: Environment configuration and provisioning, Environment availability monitoring, Environment scheduling and conflict resolution, Integration validation across systems, Environment incident management and recovery, Test data creation and provisioning, Data masking and anonymization, Data refresh and synchronization, Synthetic data generation, Compliance with security and privacy requirements, Support for data-driven testing
• Coordinate with infrastructure and development teams to provision and maintain non-production testing environments.
• Monitor testing environment availability and stability to ensure environments are ready for scheduled testing activities.
• Coordinate environment configuration updates and system deployments required for testing cycles.
• Manage environment access requests and ensure appropriate security controls are implemented for testing environments.
• Identify and resolve environment-related issues impacting testing activities.
• Maintain documentation of environment configurations and dependencies supporting testing activities.
• Identify test data requirements needed to support functional, integration, automation, and performance testing activities.
• Create, provision, and maintain test data required for testing activities across supported testing environments.
• Perform data masking and anonymization to ensure protection of sensitive information in testing environments. Validate no PII exposure via sampling and provide masking validation reports.
• Coordinate test data refresh cycles to ensure test environments contain relevant and usable data sets.
• Generate synthetic data or subsets of production data where necessary to support testing scenarios.
• Ensure test data management activities comply with the client security and privacy policies.
• Define UAT data requirements (scenarios, roles, test accounts), provision and mask datasets for UAT, seed or refresh data aligned to UAT windows, deliver a UAT data readiness checklist and obtain business sign‐off prior to UAT start.

Mandatory Experience:

1. Within the last ten (10) years, must have a minimum of seven (7) years of experience in electronic data processing systems study, design, and programming.
2. Within the last ten (10) years, at least four (4) years of experience in electronic data processing systems study, design, and programming must be in a lead Capacity.
3. Must possess a bachelor’s degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis. A copy of the degree must be provided upon request.
4. Within the last ten (10) years, must have a minimum of seven (7) years of experience supporting enterprise IT systems.
5. Within the last ten (10) years, must have a minimum of four (4) years of experience in a lead role, managing test environments and test data across SDLC phases.
6. Within the last ten (10) years, must have a minimum of four (4) years of experiencecoordinating environment provisioning and configuration.
7. Within the last ten (10) years, must have a minimum of four (4) years of experience implementing test data management strategies, including data subsetting and extraction, data masking and refresh cycles.
8. Within the last ten (10) years, must have a minimum of four (4) years of experience monitoring environment availability and stability, including defining and managing SLAs.
9. Within the last ten (10) years, must have a minimum of four (4) years of experience managing data dependencies across integrated systems.
10. Within the last ten (10) years, must have a minimum of four (4) years of experience managing environment incidents, including rollback and recovery.
11. Within the last ten (10) years, must have a minimum of four (4) years of experience working with databases and cloud platforms like AWS and/or Azure.
12. Within the last ten (10) years, must have a minimum of four (4) years of experience integrating environment provisioning and test data management into CI/CD pipelines, enabling automated and repeatable deployments across non-production environments.
13. Must be able to provide a client/user end reference contact information for each applicable project meeting the requirements upon request in the qualification form. In addition, you must be able to submit completed reference forms when requested. Each reference form must be signed by the referenced individual. The reference contact must be a representative of the company for which the project was developed and must have served in a management or supervisory role.

1. At least ten (10) years of experience supporting enterprise application environments.
2. Within the last ten (10) years, atleast two (2) years of experience supporting large scale enterprise benefit systems (eg: Unemployment Insurance or Disability Insurance) meeting defined large scale enterprise system criteria.
   “Large Scale Enterprise System” is defined as an application or integrated system landscape that meets all of the following:
   1. Supports at least 2,500 concurrent users during peak periods, or at least 500,000 registered users and
   2. Processes at least 500,000 transactions or claims per year, or equivalent record/transaction volume across batch and online channels and
   3. Includes a multi-tier architecture spanning at least three of: web/portal, API/services layer, batch processing, and/or mainframe integrations or modern cloud-native services.
3. Within the last ten (10) years, atleast four (4) years of experience with test data tools and platforms like AWS S3, AWS RDS, MS SQL, AWS EC2.
4. Within the last ten (10) years, atleast four (4) years of experience with Infrastructure as Code tools like Terraform, or ARM, or CloudFormation.
5. Within the last ten (10) years, atleast four (4) years of experience achieving ≥99% environment availability SLAs during testing cycles.
6. Possesses one or more of the below certifications: A copy of the certification must be provided upon request.
   -HashiCorp Terraform Associate
   -AWS Certified Solutions Architect Associate
7. Possession of a Master's degree in a Business Administration, IT or Engineering field. A copy of the degree must be provided upon request.