Automation Engineer in Midvale, UT at Consultnet Careers

Date Posted: 9/14/2023

Job Snapshot

  • Employee Type:
  • Location:
    Midvale, UT
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
  • Job ID:

Job Description

JOB TITLE: Automation Engineer



Must Have

  • 5-6 years SQL
  • • Agile experience (SAFe methodology preferred)
  • Experience writing scripts (Python and Shell Scripting)
  • Extract Testing
  • Integration Testing
  • R / R Studio Experience

Nice To Have

Interview Process: Phone Screen then virtual interview

Location: Local candidates preferred - open to remote candidates

Indicate interview availability at top of resumeManager Update:

1) Well versed in end to end Test automation spanning multiple systems / technologies.

2) Senior level Experience with R or Python. Experience using multiple python libraries including openpyxl, os, time, datetime, selenium, cx_oracle, unittest.

3) Documented senior level SQL experience

4) API and Batch Extract validation experience preferred

5) Banking experience preferred

QA Test AutomationEngineer Activities

  1. Responsible for Analysis, Design, Development, Implementation, and maintenance of automation framework in Python / R.
  2. Perform ETL solutioning and script creation.
  3. Provide inputs to Automation Test Plans for various test phases – System, System Integration, Production Readiness.
  4. Create and manage QA Automation test cases/ scripts design and QA test cases/ scripts execution backlog in Azure DevOps (ADO)
  5. Own and execute test cases/ scripts design and Execution stories to each iteration for owned interfaces.
  6. Work on test design, test suite creation, test execution, defect management, and coordinate testing effort
  7. Investigate and debug test failures, updating tests or reporting bugs as necessary.
  8. Attend (organize at times) workstream related meetings – Iteration Planning, Daily SCRUM meetings, iteration Retrospective, Requirement (stories) Walkthroughs and queries clarification meetings
  9. Attend Defect Triage meetings in the testing phase and dispose defects as per the defect triage process, explain defects as required
  10. Support End to End interface team to carry out integration testing by supplying test data, Identifying and setting run calendar needs.

Requirement Analysis related job duties are as follows

  1. Determine the Scope of testing by analyzing the BRD, ISZ, IO, IOF, TDD, TRD, & FSDs and supporting documents (requirement mapping)
  2. Report questions to Scrum team members to get answers to the clarifications on requirement documents
  3. Share domain knowledge to determine testing needs and effective use of testing methodologies and practices for early discovery of Requirement Defects.
  4. Responsible for performing Impact analysis on the Interfaces/ Touchpoint fields mapping documents for all fields and ensuring all derived fields, constant fields & default fields are properly captured for future execution needs
  5. Identify test data needs and run calendar needs during requirement/ impact analysis

Test Planning & Design related job duties are as follows

  1. Understand business requirements (BRD, ISZs) and develop detailed interface wise component test plan per interface as per Test strategy/Approach by detailing activities to be carried out during testing
  2. Perform Functional analysis, scope of work and test effort estimation for applicable test activities
  3. Analyze automation scope and tools compatible for testing based on requirement complexity
  4. Apply guidelines / risk-based test approach by assigning the priority to the Test scenarios / Test cases/ scripts in Rational
  5. Create Industry standard traceability matrix for requirement coverage and validation check points for maximum test coverage
  6. Plan for test innovations, re-usable components and maintain the value add log in shared repository
  7. Preparation of test artifacts- test scenarios matrix, test data requirement matrix, test cases/ scripts
  8. Peer review of test artifacts - component Test Plan, Test Scenario Matrix, test cases/ scripts
  9. Identify test data needs and logical day planning for core banking system and related interfaces for integration test
  10. Present business review of Test cases/ scripts with subject matter expert/business for approvals/ to apply recommended changes
  11. Create and review traceability matrix for each requirement in ADO
  12. Keep Test Artifacts up to date in ADO and SharePoint tool based on change requests
  13. Perform automation activities for Batch and Services touchpoints
  14. Develop SQL queries to validate extract data/ XML responses

Test Execution and reporting duties are as follows

  1. Create and identify test data in core banking system where extract is expected from core banking system
  2. Create/ mock upload file when upstream system is not connected to carry out system testing
  3. Use Soap UI/ ReadyAPI tool to do web services related testing
  4. Execute test cases/ scripts in Azure DevOps (ADO)
  5. Log Defects in Azure DevOps (ADO), resolve them with Development team and other project stake holders in defect triage and track them for closure
  6. Create change requests supporting documents for the changes/requirements identified during testing phase
  7. Log observations which ended up as defects for other teams (Data Migration, Product test, Reports team)
  8. Support System Integration, User Acceptance, Production readiness and Dress rehearsal
  9. Test Data preparation and End of Day/ month/ Qrtr/ Year run calendar planning for team after understanding the logical days need in core banking system and other interfacing systems in various test regions
  10. Support and review Test Reports
  11. Identify Regression suites for future regression testing.

Test closure and reporting duties

  1. Track the progress of test execution in ADO and ensure test executions are as per the defined and documented test plan
  2. Report test activities related risks/ issues based on the deviation from Test Plan
  3. Follow test exit criteria defined in the Test Plan and perform closure activities accordingly.


  • A Bachelor's Degree in Computer Science, Electrical Engineer, or Information Systems preferred
  • 5+ years of programming, test automation, or other directly related work experience.
  • A combination of education and experience may meet qualifications.
  • Extensive knowledge software testing methodologies, testing tools, platforms, related systems and technologies.
  • Proficient in SQL and relational databases
  • Extensive knowledge in Python or R
  • Extensive experience with REST and SOAP services
  • Good knowledge on interface & Integration testing
  • Must have strong analytical, organizational, problem resolution, customer service and communication skills, both verbal and written.
  • Ability to make sound decisions and recommendations.
  • Requires effective time management and work ethics.
  • Strong attention to detail.

Be a part of the ConsultNet difference. As a leading national provider of IT staffing and solutions, ConsultNet delivers exceptional services to startup, midmarket and Fortune 1000 companies across North America. Since 1996, we've partnered with clients to create rewarding opportunities for our consultants, successfully building teams that have surefire results.e a part of the ConsultNet difference. As a leading national provider of IT staffing and solutions, ConsultNet delivers exceptional services to startup, midmarket and Fortune 1000 companies across North America. Since 1996, we've partnered with clients to create rewarding opportunities for our consultants, successfully building teams that have surefire results.

In the past two years alone, we have placed more than 1,500 consultants in contract, contract-to-hire, or direct placement opportunities. We understand communication is key to finding the right job that matches your skills and career goals. For us, it's not just the work that we do; it's how we do the work. Our breadth of offerings extends to multiple IT positions in major markets throughout the country, see more at -