Tosca DI Architect

Hi,

Please check the job description as below and let me know you if you would be interested and available. Please let me know your available time for a quick call.

TOSCA Data Integrity (DI) Engineer / Architect

Atlanta, GA (Hybrid)

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.

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 Cases

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.

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

Preferred Skills

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

Must-Have Skills

TOSCA DI, Oracle, SQL Server, Advanced SQL, JSON Transformation, Data Comparison, Data Reconciliation, Large Dataset Validation

-------------------------------------------------------
Thanks & Regards.

Isaac Rajiv

Kutir Corporation

Ph: