Technical Specialist
India
Job Description
Technical Specialist
Noida, Uttar Pradesh

Job Summary

Position Overview

We are seeking an experienced Microsoft Fabric SQL Developer to support the development of a custom Master Data Management (MDM) Platform. This role will be responsible for designing, developing, and supporting backend data solutions leveraging Microsoft Fabric, SQL development, data integration, and analytics capabilities.

The ideal candidate will have strong experience in Microsoft Fabric, SQL development, data warehousing, and ETL/ELT processes. They will work closely with architects, frontend developers, data stewards, and business stakeholders to build scalable and high-performance data solutions that support master data management, governance, reporting, and analytics requirements.


Key Responsibilities

  • Design, develop, and maintain backend data solutions using Microsoft Fabric.
  • Develop and optimize SQL objects including stored procedures, views, functions, and data pipelines.
  • Build and support data ingestion, transformation, and integration processes within Microsoft Fabric.
  • Develop data models supporting Master Data Management (MDM), governance, reporting, and analytics requirements.
  • Create and manage Fabric Lakehouses, Warehouses, and Data Pipelines.
  • Implement data quality controls, validation processes, and reconciliation procedures.
  • Optimize database and query performance to support high-volume enterprise workloads.
  • Integrate data from multiple source systems, applications, APIs, and external platforms.
  • Collaborate with frontend, reporting, and business teams to deliver reliable and scalable data services.
  • Support data security, access control, governance, and compliance requirements.
  • Troubleshoot data issues, performance bottlenecks, and production support incidents.
  • Participate in solution design, testing, deployment, and release activities.

Required Qualifications

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
  • 5+ years of experience in SQL development and data engineering.
  • Hands-on experience with Microsoft Fabric development and administration.
  • Strong expertise in T-SQL development and query optimization.
  • Experience building and maintaining data pipelines and ETL/ELT processes.
  • Strong understanding of data warehousing concepts and dimensional modeling.
  • Experience working with large-scale enterprise data platforms.
  • Experience integrating data from multiple source systems.
  • Knowledge of data governance, master data concepts, and data quality processes.
  • Strong analytical, troubleshooting, and problem-solving skills.
  • Excellent communication and collaboration skills.

Preferred Qualifications

  • Experience supporting Master Data Management (MDM) platforms and data governance initiatives.
  • Hands-on experience with:
    • Fabric Data Factory
    • Fabric Lakehouse
    • Fabric Data Warehouse
    • OneLake
    • Fabric Notebooks
    • Real-Time Analytics
  • Experience with Azure Data Factory, Azure Synapse, or Azure Data Lake.
  • Experience developing APIs or backend services supporting data-driven applications.
  • Familiarity with Power BI and enterprise reporting solutions.
  • Exposure to AI, analytics, or data science workloads within Microsoft Fabric.
  • Experience working in Agile/Scrum environments.
  • Knowledge of CI/CD and DevOps practices.

Technical Skills

Microsoft Fabric

  • Microsoft Fabric
  • OneLake
  • Fabric Data Pipelines
  • Fabric Data Factory
  • Fabric Lakehouse
  • Fabric Data Warehouse
  • Fabric Notebooks
  • Real-Time Analytics

Database Development

  • Microsoft SQL Server
  • T-SQL
  • Stored Procedures
  • Views
  • Functions
  • Query Optimization
  • Performance Tuning

Data Engineering

  • ETL/ELT Development
  • Data Integration
  • Data Modeling
  • Data Warehousing
  • Data Quality and Governance
  • Master Data Management (MDM)

Cloud & Analytics

  • Microsoft Azure
  • Azure Data Factory
  • Azure Synapse Analytics
  • Power BI
  • REST APIs

Tools & Methodologies

  • Git
  • Azure DevOps
  • CI/CD Pipelines
  • Agile/Scrum

 

Key Responsibilities

Key Responsibilities

  • Design, develop, and maintain backend data solutions using Microsoft Fabric.
  • Develop and optimize SQL objects including stored procedures, views, functions, and data pipelines.
  • Build and support data ingestion, transformation, and integration processes within Microsoft Fabric.
  • Develop data models supporting Master Data Management (MDM), governance, reporting, and analytics requirements.
  • Create and manage Fabric Lakehouses, Warehouses, and Data Pipelines.
  • Implement data quality controls, validation processes, and reconciliation procedures.
  • Optimize database and query performance to support high-volume enterprise workloads.
  • Integrate data from multiple source systems, applications, APIs, and external platforms.
  • Collaborate with frontend, reporting, and business teams to deliver reliable and scalable data services.
  • Support data security, access control, governance, and compliance requirements.
  • Troubleshoot data issues, performance bottlenecks, and production support incidents.

Participate in solution design, testing, deployment, and release activities.

Skill Requirements

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
  • 5+ years of experience in SQL development and data engineering.
  • Hands-on experience with Microsoft Fabric development and administration.
  • Strong expertise in T-SQL development and query optimization.
  • Experience building and maintaining data pipelines and ETL/ELT processes.
  • Strong understanding of data warehousing concepts and dimensional modeling.
  • Experience working with large-scale enterprise data platforms.
  • Experience integrating data from multiple source systems.
  • Knowledge of data governance, master data concepts, and data quality processes.
  • Strong analytical, troubleshooting, and problem-solving skills.
  • Excellent communication and collaboration skills.

Other Requirements

Work with customer directly on greenfield implementation project

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.