Test Data Management Architect

Job Title: Test Data Management
Location: 100 % Remote

Type: Long Term Contract

SQL & Database Work

Write advanced SQL queries, stored procedures, triggers, and scripts for test data creation, manipulation, and validation.

Perform complex data analysis, profiling, lineage tracing, and root cause investigation using SQL.

Manage and optimize data across Oracle, SQL Server, DB2, PostgreSQL, or other relational databases.

Apply indexing, optimization techniques, and performance tuning to ensure efficient data operations.

Experience with AWS cloud databases and technologies such as Athena, S3, and Parquet is required.

Data Masking & Compliance

Implement and monitor data masking, obfuscation, and anonymization processes to ensure compliance with HIPAA, PHI/PII security, and organizational policies.

Support automated TDM tools such as Informatica TDM.

Ensure secure provisioning of data to non-production environments.

Healthcare domain knowledge is required.

Scripting & Tools

Hands-on experience with Python, PowerShell, or Shell scripting.

Experience calling REST APIs for automation.

Familiarity with job schedulers such as Autosys, Control-M, etc.

Experience using Git or similar version control tools.

Automation & CI/CD Integration

Build automated TDM workflows using Python, Shell scripts, or Informatica workflows.

Integrate test data provisioning with CI/CD tools such as Jenkins, GitLab, Azure DevOps, or Bamboo.

Support API-based test data services for test automation frameworks.

Cross-Functional Collaboration

Work closely with QA, Development, DBAs, DevOps, and Environment Management teams to ensure timely availability of high-quality test data.

Provide data insights to improve test coverage, reduce cycle time, and enhance defect detection.

Participate in planning, design reviews, and defect triage sessions as a Test Data SME.