We are
CirrusLabs. Our vision is to become the world's most sought-after niche digital transformation company that helps customers realize value through innovation. Our mission is to co-create success with our customers, partners and community. Our goal is to enable employees to dream, grow and make things happen. We are committed to excellence. We are a dependable partner organization that delivers on commitments. We strive to maintain integrity with our employees and customers. Every action we take is driven by value. The core of who we are is through our well-knit teams and employees. You are the core of a values driven organization.
You have an entrepreneurial spirit. You enjoy working as a part of well-knit teams. You value the team over the individual. You welcome diversity at work and within the greater community. You aren't afraid to take risks. You appreciate a growth path with your leadership team that journeys how you can grow inside and outside of the organization. You thrive upon continuing education programs that your company sponsors to strengthen your skills and for you to become a thought leader ahead of the industry curve.
You are excited about creating change because your skills can help the greater good of every customer, industry and community. We are hiring a talented
to join our team. If you're excited to be part of a winning team, CirrusLabs (http://www.cirruslabs.io) is a great place to grow your career.
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