Technical Specialist (IN)
HCLTech
HCLTech
Join a dynamic team as a Technical Specialist focusing on Microsoft Fabric SQL Development. This role is instrumental in building a sophisticated custom Master Data Management (MDM) Platform. You will leverage cutting-edge Microsoft Fabric capabilities, advanced SQL development, and robust data integration techniques to create high-performance backend data solutions.
Your expertise in data warehousing and ETL/ELT processes will be crucial. Collaborating closely with architects, frontend developers, data stewards, and business stakeholders, you will architect scalable solutions for master data management, governance, reporting, and analytics, ensuring data integrity and accessibility.
This opportunity involves a direct engagement with customers on a greenfield implementation project, offering a unique chance to shape a critical data platform from its inception. We are looking for individuals passionate about data innovation and delivering impactful results.
Design, develop, and maintain sophisticated backend data solutions utilizing Microsoft Fabric.
Craft and optimize SQL objects, including stored procedures, views, functions, and data pipelines.
Build and manage data ingestion, transformation, and integration processes within the Microsoft Fabric ecosystem.
Develop data models that effectively support Master Data Management (MDM), governance, reporting, and analytics needs.
Create and manage Fabric Lakehouses, Warehouses, and Data Pipelines to ensure data flow and accessibility.
Implement rigorous data quality controls, validation protocols, and reconciliation procedures.
Optimize database performance and query execution for demanding enterprise workloads.
Seamlessly integrate data from a diverse array of source systems, applications, APIs, and external platforms.
Collaborate effectively with frontend, reporting, and business teams to deliver reliable, scalable data services.
Ensure robust data security, access control, governance, and compliance measures are in place.
Proactively troubleshoot data-related issues, performance bottlenecks, and production support incidents.
Actively participate in solution design, testing, deployment, and release management activities.
A Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related field is required.
Possess a minimum of 5 years of hands-on experience in SQL development and data engineering.
Demonstrate significant practical experience with Microsoft Fabric development and administration.
Exhibit strong proficiency in T-SQL development and query optimization techniques.
Proven experience in building and maintaining effective data pipelines and ETL/ELT processes.
Solid understanding of data warehousing principles and dimensional modeling is essential.
Experience working with large-scale enterprise data platforms is a must.
Demonstrated ability to integrate data from multiple diverse source systems.
Familiarity with data governance, master data concepts, and data quality processes is necessary.
Exhibit strong analytical, troubleshooting, and problem-solving capabilities.
Possess excellent communication and collaboration skills for effective teamwork.
HCLTech
IT Consulting