MS SQL Senior Technical Lead

Technology, Data & Digital · Data, AI & Analytics · Data Engineering · Backend · Software Engineering

In short

We are seeking an experienced SQL Lead Developer with strong expertise in SSIS and advanced Stored Procedure development to lead enterprise data engineering and integration initiatives. The role involves designing and managing ETL pipelines, database solutions, and performance-optimized SQL systems, while leading a team and ensuring delivery of scalable, high-performance data solutions.

Responsibilities

Design, develop, and optimize complex stored procedures, functions, triggers, and views.
Develop high-performance T-SQL queries and ensure optimal execution plans.
Implement indexing strategies, query optimization, and performance tuning.
Ensure database integrity, consistency, and security.
Design, develop, and maintain SSIS packages for data extraction, transformation, and loading (ETL).
Build scalable ETL frameworks to integrate data from multiple source systems.
Implement data transformations, cleansing, and validation rules.
Debug and optimize SSIS packages for performance and reliability.
Manage deployment, scheduling, and monitoring of ETL jobs.
Design and maintain data warehouse structures and data models.
Define source-to-target mappings and transformation logic.
Ensure efficient data pipelines supporting reporting, analytics, and BI.
Support integration of structured and semi-structured data sources.
Collaborate with architects, business analysts, and stakeholders to translate requirements into solutions.
Drive technical design discussions and ensure alignment with enterprise architecture.
Identify and resolve database performance bottlenecks.
Optimize SQL queries, indexes, and ETL pipelines.
Monitor database health and implement tuning strategies.
Improve system scalability, throughput, and response times.
Handle production issues, ETL failures, and data inconsistencies.
Conduct root cause analysis and implement long-term fixes.
Support system releases and ensure smooth deployments.
Maintain SLAs for data processing and availability.
Maintain documentation for database schemas, ETL processes, and data mappings.
Ensure adherence to data governance, security, and compliance policies.
Implement audit controls and logging mechanisms.

Requirements

Strong expertise in SQL Server (T-SQL).
Advanced experience with Stored Procedures, Functions, Views, Triggers.
Hands-on expertise in SSIS (SQL Server Integration Services).
Deep understanding of ETL processes and data integration.
Strong experience in query tuning and performance optimization.
Experience with SSRS (Reporting Services).
Experience with SSAS (Analysis Services).
Exposure to Power BI / Tableau for reporting.
Knowledge of data warehousing concepts (star schema, dimensional modeling).
Experience with data migration and data integration across systems.
Exposure to big data or cloud data platforms (Azure/GCP/AWS).
Experience with Python / PowerShell / .NET (optional but preferred).
Understanding of SSIS scripting (C# / VB Script tasks).
Experience with version control systems (Git, TFS).
CI/CD exposure for database deployments.
Experience with job schedulers and automation tools.
Knowledge of Backup & recovery, Indexing and partitioning, Database security and access control.
8–12+ years of experience in SQL Development / Data Engineering.
Strong analytical and problem-solving skills.
Excellent communication and stakeholder management.
Ability to lead cross-functional teams.
High attention to detail and data accuracy.
Experience in Banking / Financial Services / Regulatory reporting (preferred).
Knowledge of large-scale enterprise data platforms (preferred).
Familiarity with data governance and compliance (e.g., GDPR, audit controls) (preferred).

Desired Qualifications

Experience with Python / PowerShell / .NET (preferred).
Experience in Banking / Financial Services / Regulatory reporting (preferred).
Knowledge of large-scale enterprise data platforms (preferred).
Familiarity with data governance and compliance (e.g., GDPR, audit controls) (preferred).

Skills

SQL ServerT-SQLStored ProceduresSSISETLQuery TuningPerformance OptimizationSSRSSSASPower BITableauData WarehousingStar SchemaDimensional ModelingPythonPowerShellNETGitTFSGDPR

#SQL#SSIS#ETL#Data Engineering#Technical Lead

About HCLTech

Supercharging progress through technology and innovation

HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered around digital, engineering and cloud, 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 September 2022 totaled $12.1 billion. To learn how we can supercharge progress for…

See all open jobs at HCLTech Read more about HCLTech Website