TOSCA Data Integrity (DI) Engineer / Architect : Remote

Tharu Technologies LLC is seeking an experienced TOSCA Data Integrity (DI) Engineer / Architect for a remote 12-month contract. The role focuses on designing and implementing automated data comparison and validation solutions for large-scale enterprise databases using Tricentis Tosca DI, Oracle, SQL Server, advanced SQL, and JSON transformation. The position is responsible for enterprise data reconciliation, comparison reporting, and performance optimization across complex, high-volume datasets.

Responsibilities:

• Develop automated data validation solutions using Tricentis Tosca DI
• Implement comparison logic across 92 tables (48 CMC + 44 AGP), including approximately 40 custom comparison rules
• Handle multiple comparison scenarios:
• Single claim-line comparisons
• Claim + Line-level comparisons for tables with multiple records per claim
• Foreign key-based comparisons for tables without Claim IDs
• Extract data from Oracle databases across multiple schemas and integrate lookup data from SQL Server stored procedures
• Transform JSON data into relational tables and compare it with existing tabular data
• Reuse and enhance existing SQL-based comparison queries to derive keys, joins, and matching logic
• Generate comparison reports showing table-level, field-level, claim-level, and claim-line level differences, including incremental summaries
• Optimize SQL queries and comparison execution for large datasets
• Extract data from 25+ Oracle tables before and after processing
• Compare pre-state and post-state data to identify differences
• Extract JSON data from DB1 and transform it into tables
• Extract relational data from DB2
• Compare transformed and relational data across all mapped tables

Requirements:

• 5+ Years with Tosca
• 2.5+ Years with Data Integrity (DI)
• Tricentis Certifications is mandatory and Certifications should have completed before 2023 or earlier
• Tricentis Tosca Data Integrity (DI)
• Oracle Database and SQL Server
• Advanced SQL (joins, stored procedures, data comparison logic, performance tuning)
• JSON transformation and mapping
• Data reconciliation, migration validation, and database testing
• Experience working with large datasets (million+ records)
• Strong analytical and problem-solving skills
• Tricentis Certifications is Required
• Tosca Automation Specialist Level 1 (AS1)
• Tosca Automation Specialist Level 2 (AS2)
• Tosca Test Automation Engineer Level 1 (TAE1)
• Tricentis Tosca Data Integrity (DI) Certification
• Healthcare claims / Claim-Line validation experience
• ETL or data migration testing experience