This site uses cookies. To find out more, see our Cookies Policy

Sr. Informatica / Solution Architect in Windsor, CT at Fast Switch

Date Posted: 4/8/2019

Job Snapshot

Job Description

Job ID: 51734

Our client in Windsor, Connecticut is seeking a Sr. ETL / Solutions Architect.  Candidates who are eligible to work in the US without sponsorship are encouraged to apply.  The Sr. ETL Architect / Solution Architect consultant role will be a key architecture role for the client's Financial Data services team. They will support ETL, data transformation work and deliver designs & data movement between applications. 
  • The ETL Solution Architect Consultant is accountable for proactively and holistically 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 the client's 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 the client 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
Ideal Candidate:
  • 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 tradeoffs 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

Fast Switch, Ltd. is a high-growth IT staffing firm, with headquarters in Dublin, Ohio and with offices serving the Columbus, Detroit, Boston, Cincinnati, Minneapolis, Phoenix, Hartford, Los Angeles, Tucson, San Francisco, Denver, and Cleveland metropolitan areas.  We have a staff of over 780 associates and have experienced growth while remaining profitable.

Compensation can vary depending on experience and capability, plus benefits which include healthcare, dental, and vision insurance, long term disability coverage, and 401(k) with match and IMMEDIATE vesting.  Our benefits package, in this day and age, is superb.

To view all of our open positions, please go to: and/or navigate to our Careers page.