Tosca Data Integrity Di Engineer Architect

Job Title: TOSCA Data Integrity (DI) Engineer / Architect
Position Summary:

We are seeking an experienced TOSCA Data Integrity (DI) Engineer / Architect to design and implement automated data comparison and validation solutions for large-scale enterprise databases (3M+ records). The role involves Oracle and SQL Server data extraction, JSON transformation, complex SQL-based comparison logic, and enterprise data reconciliation using Tricentis Tosca DI.

• 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.

• Use Case 1 - Pre/Post Comparison: Extract data from 25+ Oracle tables before and after processing. Compare pre-state and post-state data to identify differences.
• Use Case 2 - Cross-System Comparison: Extract JSON data from DB1 and transform it into tables. Extract relational data from DB2. Compare transformed and relational data across all mapped tables.

• 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), Level 2 (AS2)

• Healthcare claims / Claim-Line validation experience
• ETL or data migration testing experience

For applications and inquiries,