Centraprise ยท 1 week ago
Informatica TDM Consultant (SQL, Data Masking & Compliance)
United States
Contract
Remote
Mid LevelCentraprise is seeking an Informatica TDM Consultant to work remotely on a 12+ month contract. The role involves writing advanced SQL queries, implementing data masking processes for compliance, and collaborating with cross-functional teams to ensure high-quality test data availability.
EmploymentRecruitingStaffing Agency
Hiring Manager
Rahul Pandit
Responsibilities
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
Utilize indexing, optimization techniques, and performance tuning to ensure efficient data operations
Should have experience in AWS cloud databases and technologies (Atena / S3/ parquet)
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
Have a healthcare domain knowledge
Python, PowerShell, or Shell scripting
Experience calling APIs (REST) for automation
Experience with job schedulers (Autosys, Control-M, etc.)
Git or similar version control
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 automation frameworks
Work closely with QA, Dev, DBAs, DevOps, and Environment Management teams to ensure availability of high-quality test data
Provide data insights that improve test coverage, reduce cycle time, and enhance defect detection
Participate in planning, design reviews, and defect triage sessions as a data SME
Qualification
Required
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
Utilize indexing, optimization techniques, and performance tuning to ensure efficient data operations
Should have experience in AWS cloud databases and technologies (Atena / S3/ parquet)
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
Have a healthcare domain knowledge
Python, PowerShell, or Shell scripting
Experience calling APIs (REST) for automation
Experience with job schedulers (Autosys, Control-M, etc.)
Git or similar version control
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 automation frameworks
Work closely with QA, Dev, DBAs, DevOps, and Environment Management teams to ensure availability of high-quality test data
Provide data insights that improve test coverage, reduce cycle time, and enhance defect detection
Participate in planning, design reviews, and defect triage sessions as a data SME
Company
Centraprise
Centraprise is an executive search and direct hire company.
Founded in 2010
501-1000 employees
H1B Sponsorship
Centraprise has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (34)
2024 (16)
2023 (49)
2022 (35)
2021 (42)
2020 (125)
Funding
Current Stage
Late StageLeadership Team
Praveen Mummaneni
Chief Executive Officer
Anand Bandarupally
Managing Partner - Developing Recruitment and Business Development
Company data provided by crunchbase