Talent.com
ETL Architect
ETL ArchitecteAspire Technolabs Inc. • Windsor, Connecticut, United States
ETL Architect

ETL Architect

eAspire Technolabs Inc. • Windsor, Connecticut, United States
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

#c2c #Onsite # H1B

Hi ,

Hope you are doing well !

We are hiring for ETL Architect Onsite at Windsor, CT .

Title : ETL Architect

Location : Windsor, CT (Onsite)

Experience : 18+ years

Visa : H1B

Job Description :

We are seeking a seasoned ETL Architect to design and lead scalable data integration solutions for our enterprise Snowflake Data Warehouse . This role requires expertise in Snowflake along with hands-on experience in working with diverse data sources and ETL / ELT technologies. The architect will ensure efficient data movement, transformation, and governance across heterogeneous systems to support analytics and business intelligence initiatives.

Key Responsibilities :

  • Design and implement ETL / ELT architecture with Snowflake as the enterprise data warehouse .
  • Integrate data from diverse sources ( RDBMS, APIs, SaaS apps, flat files, streaming platforms, cloud services ) into Snowflake.
  • Define data integration best practices, including reusability, scalability, and cost optimization.
  • Lead and mentor ETL / ELT developers in building robust pipelines.
  • Optimize Snowflake performance (virtual warehouses, clustering, query tuning).
  • Establish data quality, governance, and lineage frameworks.
  • Collaborate with data architects, BI developers, and business stakeholders for end-to-end data delivery.
  • Evaluate and implement ETL / ELT tools and automation frameworks suited for multiple source systems.
  • Troubleshoot integration issues and define long-term solutions.
  • Keep up to date with Snowflake features and emerging data integration technologies.

Required Skills & Qualifications :

  • 18+ years in ETL / ELT architecture and development .
  • Strong expertise in Snowflake (warehouses, streams, tasks, snowpipe, data sharing).
  • Proficiency in multiple ETL / ELT tools : Informatica, Talend, Matillion, SSIS, AWS Glue, DBT, Fivetran .
  • Strong SQL and performance optimization skills.
  • Experience working with varied data sources : Oracle, SQL Server, SAP, Salesforce, REST APIs, flat files, cloud-native systems.
  • Solid understanding of data modeling (star schema, snowflake schema, data vault) and data warehousing principles.
  • Hands-on experience with cloud platforms (AWS / Azure / GCP) for data integration.
  • Strong leadership and communication skills for onsite stakeholder management.

    • Nice to Have :

  • Experience with real-time / streaming data integration (Kafka, Kinesis, Azure Event Hub).
  • Familiarity with data governance and catalog tools (Collibra, Alation).
  • Knowledge of big data ecosystems (Spark, Hadoop).
  • Exposure to BI / Analytics platforms ( Power BI, Tableau, Qlik ).

    • Thanks & Regards

    Shraddha | eAspire Technolabs

    [job_alerts.create_a_job]

    Architect • Windsor, Connecticut, United States

    [internal_linking.related_jobs]
    Business Systems Analyst

    Business Systems Analyst

    Ensign-Bickford Industries • Simsbury, CT, United States
    [job_card.full_time]
    Ensign-Bickford Industries, Inc.EBI) and you'll be part of a team that leads science, innovation, and technology on different industry fronts. Working here will provide you with an exciting and moti...[show_more]
    [last_updated.last_updated_30] • [promoted]
    ETL Architect

    ETL Architect

    eAspire Technolabs Inc. • Windsor, CT, United States
    [job_card.full_time]
    We are hiring for ETL Architect Onsite at Windsor, CT.Location : Windsor, CT (Onsite).This role requires expertise in Snowflake along with hands-on experience in working with diverse data sources a...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel Nurse RN - Emergency Room (ER) / Trauma in Holyoke, MA

    Travel Nurse RN - Emergency Room (ER) / Trauma in Holyoke, MA

    TravelNurseSource • Holyoke, MA, US
    [job_card.full_time]
    TravelNurseSource is working with GLC Group, GLC On-The-Go to find a qualified ER / Trauma RN in Holyoke, Massachusetts, 01040!. RN Emergency Department (ER) - Holyoke, MA - 8-week contract.GLC – Name...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Flow Line Lead

    Flow Line Lead

    Pursuit Aerospace • South Windsor, CT, United States
    [job_card.full_time]
    As a global manufacturer of complex aircraft engine components, Pursuit Aerospace is founded on a commitment to relentless, continuous, operational improvement and extraordinary customer service.We...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Software Solutions Analyst (MS Power Apps)

    Senior Software Solutions Analyst (MS Power Apps)

    PeoplesBank • Holyoke, MA, United States
    [job_card.full_time]
    Welcome to PeoplesBank! We are the largest mutually chartered bank in Western Mass and Northern Connecticut, we are proud to lead the way in green values, sustainable energy financing, and charitab...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Customer Support Engineer

    Customer Support Engineer

    VirtualVocations • Springfield, Massachusetts, United States
    [job_card.full_time]
    A company is looking for a Customer Support Engineer who will bridge communication between customers and technical teams. Key Responsibilities Serve as a primary technical contact for customers, i...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel Emergency Room RN - $3,067 per week

    Travel Emergency Room RN - $3,067 per week

    ADN Healthcare • Northampton, MA, United States
    [job_card.permanent]
    ADN Healthcare is seeking a travel nurse RN ED - Emergency Department for a travel nursing job in Northampton, Massachusetts. Job Description & Requirements.Our Client is currently seeking ED - Emer...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Installer Installation

    Installer Installation

    Gulfstream Aerospace Corporation • Westfield, MA, Hampden County, MA; Massachusetts, United States
    [job_card.full_time]
    Interior Installation Technician 1 in GAC Westfield The base compensation range for this role is $22.Medical, prescription, dental and vision coverage Life and disability insurance Retirement savin...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Manager of User Support - CICS IT (Hybrid Opportunity)

    Manager of User Support - CICS IT (Hybrid Opportunity)

    InsideHigherEd • Amherst, Massachusetts, United States
    [job_card.full_time]
    Computer & Information Technology, PSU A.The flagship of the Commonwealth, the University of Massachusetts Amherst is a nationally ranked public land-grant research university that seeks to expand ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Site Support Analyst

    Site Support Analyst

    Chubb • Simsbury, CT, US
    [job_card.full_time]
    Chubb’s Global End User Services (EUS) organization is relentlessly focused on driving and improving the end user experience globally thru technology programs, deliveries and innovative solutions.W...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Project Manager or Business Analyst (Bloomberg Port Migration) REMOTE

    Project Manager or Business Analyst (Bloomberg Port Migration) REMOTE

    Blake Smith Staffing, LLC • Windsor Locks, CT, US
    [filters.remote]
    [job_card.part_time]
    [filters_job_card.quick_apply]
    Project Manager / Business Analyst (Contractor) – Job Description.Project Manager / Business Analyst (Contractor).Head of Investment Technology and Data Management. We are seeking a dynamic and experien...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    ETL Architect

    ETL Architect

    ALIS Software LLC • Windsor, CT, United States
    [job_card.full_time]
    Here is a great opportunity for.Grab this opportunity at the earliest.Location : Windsor, CT (Need locals only).Design and implement ETL / ELT architecture with. Snowflake as the enterprise data wareh...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Engineer

    Engineer

    Munich RE • Hartford, CT, United States
    [job_card.full_time]
    The Engineer - ETL will be responsible for transferring & analyzing data from various platforms and software environments, creating actionable changes and improvements to the business.Provides subj...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Development Engineer III

    Development Engineer III

    Ensign-Bickford Industries • Simsbury, CT, United States
    [job_card.full_time]
    This opportunity is located within our.Ensign-Bickford Aerospace & Defense Company.EBAD seeks an engineer for the position. Product Development Engineering Lead.The development engineer (DE) is the ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Systems Analyst (Hybrid Opportunity)

    Senior Systems Analyst (Hybrid Opportunity)

    InsideHigherEd • Amherst, Massachusetts, United States
    [job_card.full_time]
    Computer & Information Technology, PSU A.The flagship of the Commonwealth, the University of Massachusetts Amherst is a nationally ranked public land-grant research university that seeks to expand ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Sr. Director, IT Infrastructure & Cloud

    Sr. Director, IT Infrastructure & Cloud

    TicketNetwork • South Windsor, CT, US
    [job_card.full_time]
    Since 2002, TicketNetwork has served the ticketing and event industry as the go-to platform team for promoters, venues, and resale operators looking to manage and grow their ticketing business.Offe...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Tooling Specialist I (UH) - 2nd shift

    Tooling Specialist I (UH) - 2nd shift

    U.S. Tsubaki Power Transmission, LLC Careers • Holyoke, Massachusetts, US
    [job_card.full_time]
    The TSUBAKI name is synonymous with excellence in quality, dependability, and customer service.Tsubaki is a leading manufacturer and supplier of power transmission and motion control products.As a ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Business Systems Analyst

    Business Systems Analyst

    Mindlance • Springfield, MA, US
    [job_card.full_time]
    Advance your career with Mindlance!.We have been connecting talented IT professionals with world-class companies since 1999. Mindlance is here to help you to find the perfect fit with just the right...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]