Aetna Automation / ETL QA Test Design Engineer in Chicago, Illinois

Req ID: 52713BR


The QA Test Design Engineer is responsible for the technical system validation and verification of functionality for reporting/analytics and ETL applications. This position performs functional and automated testing of software changes to ensure quality and stability before changes are deployed to production systems.

Fundamental Components:

Responsible for the overall test architecture, strategy, standards, and procedures for assigned area(s).

Acts as technical or business contributor, to support the test design process and deliverables, using Requirement, architecture, data modeling, design, and Use Case artifacts as input.

Leads or acts as technical contributor to support translation of architectural and design changes to impacted areas.

Leads or acts as a business contributor to support the translation of business requirements to impacted areas.

Demonstrates understanding of the environment and infrastructure configuration in developing or reviewing the test design.

Interprets and provides issues or concerns with design or infrastructure changes to applications and the downstream impacts.

Provides risk and opportunity assessments on a project/program level, including end to end impact of changes.

Identifies automation and process improvement opportunities and implements on future project/release testing.

Identifies the need, and evaluates and implements tools that support the testing process.

Recommends and implements new testing practices and procedures that are consistent with industry standards and practices.

Provides technical consulting and leadership in identifying and implementing test tools that assist in meeting strategic objectives.

Keeps abreast of technical changes and advancements in the testing field.

Coordinates/Manages the testing and implementation within a given area or across multiple areas.

Performs complex testing, according to detailed plans to ensure high-quality systems.

Reviews project estimates for knowledgeable areas and provide oversight for program level efforts utilizing the QA estimate template and maintains those estimates using the proper QA tools.

Responsible for defining, developing, maintaining, executing and validating test architecture and scripts.

Responsible for escalating project and release items (issues, concerns, defects) to the Manager and for communicating own issues, developing options to mitigate negative impacts to release schedule; assists the manager and team in understanding impacts of issues in other areas or own area of testing.

Proactively escalates issues, problems, status to Manager / PM and actively participates in meetings to address, research options and ensure success and timely resolution.


8+ years software project life cycle experience with concentration in quality assurance.

8+ years experience in technology support or application program development.

Experience within the testing life cycle.

Experience coordinating/managing the application testing process.

Extensive experience on testing the reporting applications/analytics and ETL applications.

8+ years hands on experience on QA Automation tools (Selenium, Test Complete and Rational tools) and coding experience in Java/VB Script

Proficient in automation framework and scripts. Create proof of concepts on advanced technologies and tools (manual and automated tools)

8+ years hands on experience on JIRA

8+ years hands on experience on test management tools (Rational Quality Manager, Xray, HP Quality Center)

5+ years hands on experience on ETL testing

Extensively created and executed SQL queries in Oracle or SQL server in order to view successful transactions of data and to validate/compare data at the back end

5+ years experience on agile methodology

Experience working in an environment with a matrixed staff with ability to leverage non-directs to complete tasks.

Requires significant knowledge across multiple areas and applications, has a significant business knowledge and impact to numerous applications.


The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.

Certification of Quality Assurance and Testing is preferred.


  • This is an office based position in Chicago, IL with the HDMS.

  • Health Data & Management Solutions, Inc. (HDMS), a subsidiary of Aetna, is a software development company on the cutting edge of health IT data solutions. Offering data warehouse, management and analysis tools for the healthcare industry, HDMS strives to improve and enhance its product suite for health plans, employers and providers through constant innovation. HDMS' web-based products and services provide flexible, high-value reporting tools that empower users to maximize the value of their health care data and support benefit decisions.

    Aetna is about more than just doing a job. This is our opportunity to re-shape healthcare for America and across the globe. We are developing solutions to improve the quality and affordability of healthcare. What we do will benefit generations to come.

    We care about each other, our customers and our communities. We are inspired to make a difference, and we are committed to integrity and excellence.

    Together we will empower people to live healthier lives.

    Aetna is an equal opportunity & affirmative action employer. All qualified applicants will receive consideration for employment regardless of personal characteristics or status. We take affirmative action to recruit, select and develop women, people of color, veterans and individuals with disabilities.

    We are a company built on excellence. We have a culture that values growth, achievement and diversity and a workplace where your voice can be heard.

    Benefit eligibility may vary by position. Click here to review the benefits associated with this position.

    Aetna takes our candidates's data privacy seriously. At no time will any Aetna recruiter or employee request any financial or personal information (Social Security Number, Credit card information for direct deposit, etc.) from you via e-mail. Any requests for information will be discussed prior and will be conducted through a secure website provided by the recruiter. Should you be asked for such information, please notify us immediately.

Job Function: Information Technology