Senior Support Lead (IN)
HCLTech
HCLTech
Join our team as a Senior Support Lead, focusing on Navision-based data migrations, SQL database operations, and data quality initiatives. This role is crucial for enhancing our execution capacity, allowing the Data Architect to concentrate on strategic design and governance. You'll drive key operational and delivery activities, ensuring seamless data management and reporting.
This position offers an exciting opportunity to manage complex data transformations for acquisitions, mergers, and clinic closures. You will be responsible for profiling, cleansing, transforming, and validating data, supporting all phases from rehearsal to post-load validation. The role also involves maintaining and troubleshooting SQL Server and Azure SQL environments, monitoring performance, and addressing security vulnerabilities.
Execute data migrations for business changes like acquisitions, mergers, and closures. Profile, cleanse, transform, load, and reconcile data, ensuring accuracy through validation and rehearsals.
Maintain and troubleshoot SQL Server and Azure SQL databases, focusing on health, performance, query tuning, and security.
Identify and resolve data quality issues, including completeness, integrity, and consistency, collaborating with business teams.
Develop and maintain T-SQL queries, data extracts, and Azure data flows for various recipients, ensuring data accuracy and protection.
Utilize Git for source control and Azure DevOps practices. Document solutions, investigate incidents, automate tasks, and enhance migration runbooks for improved control and efficiency.
A strong foundation in relational databases and intermediate to advanced T-SQL skills are essential. Extensive experience with SQL Server and Azure SQL, including performance tuning, is required.
Familiarity with Azure Data Factory, Synapse, and the broader Azure data suite is necessary. Proven hands-on experience in data migration, cleansing, transformation, and reconciliation is critical.
Proficiency in using Microsoft Excel for analysis and validation is expected. Experience with Git/source control and disciplined database development practices is a must.
Candidates should possess clear communication skills and confidence in working with both business and technical stakeholders. Experience with PowerShell, Power BI, Azure DevOps pipelines, and Dynamics NAV/365 Business Central are desirable.
HCLTech
IT Consulting