Data Test Engineer
Scott Air Force Base, IL - USA
Job Summary
The Opportunity:
Join our team supporting USTRANSCOMs Joint Transportation Management System (JTMS) a mission-critical enterprise platform that modernizes transportation logistics and financial operations through SAP S/4HANA ERP integration. Were 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 this role youll 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: Bachelors 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 youll be part of a high-performing group dedicated to our customers 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. Youll 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 nations 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:
$75200-$158100CACI 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.
Required Experience:
IC
About Company
CACI employs a diverse range of talent to create an environment that fuels innovation and fosters continuous improvement and success. At CACI, you will have the opportunity to make an immediate impact by providing information solutions and services in support of national security miss ... View more