Quality Assurance Analyst/Tester, Sr Job at Abacus Service Corporation, Hartford, CT

Y05DQWRXSUdSNGE3ZG1FeDVXa0tuUFgybXc9PQ==
  • Abacus Service Corporation
  • Hartford, CT

Job Description

Summary


Requisition ID
61936

Requisition Name
Quality Assurance Analyst/Tester, Sr

Folder
DCF (Piggy Back)

Customer
CT DCF

Quantity Requested
1

Description

STATE OF CONNECTICUT



DEPARTMENT OF CHILDREN AND FAMILIES



STATEMENT OF WORK FOR CCWIS PROGRAM



QA Automation Engineer Lead

(x) New Task () Renewal ( ) Fixed Price (X) On Site Support ( X) Remote Support

1. REQUIRED AGENCY :


Department of Children and Families
DCF IS Division
505 Hudson Street
Hartford, CT 06106



2. PROJECT/SYSTEM/PROGRAM OVERVIEW


The Department of Children and Families depends on the core mission-critical Federally-reimbursed SACWIS (Statewide Automated Child Welfare Information System). The application is used by a large majority of roughly 3,400 employees including over 1,100 front line social workers and case managers, the application has been enhanced and modified continually to meet data capture and process functionality requirements driven by good child welfare case practice as well as State and Federal legislation and statute. Additionally, SACWIS continues to experience change chiefly in compliance with the 1991 Juan F. Consent Decree as well as the agency's ongoing goal of improving the safety, permanency, and well-being of children in care. The agency is also undergoing an effort to replace its SACWIS system with a new CCWIS system working in collaboration with our federal and state partners.


DCF Information Systems provides technology expertise and services as well as an information systems infrastructure to the agency and its roughly 3,400 employees. DCF Information Systems strives to improve continually improving technology services that are cost-effective and of the highest effectiveness and quality. DCF Information Systems is currently in the process of replacing its current SACWIS and engaged in a large three year project to redefine, redesign and modernize its systems and practices.



3. SCOPE OF WORK


The agency needs the service of a QA Automation Engineer to work on SACWIS and CCWIS. The candidate will serve in the capacity of a QA Automation Engineer, will follow a well-defined vision of how IT and the business aligns and make sure that everyone is following the same principles, methodologies, and support activities per the direction of agency management. The specific focus of this candidate will be the part of the team that will work on ETL's and data conversion as well to participate in the SDLC process of the new CCWIS system and work with the System Integrator to ensure the transfer of knowledge and ongoing maintenance of the solution. Specifically, the candidate will be responsible to work alongside our QA Lead to assist with testing the ETL and Data conversions to ensure that conversions requirements are met whilst also ensuring that service qualities (Performance, scalability, extensibility, maintainability, security, interoperability) for now and for the future are achievable.

Specific Services Required:
In the role of the Automation QA Engineer, the following services are required:
  • Reviews all system requirements, test scripts, test scenarios to create appropriate testing workflow. Ensures that this set of high-level requirements is consistent, complete, correct, and operationally defined.
  • Reviews software components and collaborates with Development group, Product Owners, System Teams, and Operations to ensure best overall testing strategies, best practices and techniques for automated testing.
  • Interfaces with the design and implementation teams, so that any problems arising during QA can be resolved in accordance with the fundamental design concepts, and user needs and constraints.
  • ssist in all testing processes involving the migration and integration of new and legacy technologies.
  • Follows the testing standards and strategies and uses them correctly.
  • Interface with the user(s) and sponsor(s) and all other stakeholders to determine their (evolving) needs.
  • Follows the set standards for the automated testing software, policies, and execution.
  • Generates products such as automated functional tests, regression tests, load tests, and test scenario around ETL and data conversion.
  • Responsible for creating automated test case scenarios for Agile Delivery Team to meet Acceptance Criteri
•Reviews and understands the design and development of the database architecture including relational data structures, data marts, data dictionaries and logical and physical data models.
•Develop and maintain efficient, well documented, test scripts custom to the integration of data and processes from the legacy systems to the new applications and technologies.
•Design, develop and implement ETL testing scripts that are consistent with the solutions for data ingestion, cleansing, business rules execution and Data Distribution.
•Perform tests and validate data flows and ETL processes according to business requirements.
•bility to create complex SQL joins to test data migration requirements.
•Expertise in querying and testing databases such as SQL Server, DB2 and Oracle.
•Designing test scripts that validate the determined data conversion strategy from legacy to new platforms.
•Involvement in all stages like Requirements gathering, Data mapping, Data extraction, Data loading, Data testing, documentation, performance optimization and maintenance.
  • Excellent communication, presentation, collaboration, and interpersonal skills.
  • Demonstrated ability to deliver business and technical value.
  • Must be very organized, pro-active and self-directed. Must be able to perform with minimal supervision.
  • Must have very strong abstract thinking and problem-solving skills.
  • Must have very good verbal and written communication skills.

REQUIRED SKILLS AND EXPERIENCE


In addition, the agency requires:


n experience professional with demonstrating the following knowledge and skills:
•7+ years Experience with Automated Testing Frameworks, Test Strategies and Test Beds.
•7+ years Experience with Client QC, UFT, Stress Stimulus, Azure Dev Ops
•7+ years Experience Microsoft SharePoint
•7+ years Experience with Agile Methodologies
•7+ years Experience with Software Testing Methodologies
•Knowledge of Testing Tools, Testing Frameworks, Continuous Integration Methodologies
•Knowledge of Web Application Testing, Distributed System Testing, Performance Testing, Regression Testing, Database Testing, Mobile Testing, Security Testing, Accessibility Testing, Web Service Testing.
•Knowledge of Data Modeling and Database Design
  • Thorough understanding of standard QA best practices in an Agile environment including authoring test plans and test cases, executing tests and tracking issues to closure
  • Experience in Test Driven Development and testing tools and techniques.
  • Testing experience with Web Services (REST, SOAP, WCF) and tools such as SOAPUI and SOAPSonar.

4. ADMINISTRATIVE CONSIDERATIONS


Candidate must be a U.S. Citizen or Permanent Resident



Work Schedule: Full-Time 40hrs - Monday - Friday, 8 AM - 5 PM

State Resources and Oversight: DCF IS Management

Security/Privacy Considerations: Comply with Vendor Qualification, DCF Child Protection Background Check, FBI Fingerprint Background Check and DCF Non-disclosure Agreement

Estimated Duration
01/15/2024 - 01/11/2026

Schedule

Days

Monday Yes Tuesday Yes Wednesday Yes Thursday Yes Friday Yes Saturday No Sunday No

Hours/Day
8

Time Zone


EST

Shifts Start Time End Time Description
Active

Shift 1


8:00 AM


5:00 PM

Yes

Location
Position Location Hybrid
Address
505 Hudson St Hartford, Connecticut 06106





Qualifications Type Category Qualification Description Competency Required Skills Database Data Warehousing dvanced (7-9 Years) No Skills Database Microsoft Access dvanced (7-9 Years) No Skills Database Microsoft SQL Server dvanced (7-9 Years) No

Job Tags

Permanent employment, Full time, Remote job, Shift work, Weekend work, Sunday, Saturday, Monday to Friday,

Similar Jobs

Synerfac

Civil CAD Designer Job at Synerfac

We are seeking a Civil Designer for a position in Pittsburgh, PA and surrounding areas Seeking an Autocad Civil 3D designer for a civil...  ...have good communication skills with a focus on adherence to CAD standards and can complete design tasks at a high level with minimal... 

Extreme Dodge Chrysler Jeep Ram

Salesperson / Finance Manager at Extreme Dodge Chrysler Jeep Ram Job at Extreme Dodge Chrysler Jeep Ram

 ...sales environment that rewards your hard work and success, creating incredible income opportunities. Why Choose Extreme Dodge Chrysler Jeep Ram?- Unparalleled compensation: Enjoy an earning potential that surpasses traditional salaried positions in the sales... 

Providence

RN - MEDSURG ADULTS/PEDS Job at Providence

 ...You will thrive in our culture of patient-focused, whole-person care built on understanding, commitment, and mutual respect. Your voice...  ...world-class health with human connection and make a difference every day through your extraordinary care. Relocation Assistance... 

Electrical Automation Services Inc

CPG Operations Manager Job at Electrical Automation Services Inc

Job Description Job Description About the Job Manages overall manufacturing activities and processes of the production and packing line(s) of the Plant to produce the highest quality product at the lowest possible cost. Manages production and packaging processes...

FIS

Intern, Financial Analyst, Summer FIS University Program 2024 Job at FIS

 ...passionate, and above all fun. Join the 2024 FIS University Summer Internship Program! As a 2024 FIS University Program Summer Intern,...  ...and conclude on August 9, 2024. About The Team The FIS Finance team drives key strategic decisions by providing historical &...