eAspire Technolabs Inc.
Direct message the job poster from eAspire Technolabs Inc.
We are hiring for ETL Architect Onsite at Windsor, CT.
Title ETL Architect
Location Windsor, CT (Onsite)
Experience 18+ years
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).
Contact shraddha@easpire.net
6099345878
#J-18808-Ljbffr
We are hiring for ETL Architect Onsite at Windsor, CT.
Title ETL Architect
Location Windsor, CT (Onsite)
Experience 18+ years
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).
Contact shraddha@easpire.net
6099345878
#J-18808-Ljbffr