TOSCA Data Integrity (DI) Engineer / Architect

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

Remote

12 months contract

Candidate must experience

5+ Years with Tosca

2.5+ Years with Data Integrity (DI)

Tricentis Certifications is mandatory and Certifications should have completed before 2023 or earlier

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

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 Skills

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