19 Nov
|
AppTad Technologies
|
Noida
19 Nov
AppTad Technologies
Noida
Job Summary
We are looking for an experienced Microsoft Master Data Services (MDS) Developer / Consultant with strong expertise in implementing, configuring, developing, and maintaining enterprise Master Data Management (MDM) solutions using Microsoft SQL Server Master Data Services.
The ideal candidate should have hands-on experience in managing master data domains, designing data models, configuring business rules, developing staging processes, implementing data validation, and integrating MDS with enterprise applications and data platforms.
The candidate should have robust SQL Server, T-SQL, SSIS, data integration, and data governance experience.
Key Responsibilities
- Design, develop, configure, and maintain Microsoft Master Data Services (MDS) solutions.
- Create and manage MDS data models, entities, attributes, hierarchies, collections, and business rules.
- Configure domain-based master data management for Customer, Product, Vendor, Supplier, and other enterprise data domains.
- Implement data validation, business rules, workflows, and approval processes.
- Develop and maintain MDS staging processes for importing, validating, and loading master data.
- Work with SQL Server databases, stored procedures, views, functions, and complex T-SQL queries.
- Develop and maintain SSIS packages for master data integration and ETL processes.
- Integrate MDS with upstream and downstream enterprise applications, data warehouses, and reporting systems.
- Implement data quality checks, duplicate identification, standardization, and data cleansing processes.
- Manage data hierarchies, subscriptions, version management, and transaction management.
- Troubleshoot MDS performance issues, data loading failures, and integration errors.
- Support MDS administration, security configuration, user access management, and role-based permissions.
- Collaborate with business stakeholders, data architects, and application teams to understand master data requirements.
- Maintain technical documentation, data mapping specifications,
and operational procedures.
Mandatory Technical Skills
- Strong hands-on experience with Microsoft SQL Server Master Data Services (MDS).
- Good understanding of Master Data Management (MDM) concepts and implementation.
- Experience creating and managing MDS models, entities, attributes, hierarchies, and business rules.
- Strong SQL Server and advanced T-SQL programming skills.
- Experience with SQL Server Integration Services (SSIS).
- Knowledge of MDS staging tables, staging processes, and subscription views.
- Experience in data integration, ETL/ELT, and master data migration.
- Understanding of data quality, data governance, and data standardization.
- Experience with MDS security, permissions, and role-based access control.
Good-to-Have Skills
- Experience with Microsoft SQL Server 2016 / 2017 / 2019 / 2022.
- Knowledge of SQL Server Reporting Services (SSRS) and Power BI.
- Experience with Microsoft Excel Add-in for MDS.
- Knowledge of SQL Server Agent and scheduled ETL jobs.
- Experience integrating MDS with ERP, CRM, SAP, and other enterprise applications.
- Knowledge of Microsoft Azure data services, Azure Data Factory, and cloud-based data platforms.
- Exposure to enterprise data governance and data stewardship processes.
- Experience in MDS migration, upgrade, and modernization initiatives.
Required Experience
- 5–15 years of experience in SQL Server / Data Engineering / Master Data Management.
- Minimum 3+ years of hands-on experience with Microsoft Master Data Services (MDS).
- Experience in end-to-end MDS implementation, configuration, integration, and production support.
- Strong analytical, troubleshooting, and problem-solving skills.
Key Competencies
- Master Data Management (MDM)
- Microsoft Master Data Services (MDS)
- SQL Server & T-SQL
- SSIS & ETL Development
- Data Modeling & Data Integration
- Data Quality & Data Governance
- Business Rules & Data Validation
- Master Data Migration
- Production Support & Performance Tuning
Pay: ₹2,500,000.00 - ₹3,500,000.00 per year
Work Location: Hybrid remote in Noida, Uttar Pradesh
📌 Microsoft MDS Consultant (Noida)
🏢 AppTad Technologies
📍 Noida