onsite
Snowflake Senior Technical Lead - HCLTech
Engineering Manager
Lead the design and maintenance of Snowflake data warehouses, building robust ETL/ELT pipelines and integrating diverse data sources using SQL, Informatica, and Amazon S3. Drive performance, reliability, and scalability for enterprise data solutions.
About the role
Key Responsibilities
- Design, develop, and maintain scalable Snowflake data warehouse solutions that support enterprise analytics.
- Build and optimize ETL/ELT pipelines using Snowflake, Informatica, and Amazon S3, ensuring data quality and performance.
- Integrate Snowflake with external data sources via APIs, custom connectors, and data integration tools.
- Implement and manage Snowflake objects—tables, views, stages, and tasks—to support business requirements.
- Write efficient, maintainable SQL queries and scripts for data transformation and reporting.
- Collaborate with data architects, analysts, and stakeholders to translate business needs into technical solutions.
Requirements
- 5+ years of experience in Snowflake development and data warehousing.
- Proficiency in SQL, ETL/ELT design, and performance tuning.
- Hands‑on experience with Informatica, Amazon S3, and API integration.
- Strong understanding of cloud data platforms and best practices for data security and governance.
- Excellent problem‑solving skills and ability to mentor junior team members.