Job Title : Tech Lead SQL Server Data Warehouse
Location : Noida
Work mode : Hybrid
Job Overview :
We are seeking a highly skilled and experienced Senior SQL Server Data Warehouse Specialist to join our dynamic team. The ideal candidate will have 8+ years of hands-on experience in designing, developing, and maintaining data warehouse solutions using SQL Server. This role requires a deep understanding of data modeling, ETL processes, and performance tuning to ensure optimal data storage and retrieval.
Key Responsibilities :
- Design and implement efficient data warehouse architectures using SQL Server.
- Develop, test, and deploy ETL processes to ingest data from various sources.
- Create and maintain data models, schemas, and mappings.
- Optimize database performance through indexing, partitioning, and query tuning.
- Collaborate with business analysts and stakeholders to gather requirements and ensure data solutions meet business needs.
- Support existing SQL Datawarehouse solutions
- Ensure data accuracy, consistency, and integrity within the data warehouse.
- Monitor and troubleshoot data warehouse performance issues and provide timely resolutions.
- Implement data security measures and ensure compliance with data governance policies.
- Mentor and guide junior team members in best practices and data warehousing techniques.
Qualifications :
Bachelors degree in computer science, Information Systems, or a related field.8+ years of experience working with SQL Server and data warehousing.Proficiency in T-SQL, SSIS, SSAS, and SSRS.Strong understanding of data modeling concepts and techniques.Experience with ETL tools and processes.Knowledge of performance tuning and optimization techniques.Excellent problem-solving and analytical skills.Strong communication and interpersonal skills.Ability to work independently and as part of a team.Ability to work directly with US based customersPreferred Qualifications :
Experience with cloud-based data warehousing solutions (e.g., Azure SQL Data Warehouse, Amazon Redshift).Knowledge of data visualization tools (e.g., Power BI, Tableau).Certification in SQL Server or related technologies.ref : hirist.tech)