Engineer III - Test Data Management

What you can expect! 

Find joy in serving others with IEHP! We welcome you to join us in “healing and inspiring the human spirit” and to pivot from a “job” opportunity to an authentic experience!

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. In addition, collaboration with inter-departments to ensure member needs are met while simultaneously building strong peer relationships.

Key Responsibilities

1. Analyze existing Test data in several environments and identify test data and security gaps.
2. Develop and execute Test Data Management Strategy and plans based on the assessment.
3. Lead enterprise-level Test Data management across several applications and test environments.
4. Provision On-demand, self-service test data.
5. Perform in-flight data masking, also for unstructured data, while ensuring referential integrity.
6. Set test data based on user-defined criteria on various projects.
7. Synthesize test data based on production data.
8. Integrate TDM into CI/CD pipelines with an open API.
9. Set up integrated test data in multiple test environments of integrated applications.
10. Use APIs to refresh to the latest data, rewind for cleanup, branch datasets, and version data alongside code.
11. Research and implement automatic test data generation tools.
12. Find then mask sensitive data value automatically.
13. Resolve application team/business team queries related to obfuscated data for all non-prod databases.
14. Deliver virtual data to environments for development, testing, integration, and UAT automatically.
15. Store and version control virtual datasets efficiently. Bookmark data and pair with specific test cases.
16. 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
17. Build complex data reconciliation scripts for volume data validation in ETL and Data integration testing processes
18. 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.
19. Train and guide Engineer I/IIs in the Test Data management.

Commitment to Quality: The IEHP Team is committed to incorporate IEHP’s Quality Program goals including, but not limited to, HEDIS, CAHPS, and NCQA Accreditation.

Perks

IEHP is not only committed to healing and inspiring the human spirit of our Members, but we also aim to match our team members with the same energy by providing prime benefits and more.

• Competitive salary.
• Hybrid schedule.
• CalPERS retirement.
• State of the art fitness center on-site.
• Medical Insurance with Dental and Vision.
• Life, short-term, and long-term disability options
• Career advancement opportunities and professional development.
• Wellness programs that promote a healthy work-life balance.
• Flexible Spending Account – Health Care/Childcare
• CalPERS retirement
• 457(b) option with a contribution match
• Paid life insurance for employees
• Pet care insurance

Education & Experience

• Bachelor’s degree in Computer Science, Information Management or similar technical field from an accredited institution required.
• 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.

Key Qualifications

• Must have a valid California Driver's License.
• Knowledge Requirements:
• 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.
• Should have an overall grasp of the work effort involved to set up Test data for end-to-end testing environments.

Start your journey towards a thriving future with IEHP and apply TODAY!