What are the responsibilities and job description for the ETL Architect position at eAspire Technolabs Inc.?
#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