Senior Technical Specialist

HCLTech · IT Consulting & Digital Transformation · Managed IT Services (MSP) · Doctoral Degree (PhD) · Python · ETL/ELT · Data Vault · 1 hour ago
Smart Apply
Similar jobs
2,163,346open jobs
139,194companies
239,815added this week
Browse all
Location
In office (Chennai)
Seniority
Senior
Visa
Sponsors visas in Ireland; no register of this country names it

Confirmed on the employer's own hiring board on Nov 11, 2026. First seen by Alion on Nov 11, 2026.

Overview
Company
Impact
Profile match

HCLTech

HCLTech is an Indian information technology services and consulting company headquartered in Noida, Uttar Pradesh. Its roots lie in HCL, founded in 1976 by Shiv Nadar and partners, and the IT services business was set up as a separate company in 1991. It provides application development and maintenance, infrastructure and cloud services, cybersecurity, engineering and R&D services, and sells its own software products through HCLSoftware. The company employs more than 200,000 people in some 60 countries and is listed on the Indian stock exchanges.
hcltech.com · HQ: Noida, India · Engineering Services · Managed IT Services (MSP) · Systems Integrators · IT Consulting & Digital Transformation · IT Outsourcing & Dedicated Teams · 5000+ employees · Est. 1976
Tech stack of HCLTech

Job Summary

  • Design and implement scalable data architectures and ELT pipelines on Snowflake.
  • Develop, test and maintain modular DBT models, macros, tests and documentation, following analytics engineering best practices.
  • Write and optimise complex T-SQL queries, stored procedures and views in MS SQL Server, and lead migration of legacy workloads to Snowflake.
  • Build Python-based automation, data ingestion, transformation and orchestration frameworks.
  • Define data modelling standards (dimensional, Data Vault, star/snowflake schemas) and ensure data quality, lineage and governance.
  • Tune performance and manage cost in Snowflake (warehouse sizing, clustering, query optimisation, resource monitors).
  • Implement CI/CD, version control (Git) and environment promotion for DBT and data pipelines.
  • Collaborate with business stakeholders, analysts and architects to translate requirements into technical solutions.
  • Conduct code reviews, set engineering standards and mentor junior and mid-level engineers.
  • Troubleshoot production issues and ensure SLA adherence for data delivery.

Key Responsibilities

  • Design and implement scalable data architectures and ELT pipelines on Snowflake.
  • Develop, test and maintain modular DBT models, macros, tests and documentation, following analytics engineering best practices.
  • Write and optimise complex T-SQL queries, stored procedures and views in MS SQL Server, and lead migration of legacy workloads to Snowflake.
  • Build Python-based automation, data ingestion, transformation and orchestration frameworks.
  • Define data modelling standards (dimensional, Data Vault, star/snowflake schemas) and ensure data quality, lineage and governance.
  • Tune performance and manage cost in Snowflake (warehouse sizing, clustering, query optimisation, resource monitors).
  • Implement CI/CD, version control (Git) and environment promotion for DBT and data pipelines.
  • Collaborate with business stakeholders, analysts and architects to translate requirements into technical solutions.
  • Conduct code reviews, set engineering standards and mentor junior and mid-level engineers.
  • Troubleshoot production issues and ensure SLA adherence for data delivery.

Skill Requirements

  • Design and implement scalable data architectures and ELT pipelines on Snowflake.
  • Develop, test and maintain modular DBT models, macros, tests and documentation, following analytics engineering best practices.
  • Write and optimise complex T-SQL queries, stored procedures and views in MS SQL Server, and lead migration of legacy workloads to Snowflake.
  • Build Python-based automation, data ingestion, transformation and orchestration frameworks.
  • Define data modelling standards (dimensional, Data Vault, star/snowflake schemas) and ensure data quality, lineage and governance.
  • Tune performance and manage cost in Snowflake (warehouse sizing, clustering, query optimisation, resource monitors).
  • Implement CI/CD, version control (Git) and environment promotion for DBT and data pipelines.
  • Collaborate with business stakeholders, analysts and architects to translate requirements into technical solutions.
  • Conduct code reviews, set engineering standards and mentor junior and mid-level engineers.
  • Troubleshoot production issues and ensure SLA adherence for data delivery.

Other Requirements

  • Design and implement scalable data architectures and ELT pipelines on Snowflake.
  • Develop, test and maintain modular DBT models, macros, tests and documentation, following analytics engineering best practices.
  • Write and optimise complex T-SQL queries, stored procedures and views in MS SQL Server, and lead migration of legacy workloads to Snowflake.
  • Build Python-based automation, data ingestion, transformation and orchestration frameworks.
  • Define data modelling standards (dimensional, Data Vault, star/snowflake schemas) and ensure data quality, lineage and governance.
  • Tune performance and manage cost in Snowflake (warehouse sizing, clustering, query optimisation, resource monitors).
  • Implement CI/CD, version control (Git) and environment promotion for DBT and data pipelines.
  • Collaborate with business stakeholders, analysts and architects to translate requirements into technical solutions.
  • Conduct code reviews, set engineering standards and mentor junior and mid-level engineers.
  • Troubleshoot production issues and ensure SLA adherence for data delivery.
Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,163,346 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Sales
Similar stack
Same company
Chennai
In office · 8+ years exp · Noida
Java
SQL
Java
Maven
Databases
Google BigQuery
DevOps
Terraform
GCP
Kustomize
GitLab CI
CI/CD
Kubernetes
Google GKE
IAM
Cybersecurity
Least Privilege
Apply
Hybrid · Full-Time · 6+ years exp · Mumbai
Apply
In office · Full-Time · 4+ years exp · Bachelor's Degree · Chennai
Apply
In office · 4+ years exp · Noida · Delhi · Gurgaon
Marketing
Salesforce
HubSpot
Apply
In office · Full-Time · Pune · Surat · Bhopal · Anand
Apply
In office · Full-Time · Chennai
Apply
In office · 5+ years exp · Chennai
Python
Java
SQL
C#
C#
.NET
Databases
PostgreSQL
DevOps
Azure DevOps
Azure
CI/CD
Jenkins
AWS
Kubernetes
Platform Engineering
GitHub
Management
Confluence
Agile
Apply
Apply
Data Product Owner 1 day ago
In office · 6+ years exp · Chennai
Python
JavaScript
TypeScript
SQL
Databases
Databricks
AI/ML
Human-in-the-Loop
Frontend
GraphQL
React.js
DevOps
Rest API
WebSockets
Platform Engineering
Analytics
ETL/ELT
Management
Agile
Apply
Sr underwriter 14 1 day ago
In office · 1+ year exp · Chennai
Apply
See all jobs
This is one of many
2,163,346 more open roles from verified company boards, updated every day.
Browse all jobs Get matched roles