#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