Tosca Engineer/Architect

Job Title: TOSCA Data Integrity (DI) Engineer / Architect Atlanta, GA (Hybrid) Position Summar yWe 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 Responsibilitie • sDevelop 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 Case sUse Case 1 – Pre/Post Compariso • nExtract data from 25+ Oracle tables before and after processing • .Compare pre-state and post-state data to identify differences .Use Case 2 – Cross-System Compariso • nExtract JSON data from DB1 and transform it into tables • .Extract relational data from DB2 • .Compare transformed and relational data across all mapped tables .Required Skill • sTricentis Tosca Data Integrity (DI • )Oracle Database and SQL Serve • rAdvanced SQL (joins, stored procedures, data comparison logic, performance tuning • )JSON transformation and mappin • gData reconciliation, migration validation, and database testin • gExperience working with large datasets (million+ records • )Strong analytical and problem-solving skill sTricentis 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 Skill • sHealthcare claims / Claim-Line validation experienc • eETL or data migration testing experienc eMust-Have Skill sTOSCA DI, Oracle, SQL Server, Advanced SQL, JSON Transformation, Data Comparison, Data Reconciliation, Large Dataset Validatio n