TOSCA Data Integrity (DI) Engineer / Architect

CirrusLabs

• $110K — $130K *
Alpharetta, GA 30022Hybrid
Healthcare
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 5+ years of experience in data integrity engineering or data validation roles.
  • Proficiency in Tricentis Tosca Data Integrity (DI) tools.
  • Strong knowledge of Oracle Database and SQL Server.
  • Expertise in advanced SQL, including performance tuning and complex queries.
  • Hands-on experience with JSON data transformation and mapping.
  • Background in data reconciliation and database testing, especially with large datasets.
  • Tricentis certification in Tosca DI and Automation Specialist levels 1 and 2 required.

Responsibilities

  • Develop automated validation solutions using Tricentis Tosca DI.
  • Implement complex comparison logic across 92 tables with custom rules.
  • Handle multiple comparison scenarios, including single and multi-record comparisons.
  • Extract data from multiple Oracle schemas and integrate with SQL Server.
  • Transform JSON data into comparative relational tables.
  • Enhance existing SQL comparison queries for key and matching logic.
  • Generate detailed comparison reports reflecting differences at various levels.

Benefits

  • Hybrid work schedule with flexible remote options.
  • Professional development opportunities with access to advanced training.
  • Collaboration with a highly skilled team in a supportive environment.
  • Access to the latest tools and technologies in data integrity.
  • Involvement in large-scale, impactful projects involving enterprise databases.
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 Healthcare Jobs

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

NationwideAlpharetta, GA