Senior Technical Lead (IN)

HCLTech

Fresher India Full Time Remote
HCLTech logo
Posted : today
Actively hiring

Job description

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.

Responsibilities

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.

Qualifications

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.

Essential Skills

SnowflakedbtData WarehousingETLELTData ModelingSQLRDBMSVirtual WarehousesSnowflake Storage & Compute OptimizationComplex Query writing and Performance TuningClustering & Partitioning StrategiesSnowpipeStreams & TasksTime Travel & Fail-safeData SharingRole-Based Access Control (RBAC)dbt Coredbt Clouddbt ModelsMacrosSeedsSnapshotsIncremental ModelsCI/CD IntegrationData Lineage and GovernanceDimensional ModelingStar and Snowflake SchemasData Lake and Data Warehouse ArchitecturesSCD Type 1 & Type 2 ImplementationsOracleSQL ServerPostgreSQL

Good to Have

AWSAzureGCPInformaticaMatillionFivetranTalendAzure Data FactoryGitHubGitLabAzure DevOpsJenkinsData GovernanceData Quality

Highlights

  • Actively hiring

More Details

RoleSenior Technical Lead (IN)
Employment TypeFull Time, Remote

About the Company

HCLTech logo

HCLTech

IT Consulting

Senior Technical Lead (IN) at HCLTech | SkillMX | SkillMX