Title: MDS - DQS - Technical Lead-Data Engg
Area(s) of responsibility
Must Have
- 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.
Hands-on experience with Master Data Services (MDS) for master data management and Data Quality Services (DQS)