Job Title: TOSCA Data Integrity (DI) Engineer / ArchitectAtlanta, GA (Hybrid)
Position SummaryWe 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.
Key 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.
Primary Use CasesUse 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.
Required Skills- 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) (Preferred)
- Tricentis Tosca Data Integrity (DI) Certification (Preferred)
Preferred Skills- Healthcare claims / Claim-Line validation experience
- ETL or data migration testing experience
Must-Have SkillsTOSCA DI, Oracle, SQL Server, Advanced SQL, JSON Transformation, Data Comparison, Data Reconciliation, Large Dataset Validation 
