CACI International Sr. Data Test Engineer in Arlington, Virginia
Serves as a Mid-Sr Data Test Engineer for the Integrated Personnel and Pay System-Army (IPPS-A). Works under minimal supervision, performs tasks related to data, regression, interface, and end-to-end testing of IPSS-A ERP using available test tools. Writes and executes interface test cases to measure data accuracy and correctness using available ETL tools. Completes root cause analyses using SQL and works with flat-files, database dumps and XML/XSD. Works with business analysts to understand the system design and works with developers to resolve defects. Works with the Senior Test Lead to ensure test processes and procedures are followed.
What you'll get to do:
Develops and executes interface test scenarios and test scripts for complex business rules using available ETL tools.
Reviews interface design documents, analyzes requirements and works with flat files, database dumps, XML/XSD to achieve expected results.
Perform root cause analysis, database validation, and data defect identification using SQL.
Create/Identify test data to validate functional and technical requirements.
Traces requirements to test cases to ensure coverage for full system integration test.
Ensures requirements are met through data testing activities.
Designs, develops and executes reusable test cases and procedures based on requirements relevant to data test planning and creation using HP ALM.
Collects, tracks and reports test metrics and briefs leadership on test status.
Coordinates the resolution of problems inhibiting test progress.
Reviews customer requirements and specifications to ensure that tests will confirm that these are satisfied
You'll bring these qualifications:
Bachelor's degree in Technology or related field with at least 5 years of software testing experience for the federal government.
Active Secret clearance.
Ability to write complex SQL queries for database validation and data defect identification.
Experience with the ETL process, interface/conversion, and backend testing of Oracle databases using SQL and Unix scripting.
Strong understanding of relational databases, and software testing techniques and methods.
Knowledge of Quality Assurance Methodologies and the SDLC.
Ability to communicate in a clear and concise manner.
Qualifications that are nice to have:
Knowledge of the Agile development process; experience with testing in an agile development environment is strongly desired.
2 years of PeopleSoft HCM experience with experience across the Human Resource modules; including Core HR, Self Service, Global Payroll, Benefits, Time and Labor, Customer Relationship Management (CRM), and Enterprise Learning Management (ELM).
Security + certification
Demonstrated experience working with continuous integration environments.
Expertise with HP Quality Center and the HP Application Life-Cycle Management Suite (Quality Center, Unified Functional Testing, Performance), and defect tracking tools.
Experience with Oracle,
Ab Initio and SQL Knowledge of PeopleSoft versions 9.1/9.2
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 missions and government transformation for Intelligence, Defense, and Federal Civilian customers. CACI is proud to provide dynamic careers for employees worldwide. CACI is an Equal Opportunity Employer - Females/Minorities/Protected Veterans/Individuals with Disabilities.