Project Architect

7 days ago

Windsor CT, United States eAspire Technolabs Inc. Full time

#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
shraddha@easpire.net
6099345878

  • Lead Enterprise Architect

    2 weeks ago

    Windsor, United States RIT Solutions, Inc. Full time

    Responsibilities: Enterprise Technology Strategy and enablement: As a leader, you'll be responsible for delivering and enabling Technology Strategy for various Lines of Businesses. Develop and deliver a technology strategy for one or more LOBs in alignment with EA's overall Technology Strategy. Ensure solution architecture roadmaps created by LOB architects...

  • Lead Enterprise Architect

    2 weeks ago

    Windsor, CT, United States RIT Solutions, Inc. Full time

    Responsibilities: Enterprise Technology Strategy and enablement: As a leader, you'll be responsible for delivering and enabling Technology Strategy for various Lines of Businesses. Develop and deliver a technology strategy for one or more LOBs in alignment with EA's overall Technology Strategy. Ensure solution architecture roadmaps created by LOB architects...

  • Lead Enterprise Architect

    2 weeks ago

    Windsor, CT, United States RIT Solutions, Inc. Full time

    Responsibilities: Enterprise Technology Strategy and enablement: As a leader, you'll be responsible for delivering and enabling Technology Strategy for various Lines of Businesses. Develop and deliver a technology strategy for one or more LOBs in alignment with EA's overall Technology Strategy. Ensure solution architecture roadmaps created by LOB architects...

  • Lead Enterprise Architect

    4 days ago

    Windsor, CT, United States RIT Solutions, Inc. Full time

    Responsibilities: Enterprise Technology Strategy and enablement: As a leader, you'll be responsible for delivering and enabling Technology Strategy for various Lines of Businesses. Develop and deliver a technology strategy for one or more LOBs in alignment with EA's overall Technology Strategy. Ensure solution architecture roadmaps created by LOB architects...

  • Lead Enterprise Architect

    2 days ago

    Windsor, CT, United States RIT Solutions, Inc. Full time

    Responsibilities: Enterprise Technology Strategy and enablement: As a leader, you'll be responsible for delivering and enabling Technology Strategy for various Lines of Businesses. Develop and deliver a technology strategy for one or more LOBs in alignment with EA's overall Technology Strategy. Ensure solution architecture roadmaps created by LOB architects...

  • Lead Enterprise Architect

    8 hours ago

    Windsor, CT, United States RIT Solutions, Inc. Full time

    Responsibilities: Enterprise Technology Strategy and enablement: As a leader, you'll be responsible for delivering and enabling Technology Strategy for various Lines of Businesses. Develop and deliver a technology strategy for one or more LOBs in alignment with EA's overall Technology Strategy. Ensure solution architecture roadmaps created by LOB architects...

  • Solution Architect

    2 weeks ago

    Windsor, United States My3Tech Inc Full time

    Hello, Hope you are doing good. Position: Solution Architect Location: Windsor CT (Onsite) Duration: Long Term Client: Cigniti/Coforge Job Description: Designing and configuring ServiceNow FSO modules: Customizing workflows, forms, and other elements within the FSO application to align with specific business processes like account opening, loan origination,...

  • Workday Architect

    2 days ago

    Hartford, CT, United States Oscar Full time

    Workday AI Architect - Onsite | Connecticut | $70-$85/hr Type: Contract We are seeking an experienced Workday AI Architect to support one of our clients onsite in Connecticut. This role requires a strong blend of Workday expertise, AI strategic design, and leadership in large-scale transformation programs. Bachelor's degree in Accounting,...

  • IT Enterprise Architect

    2 days ago

    Bloomfield, CT, United States The Cigna Group Full time

    Role Overview The Enterprise Architect will support: Pre-project planning and strategic analysis Provide an enterprise lens across domains such as dental insurance, underwriting, and related payer capabilities Must understand business problems, capabilities, context, and long-term planning Experience with sales, underwriting, install portions of...

  • VP, Enterprise Cloud Architect

    1 week ago

    Stamford, CT, United States Synchrony Full time

    Enterprise Cloud Architect At the heart of this innovation are the platforms that run our diverse applications and you could be the architect behind them. We are seeking an Enterprise Cloud Architect to lead complex application migration initiatives from traditional onpremises or data center environments to modern cloud platforms (primarily AWS, with...