Senior Technical Lead (IN)
HCLTech
HCLTech
Seeking a highly skilled Data Engineer with extensive expertise in Snowflake and dbt. The ideal candidate will possess strong hands-on experience in designing, building, optimizing, and maintaining modern cloud-based data platforms. A solid foundation in Data Warehousing, ETL/ELT processes, Data Modeling, SQL, and RDBMS technologies is essential for developing scalable and high-performing data solutions.
Key responsibilities include designing and developing scalable data pipelines using Snowflake and dbt, building and optimizing data warehouse solutions for analytics, and developing robust ELT/ETL frameworks. You will create reusable dbt models, macros, and tests, optimize Snowflake performance and costs, and develop data ingestion frameworks. Implementing data quality checks, monitoring, and governance controls are also crucial. Collaboration with stakeholders to translate business needs into technical solutions and troubleshooting production issues are key aspects of this role.
Required skills include strong hands-on experience with Snowflake architecture, administration, virtual warehouses, storage/compute optimization, complex query writing, clustering, Snowpipe, Streams & Tasks, Time Travel, Data Sharing, and RBAC. Expertise in dbt Core/Cloud, dbt models, macros, seeds, snapshots, incremental models, and CI/CD integration is also mandatory. A deep understanding of Data Warehousing concepts like Dimensional Modeling, Star/Snowflake Schemas, Data Lakes, and SCD Type 1 & 2 implementations is expected. Extensive experience in designing and implementing ETL/ELT solutions for large-volume data processing and strong knowledge of RDBMS platforms like Oracle, SQL Server, or PostgreSQL are essential.
HCLTech
IT Consulting