Mirketa - Senior Data Warehouse Specialist - ETL/ SQL Server

Job Title : Senior SQL Server Data Warehouse Specialist 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 5-7 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. Location : Noida 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 : - Bachelor's degree in Computer Science, Information Systems, or a related field. - 5-7 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 customers Preferred 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)

Location: noida, IN

Posted Date: 4/10/2025