Database Automation Engineer

Work with the brightest minds at one of the largest financial institutions in the world. This is long-term contract opportunity that includes a competitive benefit package!

Our client has been around for over 150 years and is continuously innovating in today's digital age. If you want to work for a company that is not only a household name, but also truly cares about satisfying customers' financial needs and helping people succeed financially, apply today.

Position: Lead Technology Business Services Consultant
Location: Charlotte, NC, 28202
Term: 6 months

Day-to-Day Responsibilities:

• Build, maintain and execute a Data Automation Framework using Ruby, Cucumber and Awetest Framework.
• Performs functional, Database (ETL), Web service, Regression testing during SDLC project lifecycle.
• Strong analytical skills with high attention to detail and accuracy.
• Create, parametrize & integrate complex SQL statements into the existing framework.
• Logs, tracks, and verifies resolution of software and specification defects.
• Creates, prepares, and implements systems quality assurance reviews for numerous applications using data scenarios/tests to validate.
• Responsible for primary development of system testing strategies leveraging data.
• Lead or participate in managing and supporting the delivery of technology products and services of high profile business unit clients and contribute to large scale solutions planning related to Technology Business Services.
• Ensure service quality and cost effectiveness of solutions.
• Review customer information with the technology team and implement technical initiatives for highly complex projects impacting multiple lines of business or across the enterprise.
• Understand and ensure compliance and risk management requirements for supported area and work with other stakeholders to implement key risk initiatives.
• Make decisions in complex and multifaceted situations requiring solid understanding of managing multiple medium technology development efforts that influence and lead broader work team and drive new initiatives.
• Collaborate and consult with the technology team and more experienced management within Technology Business Services functional area to resolve Information Technology issues and provide customers with best possible solutions.
• Provide guidance on leveraging new technology.

Is this a good fit? (Requirements):

• Required Qualifications:
  • 5-7 years of advanced database testing skills.
  • 3+ years of Awetest Automation Framework development experience using Ruby & Cucumber.
  • Experience with Awetest setup, administration – including Awetest-Jira integration, Jenkins and Autosys integration with Awetest, Invoking Awetest jobs via API.
  • Should have ability to perform ETL testing.
  • Experience in testing web services and web service testing using Awetest Services Module.
  • Ability to write complex SQL queries and test batch SQL jobs.
  • Automation /coding skills.
  • 5+ years of the end-to-end software development life cycle (SDLC) with emphasis on the test cycle including effort sizing, test approach design, performing complex data analysis, debugging SQL script, results reporting and documentation.
  • Extensive experience in doing integration testing across large applications to ensure data integrity across multiple systems.
  • Excellent written and oral communication skills with ability to clearly communicate ideas and results to diverse business and technical audiences.
• Desired Qualifications:
  • Acquired and prior working knowledge on the IHub application with a deep understanding of automated conformance testing using Awetest Data and Services framework.
  • Awetest deployment including Awetest-Shamisen setup and configuration is a huge plus.
  • Prior knowledge of Awetest Web module and framework.
  • Experience performing moderately complex to complex DB testing, test data conditioning, regression testing and testing validation.
  • 5+ years working on multiple projects simultaneously. Analytical skills, ability to 'think outside the box' and move concepts to implementation.
  • Proven experience with automation, regression, and performance testing.
  • Strong analytical skills with high attention to detail and accuracy.
  • Advanced MS Office experience.
  • Experience in testing web services and web service testing tools like Postman, SoapUI.
• 5+ years of Information Technology in support of Business Services experience, or equivalent demonstrated through one or a combination of the following work experience, training, military experience, or education.