Skip to main content

Information Technology

Aetna IT is committed to keeping our members at the heart of everything we do. Our top-talent workforce delivers leading-edge technology, drives innovation, turns vision into action and challenges the art of the possible. We provide best-in-class services to our members by delivering groundbreaking healthcare tools, enabling consumer-friendly interactions and protecting data security. Your mission will be to deliver innovating technology solutions including: Hybrid cloud infrastructure, artificial intelligence/machine learning capabilities and infrastructure as code.

Aetna, a CVS Health Company, is a company with a world-class IT team and we will be counting on you to carry on our success as the preferred provider of infrastructure services for our business partners.

Back to Job Navigation (Overview)

Success Profile

What makes a successful Information Technologist?
Here are the traits we are looking for:

  • Adaptable
  • Collaborative
  • Communicator
  • Digitally Savvy
  • Good Listener
  • Problem-solver
  • Results Driven
  • Team Player
  • Technologically savvy
  • Versatile
  • Relationship expertise
  • Diplomatic
  • Trustworthy
  • Business Savvy

Back to Job Navigation (Success)

Benefits

  • Medical

  • Dental

  • Vision

  • Healthcare
    FSA

  • Dependent
    Care FSA

  • Health and
    Wellness
    Programs

Back to Job Navigation (Rewards)

Job Details

Senior Application Developer- SSIS, SQL Server

Primary Location: New Albany, Ohio
Additional Locations: OH-New Albany
Apply
Description:
Under general direction, formulates and defines system scope and objectives. Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time and form of desired results. Prepares detailed technical specifications from which programs will be written. Designs, codes, tests, debugs, and documents those programs. Competent to work at the highest technical level of all phases of applications systems analysis and programming activities. Regularly provides guidance and training to less-experienced programmer/analysts. This position will be in an on call rotation supporting our applications and servers.

Fundamental Components:
  • 6+ years in database development experience including SQL Server 2012.
  • Must have extensive database modeling, design, development, and maintenance experience.
  • Proven experience with dimensional databases including SQL Server 2012.
  • Skilled in both Data Warehouse and Transactional databases.
  • Strong background in schema design and development.
  • Extensive Stored Procedure development.
  • Strong T-SQL programming skills.
  • Experience developing SSIS ETL packages supporting database to database activities.
  • Skilled in developing dimensional databases and data cubes
  • Proven experience with SQL Server Analysis Services.
  • Proven experience with SQL Server Reporting Services.
  • Ability to design unit and system test plans, and execute testing.
  • Extensive database administration experience
  • Excellent communicator both verbally and written with coordination and facilitation skills.
  • Ability to multi-task and complete in a timely manner multiple assignments.
  • Provide 24/7 support on a rotation basis
  • Health care experience a must.


Background Experience:
  • Expertise in one or more programming language, development tools, and/or databases and the systems development life cycle, applicable to development organization.
  • 6+ years’ experience in application program development, or an equivalent combination of education and work experience.
  • Understand the business and functional requirements that apply to the applications supporting a sub-domain or domain as well as their relevant interfaces.
  • 6+ years experience in systems analysis and application program development, or an equivalent combination of education and work experience.
  • Experience with application development support software packages.
  • Affiliated with a technical or professional organization or user group
  • Bachelor's degree in Computer Science or an equivalent combination of education and experience.


Additional Job Information:
Ability to adapt to changing priorities.May act as Team Leader. May be involved in providing assistance and training to lower level Programmer/Analysts.Receives general supervision, and is competent to work at the highest level of all technical phases of systems analysis and application program development while working on own most of the time.Ability to work effectively with business areas, IT infrastructure teams, and IT management and staff.Broad knowledge of the client area's functions and systems, and systems and application program development technologies alternatives.Excellent communication skills.

Required Skills:
Technology - Developing Software Solutions

Desired Skills:
Technology - Developing Competitive Technology and Architecture, Technology - Leveraging Technology

Functional Skills:
Information Management - Data Warehousing, Information Management - Database Structures, Information Technology - Application development, Information Technology - Application maintenance & support, Information Technology - Infrastructure management

Technology Experience:
Database - Microsoft SQL Server, Development Experience - Client/Server, Development Tool - Microsoft Visual Studio, Operating System - .NET Framework

Education:
Information Technology - Microsoft Certified IT Professional (MCITP)

Potential Telework Position:
No

Percent of Travel Required:
0 - 10%

EEO Statement:
Aetna is an Equal Opportunity, Affirmative Action Employer

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

Candidate Privacy Information:
Aetna takes our candidate'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.

Click To Review Our Benefits (PDF)

Apply

Influential Content

Back to Job Navigation (Trending)

Sign up for Job Alerts

Explore This Area

Check out where you could be working if you apply.

View Map

Similar Jobs

Join Our Talent Community

Sign up to receive information about job openings that are tailored to your skills and interests. Plus, get the latest career news from Aetna.