Data Test Engineer

Socket.dev; Illinois; Hybrid; USD 75,000 - 158,000; Full time

Job summary

Socket.dev is hiring a Data Test Engineer to validate data quality, transformations, and migrations within a large SAP S/4HANA implementation for USTRANSCOM JTMS. You will build SQL tests, validate interfaces, and ensure data integrity across systems in a SAFe Agile environment.

The role requires an active Secret clearance, a BS in a related field, and at least 5 years of software testing experience, including 2 years of data testing for ERP-scale projects. Illinois location, full-time role.

Qualifications

• Requires Security Clearance: Active Secret
• Bachelor's degree or equivalent professional experience in a related field
• 5+ years software testing with at least 2 years data testing for large ERP/enterprise systems
• Hands-on data validation, ETL/ELT testing, source-to-target reconciliation, data-quality testing
• Strong SQL skills for querying and auditing data across databases
• Experience with SAFe Agile environments and SDLC practices
• Excellent problem solving, communication, and teamwork abilities

Responsibilities

• Review requirements, data mappings, and transformation rules to define test conditions and acceptance criteria
• Design, build, and maintain data test cases, SQL queries, and reconciliation checks
• Validate data accuracy, completeness, consistency, integrity, and referential relationships across source and target systems
• Test data extraction, cleansing, transformation, loading, and migration activities
• Validate interfaces and data exchanges among SAP S/4HANA, SAP Fiori, Mendix and external systems
• Document defects with reproducible steps, evidence, and expected vs. actual results
• Create data-test plans, test evidence, and traceability aligned to SAFe Agile
• Collaborate with data engineers, developers, and stakeholders to maximize test coverage
• Participate in sprint planning, stand-ups, and retrospectives with ongoing process improvements

Skills

SQL

Data validation

ETL/ELT testing

Data migration

Reconciliation

SAFe Agile

SDLC

Analytical thinking

Education

Bachelor's degree in CS/IT/Data Analytics/Engineering

Tools

SAP S/4HANA

ServiceNow CWM

Job description

Job Title: Data Test EngineerJob Category: EngineeringTime Type: Full timeMinimum Clearance Required to Start: SecretEmployee Type: RegularPercentage of Travel Required: Up to 10%Type of Travel: Local* * *

The Opportunity

Join our team supporting USTRANSCOM's Joint Transport Management System (JTMS), a mission-critical enterprise platform that modernizes transportation, logistics, and financial operations through SAP S/4HANA ERP integration. We're looking for an accomplished Data Tester to validate data quality, transformation, migration, interfaces, and reconciliation across this large-scale SAP implementation. Your expertise in database validation, SQL, source-to-target testing and enterprise data flows will be essential to ensuring JTMS data is accurate, complete, consistent, and reliable. In this role, you'll partner with developers, data engineers, business analysts, functional teams, and product owners within a SAFe Agile environment.

Responsibilities

• Requirements and Data Analysis: Review user stories, interface requirements, data mappings, transformation rules, business rules, and source-to-target specifications to identify data test conditions and acceptance criteria
• Data Test Development: Design, build, and maintain data test cases, SQL queries, reconciliation checks, test data sets, and expected results for SAP S/4HANA and other integrated applications
• Data Validation: Validate data accuracy, completeness, consistency, integrity, referential relationships, formats, transformations, and business-rule compliance across source and target systems
• Migration and Conversion Testing: Test data extraction, cleansing, transformation, loading, conversion, and reconciliation activities and verify migrated data against approved source-to-target rules
• Interface and Integration Testing: Validate inbound and outbound data exchanged among SAP S/4HANA, SAP Fiori, Mendix applications, interfaces, and external systems, including error handling and exception processing
• Defect Management: Document data defects with queries, evidence, expected/actual results, and reproducible conditions; track issues through resolution and retest
• Test Documentation: Create and maintain data test plans, test cases, test evidence, traceability, reconciliation results, and data-quality reports aligned with SAFe Agile practices
• Stakeholder Collaboration: Work closely with data engineers, developers, functional analysts, business stakeholders, and integration teams to resolve data issues and maximize test coverage
• Agile Participation: Actively engage in sprint planning, daily stand-ups, retrospectives, and other Agile ceremonies
• Continuous Improvement: Identify opportunities to improve data-testing methods, reusable SQL validation, automation, reporting, and data-quality controls

Qualifications

Required:

• Security Clearance: Active Secret clearance (required)
• Education: Bachelor's degree in Computer Science, Information Technology, Data Analytics, Engineering, or related field (or equivalent professional experience)
• Experience: Minimum 5 years in software testing with a minimum of 2 years dedicated data testing for large-scale enterprise or ERP systems
• Data Testing Expertise: Hands-on experience with data validation, ETL/ELT testing, source-to-target reconciliation, data migration/conversion testing, and data-quality testing
• SQL Skills: Strong SQL skills for querying, comparing, aggregating, reconciling, and troubleshooting data across relational databases
• Agile Methodology: Strong working knowledge of SAFe Framework, SDLC, and Agile development practices
• Core Competencies: Excellent analytical and problem-solving abilities, attention to detail, strong written and verbal communication skills, and ability to work independently and collaboratively

Desired

• Technical Skills: Experience with data profiling, ETL tools, APIs, flat files, XML/JSON, and data comparison or reconciliation utilities
• SAP / ERP Experience: Experience testing SAP S/4HANA or comparable ERP data, workflows, integrations, interfaces, or migration activities
• Test Management: Experience with ServiceNow CWM (Collaborative Work Management) or comparable

What You Can Expect

A culture of integrity.

At CACI, we place character and innovation at the center of everything we do. As a valued team member, you’ll be part of a high-performing group dedicated to our customer’s missions and driven by a higher purpose – to ensure the safety of our nation.

An environment of trust.

CACI values the unique contributions that every employee brings to our company and our customers - every day. You’ll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.

A focus on continuous growth.

Together, we will advance our nation’s most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground — in your career and in our legacy.

Pay Range

There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.

Since this position can be worked in more than one location, the range shown is the national average for the position.

The proposed salary range for this position is:

$75,200-$158,100

CACI is anEqualOpportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any otherprotectedcharacteristic.