SQL Server Master Data Services Technical Lead - Data Engineering

SQL - MDS - Technical Lead-Data Engg

Area(s) of responsibility

- Strong experience in SQL Server Data Warehouse development (tables, views, stored procedures).

- Advanced SQL querying and performance tuning using execution plans and indexing.

- Hands-on experience with Master Data Services (MDS) models, hierarchies, and business rules.

- Working knowledge of Data Quality Services (DQS) for data cleansing and matching.

- Experience supporting ETL and reporting teams (MSBI POD) with data validation and fixes.

- Strong understanding of data modeling and dimensional concepts.

 

Good to Have

 

- Exposure to SSIS packages for data movement and transformations.

- Experience working in Agile / POD-based delivery models.

 

 

Mandatory Skillset / experience:

 

5+ Years of hands-on experience in SQL Server Data Warehouse development with expertise in writing complex SQL queries, views, and stored procedures.

2+ Years of proven skills in SQL performance tuning, indexing, and execution plan analysis.

Experience Level

Senior Level