Logo
CACI International Inc

Database Test Engineer

CACI International Inc, Ashburn, Virginia, United States, 22011

Save Job

The Opportunity

CACI is seeking a Database Test Engineer to join our team and support the Border Enforcement Applications for Government Leading-Edge Information Technology (IT) (BEAGLE) contract. You will apply your knowledge, skills and experience to building a truly modern application that is new development and cloud native. If you thrive in a culture of innovation and bring creative ideas to solve complex technical and procedural problems at the team and portfolio levels, then this opportunity is for you! Join this passionate team supporting best practices in agile software development for the Department of Homeland Security (DHS). You will support the men and women charged with safeguarding the American people and enhancing the nation’s safety and security. Responsibilities

Participate in Agile Scrum development methodology ceremonies (e.g., sprint planning, daily stand-ups, backlog refinement, defining tasks/tests, estimating LOE, testing, tracking work, retrospectives, demonstrations). Develop, maintain, and perform sprint-level testing activities (e.g., define scenarios, develop scripts/procedures) in Jira with Xray. Design, develop, and execute comprehensive test strategies to validate data quality, ETL processes, database migrations, and overall database functionality. Validate end-to-end data flows between separate database systems with various data synchronization methods. Develop and maintain testing plans and execute after a new build is promoted or ahead of production deployment. Collaborate with the Product Architect and/or Business Analyst to assess impacts of candidate changes on the smoke and/or regression test suites and plan accordingly. Develop and execute complex SQL queries (DML, DDL, DCL) to validate data accuracy, consistency, integrity, and adherence to business rules across multiple database environments. Perform full-scope static and dynamic testing of the system under test, including functional and non-functional testing types such as Integration/API, End-to-End, Smoke, Regression/Functional, and Usability. Document and track testing activity progress during a sprint, capturing execution artifacts to verify backlog acceptance criteria. Champion quality of software. Qualifications

Required: U.S. Citizen with the ability to pass CBP background investigation (3-year felony check; 1-year checks for illegal drug use and misconduct such as theft or fraud). Team player able to work in a collaborative environment. Minimum of 5 years of professional experience in database testing, data quality assurance, or a related role. Advanced proficiency in writing complex SQL queries across multiple RDBMS (e.g., SQL Server, Oracle, MySQL, PostgreSQL). Strong understanding of relational database concepts (ACID, normalization, indexing, referential integrity). Experience with message streaming solutions (e.g., Kafka, AWS MSK, RabbitMQ, Google Pub/Sub, Confluent Kafka) from a testing perspective. SDLC/STLC principles and various testing types (functional, regression, performance, integration). Experience with test management tools (e.g., Jira, Azure DevOps, ALM) and version control (Git). Strong analytical, problem-solving, and debugging skills with attention to detail. Excellent verbal and written communication skills for technical and non-technical audiences. Experience estimating manual test script efforts and test script development/maintenance. Ability to interact with Product Owners, Business Analysts, Scrum Masters, Product Architects, Developers, and Technical Writers, guiding testing methods to meet project needs. Familiarity with CI environments and tools such as Jenkins, Git, GitLab, AWS, Postman. Experience in a high-performing, collaborative Scrum team and applying Agile practices to incremental software development. Strong work ethic, self-starter attitude, and understanding of the software development life cycle. Desired: Experience with NoSQL databases (e.g., MongoDB, Cassandra, DynamoDB). Familiarity with cloud database services (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL). Hands-on experience with ETL tools (e.g., SSIS, Informatica, Talend, Apache NiFi, or similar). Experience with data warehousing, data lakes, and BI concepts. Proficiency in scripting languages (e.g., Python, PowerShell, Bash, Java) for test automation. Experience with database-focused performance testing tools (e.g., JMeter, LoadRunner, SQL Profiler). Knowledge of CI/CD pipelines and DevOps practices for database deployments. What You Can Expect

A culture of integrity. At CACI, character and innovation are at the center of what we do. 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 of every employee and offers flexible time off and robust learning resources to support your ambitions. A focus on continuous growth. We will advance our nation’s missions and opportunities to grow in your career and our legacy. Your potential is limitless. So is ours. Learn more about CACI here. Pay Range

The proposed salary range for this position is $86,600 - $181,800. Salaries are influenced by location, experience, skills, and other factors. Our benefits include healthcare, wellness, retirement, education, and time off. Equal Opportunity Employer . CACI is an Equal Opportunity 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 other protected characteristic.

#J-18808-Ljbffr