TOSCA Data Integrity (DI) Engineer / Architect

CirrusLabs

• $110K — $130K *
Alpharetta, GA 30022In-Person
Information Technology
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 5+ years of experience as a Data Integrity Engineer/Architect
  • Proficiency in Tricentis Tosca Data Integrity (DI)
  • Deep knowledge of Oracle Database and SQL Server
  • Advanced SQL skills including performance tuning and stored procedures
  • Experience handling large datasets (3M+ records)
  • Strong analytical abilities with a focus on data comparison logic
  • Tricentis Tosca certifications (AS1, AS2) required; preferred TAE1 and Tosca DI certification.

Responsibilities

  • Develop automated data validation solutions using Tricentis Tosca DI
  • Implement complex comparison logic across multiple database tables
  • Extract and integrate data from Oracle and SQL Server
  • Transform JSON data into relational formats for comparison
  • Reuse and enhance existing SQL comparison queries
  • Generate detailed comparison reports highlighting data discrepancies
  • Optimize SQL queries for efficient processing of large datasets.

Benefits

  • Opportunity to work in a hybrid environment
  • Involvement in high-impact projects with large datasets
  • Access to training and certification programs
  • Potential for professional growth within an enterprise setting
  • Collaborative team-oriented work environment
Full Job Description
Job Title: 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
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
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at CirrusLabs

More Information Technology Jobs

Find similar TOSCA Data Integrity (DI) Engineer / Architect jobs:

NationwideAlpharetta, GA