{"schemaVersion":"jobsearcher.job.v1","id":"1dd5f4de0ee1eef7a7e0801e","url":"https://jobsearcher.com/jobs/1dd5f4de0ee1eef7a7e0801e","canonicalUrl":"https://jobsearcher.com/jobs/1dd5f4de0ee1eef7a7e0801e","title":"TOSCA Data Integrity (DI) Engineer / Architect : Remote","description":"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 experienceMust-Have Skills TOSCA DI, Oracle, SQL Server, Advanced SQL, JSON Transformation, Data Comparison, Data Reconciliation, Large Dataset ValidationPlease share resumes at kvaddi@tharutechnologies.com or you can give me a call at 703-381-2924https://www.linkedin.com/in/kiran-vaddi/","company":"Tharu Technologies","rawCompany":"tharu technologies","isRemote":true,"isActive":false,"createdAt":"2026-08-13T12:11:14.750Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"17-2112.02","title":"Validation Engineers","slug":"validation-engineers"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"TOSCA Data Integrity (DI) Engineer / Architect : Remote","description":"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 experienceMust-Have Skills TOSCA DI, Oracle, SQL Server, Advanced SQL, JSON Transformation, Data Comparison, Data Reconciliation, Large Dataset ValidationPlease share resumes at kvaddi@tharutechnologies.com or you can give me a call at 703-381-2924https://www.linkedin.com/in/kiran-vaddi/","datePosted":"2026-08-13T12:11:14.750Z","dateModified":"2026-08-13T12:11:14.750Z","hiringOrganization":{"@type":"Organization","name":"Tharu Technologies","sameAs":"https://jobsearcher.com"},"jobLocationType":"TELECOMMUTE","applicantLocationRequirements":{"@type":"Country","name":"US"},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"1dd5f4de0ee1eef7a7e0801e"},"url":"https://jobsearcher.com/jobs/1dd5f4de0ee1eef7a7e0801e"}}