ETL Solutions Architect in Windsor, CT at Fast Switch

Date Posted: 1/15/2020

Job Snapshot

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

Job Description

Job ID: 55663

Our client in Windsor, Connecticut is seeking a ETL Solutions Architect. 

Candidates who are eligible to work in the US without sponsorship are encouraged to apply. 

Profile Summary

Our client is embarking on the Enterprise Data Management journey that includes building strong master data management, data governance, data quality, data modeling, and metadata management practices. 

Profile Responsibilities:

  • Develops and supports ETL architecture and processes to support business applications, including:
    • Change-Data-Capture (CDC) type I and type II strategies
    • Batch Process error detection, mitigation, and notification strategies
    • ETL error detection, mitigation, and notification strategies
    • ETL performance monitoring and tuning strategies
    • Comprehensive Documentation of all of the above activities
  • Works with physical Data Modelers, DBAs, and Informatica engineers to continuously enhance ETL code and improve ETL performance and reliability while maintaining simplicity
  • Manages source data catalogue
  • Maintains and enhances the client's ETL development standards
  • Leads a team of onsite/offshore vendor resources
  • Plans and coordinates release management aspects as well as development sprints


  • Bachelor degree in Computer Science or Mathematics and 7+ years of Informatica/ETL related work experience
  • Demonstrated success in professional services consulting projects in a leadership or individual contributor role
  • Additional relevant hands on experience in all of the following technologies is a requirement:
    • Oracle 11 or above, Physical Modeling, Administration, or PL/SQL expertise; Certifications are a plus
    • Deep Informatica expertise
    • Experience with Oracle Data Warehousing environments
    • Experience with Large Databases, at least 1TB
    • Experience with patching, upgrading, and refactoring ETL, especially in production environments
  • Candidate should have implemented and have hands on experience and knowledge of upgrading and configuring Informatica platform and implementing enterprise messaging systems
  • Experience with Code Deployment best practices
  • Functional work in and familiarity with enterprise architecture, data warehouse concepts
  • Solution design experience for large scale initiatives
  • Excellent communication skills – must be able to interface with business as well as technical leaders
  • Excellent documentation skills
  • Ability to collaborate and work in a multi-site environment
  • Experience working in a dynamic, agile or continuous improvement environment
  • Self-starter with ability to work in an environment without clearly defined requirements and frequent ambiguity
  • Eagerness to learn new tools and technologies

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.