Azure Data Technical Specialist
India
Job Description
Azure Data Technical Specialist
Chennai, Tamil Nadu

Job Summary

We are seeking a highly skilled SQL-focused Data Engineer / Developer with strong expertise in Databricks. The ideal candidate will be responsible for designing, optimizing, and managing data pipelines, with a strong focus on query performance tuning, scalability, and efficient data processing.

Key Responsibilities

  1. Key Responsibilities
  • Develop, optimize, and maintain SQL queries, stored procedures, and data pipelines
  • Design scalable and efficient data processing solutions using Databricks
  • Work with large-scale structured and semi-structured datasets
  • Ensure data quality, integrity, and reliability across systems
  • Collaborate with data analysts, engineers, and business stakeholders
  • Support data migration, transformation, and integration initiatives

  1. Performance Tuning & Optimization (Mandatory Focus)
  • Optimize SQL queries for performance using:
    • Indexing strategies (clustered/non-clustered)
    • Query execution plan analysis
    • Partitioning and data distribution techniques
  • Improve data processing efficiency in Databricks:
    • Spark job optimization (partitioning, caching, broadcast joins)
    • Delta Lake optimizations (Z-ordering, vacuum, optimize commands)
  • Identify and resolve performance bottlenecks in pipelines and queries
  • Reduce query runtime and resource utilization

  1. Additional Skills (Preferred)
  • Experience with cloud platforms (Azure preferred)
  • Knowledge of ETL tools and pipelines
  • Familiarity with Python / PySpark
  • Exposure to CI/CD pipelines and version control (Git)
  • Understanding of big data frameworks and distributed systems

Skill Requirements

  1. Secondary Skills (Good to Have)
  2. 2. Databricks
  • Hands-on experience with Azure Databricks / Databricks Lakehouse platform
  • Strong knowledge of:
    • Apache Spark (SQL & PySpark)
    • Delta Lake architecture
  • Experience building:
    • ETL/ELT data pipelines
    • Data transformations using Spark
  • Familiarity with:
    • Notebooks, clusters, jobs, and workflows
  • Understanding of data lake and medallion architecture (Bronze, Silver, Gold layers)

Other Requirements

  1. Secondary Skills (Good to Have)
  2. 2. Databricks
  • Hands-on experience with Azure Databricks / Databricks Lakehouse platform
  • Strong knowledge of:
    • Apache Spark (SQL & PySpark)
    • Delta Lake architecture
  • Experience building:
    • ETL/ELT data pipelines
    • Data transformations using Spark
  • Familiarity with:
    • Notebooks, clusters, jobs, and workflows
  • Understanding of data lake and medallion architecture (Bronze, Silver, Gold layers)
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.