Sr. ETL Architect/Solution Architect in Windsor, CT at Voya

Date Posted: 11/28/2019

Job Snapshot

  • Employee Type:
  • Location:
    1 Orange Way
    Windsor, CT
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description

As part of the application process, a candidate account is required to log in and view application(s).  Please be sure to check email regularly for information regarding our employment process.

Job Summary:

The Sr. ETL Architect/Solution Architect consultant role will be a key architecture positions for VOYA Financial Data Services team. They will support ETL, data transformation work and deliver critical solutions, designs & data movement between applications. The Sr. ETL Architect/Solution Architect will comfortably work both architecture and hands on ETL development roles and offer thought leadership in ETL activities.

Job Responsibilities:

  • Accountable for leading or supporting architecture activities that create deliverables that guide business models, people, process, organizational change, and technology investments in response to disruptive forces and toward achieving targeted business outcomes.
  • This individual is responsible for leveraging technology to enable the organization's future-state business capabilities, which can enable or alter business processes or practices that, in turn, drive the organization's targeted business outcomes.
  • Solution architect consultants must be capable of practically applying existing, new, and emerging technologies to new and evolving business and operating models. Conversely, they must be able to understand, monetize and operationalize new technologies.
  • The individual in this role develops deliverables that are valuable to the business, including business capabilities, business requirements and workflow.
  • The role focuses on business technology strategy and targeted business outcomes — clarifying strategic intentions; identifying business outcomes; exploring implications, impacts and risks; and addressing stakeholder questions.  
  • This is a highly technical role, providing leadership and technical competence to deliver excellent client solutions that adhere to Voya defined standards. 
  • They determine practicality and technical fit of developed standards and architectures.  Exceptional knowledge of software development and system engineering practices will be required in order to insure the optimal solution is designed and that the engineers work to the highest quality.  
  • While this role does not typically configure or operate the platforms directly – the candidate should have performed these roles in prior experience.  They should be capable of engaging in hands on development or configuration if required.  The ideal candidate thrives on problem solving and has a passion for data, efficiency, and accuracy. The Solution Architect Consultant represents a capability area that maintains and leverages knowledge of a specific, strategically significant technology platform so that Voya can support implementation of change that leverages that platform in the context of meeting a business need.
  • Architect ETL solutions to process/load source systems data into multiple databases using Informatica.
  • Hands on Lead ETL Consultant responsible for design and development of ETL components and provide support for maintenance and Enhancements.
  • Convert ETL design into specific development activities and communicate progress to management and project leads
  • Prepare Technical Design document to translate Business requirements.
  • Ability to lead Large initiatives
  • Conduct code review meetings with the team.
  • ETL performance tuning, Implement Performance optimizations through Transformations and Partition techniques.
  • Lead a team of onsite/offshore vendor partners
  • Excellent Presentation and influential skills.
  • Support QA team’s test cases and test data preparation. Carries out unit and Integration test support.
  • Good Communicator and proactive approach to daily activities.
  • Problem solving attitude.
  • Coordinate release activities.
  • Provide production support on need basis

Job Qualifications:

  • Bachelor degree in Computer Science, Mathematics, Science preferred or equivalent work experience.
  • 10+ years progressive experience in system/data analysis related to ETL, data management, data integration and data delivery work.
  • 8+ ETL experience using Informatica Power Center version 9.6 or higher
  • Skilled in Informatica ETL tool suite to design and develop work flows, transformation mappings.
  • Strong skills in ETL design and development - understanding the trade-offs of various design options on multiple platforms using multiple protocols
  • Experience Code Deployment best practices
  • Expertise in UNIX shell scripting
  • Must have experience in two or more of the databases UDB, Sybase, Sqlserver, Oracle, Exadata
  • Functional work in and familiarity with enterprise architecture, Data warehouse, data modeling concepts
  • Solution design experience for large scale initiatives
  • Excellent communication skills – need to be able to interface with business as well as technical leaders
  • Successful in a matrix work environment
  • Excellent documentation skills
  • Ability to collaborate and work in a multi-site environment
  • Experience working in an agile or continuous improvement environment
  • Eagerness to learn new tools and technologies
  • Prior experience with financial services, retirement, insurance, or medical records industry highly desirable



Critical Skills
At Voya, we have identified the following critical skills which are key to success in our culture: 

  • Customer Focused: Passionate drive to delight our customers and offer unique solutions that deliver on their expectations.
  • Critical Thinking: Thoughtful process of analyzing data and problem solving data to reach a well-reasoned solution.
  • Team Mentality: Partnering effectively to drive our culture and execute on our common goals. 
  • Business Acumen: Appreciation and understanding of the financial services industry in order to make sound business decisions. 
  • Learning Agility: Openness to new ways of thinking and acquiring new skills to retain a competitive advantage.

Learn more about Critical Skills.


  1. Software Engineer Jobs
  2. Project Engineer Jobs