Job
Description
Job Description: Job Title: Senior SQL Server Data Warehouse Specialist Location: Noida (Hybrid_WFO) 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. 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. 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. About Mirketa Inc. Mirketa Inc is a San Ramon, CA based business and IT consulting firm with a global delivery center located in Noida India. Mirketa provides business process consulting and automation services for Marketing, HR, Sales and DevOps processes. It implements ERP, DevOps tools, Salesforce & Microsoft Dynamics CRM solutions and builds customized applications on PHP, .NET, and force.com platform. Mirketa is a Salesforce Gold Consulting Partner that offers customized Salesforce integration services. Mirketa is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Over the last eleven years, we have managed over a thousand solution engagements where we helped our clients transform their businesses through better analytics, organizational process changes, and cloud CRM solutions. We have worked with companies of all sizes and types, including Start-Ups, Fortune 100, and government agencies. Over 80% of our business comes from our existing customers. We provide business and technology solutions using big data and cloud technologies, including Salesforce.com, Microsoft Dynamics, Marketo, and other platforms. Our business solutions include business modeling/business architecture and business analytics services for sales, marketing, human resources, and customer service areas. We provide implementation services for cloud CRMs (Salesforce.com and Microsoft Dynamics) and development services for Force.com and .NET platforms. We also set up business intelligence solutions for both traditional and big data technologies. What we believe inCore values While the business challenges that we cater to are complex, we make the process of problem-solving simple, transparent, and fun. Our corporate values and culture guide us to always do the right thing and our talented team enables us to deliver the right solutions to you. Our culture, values and people give us a competitive advantage over our competition. Agile values and practices We embrace agile values and practices. We trust and value people. Our development processes and tools provide complete transparency to our clients. With our distributed agile delivery model we deliver working applications in two week sprints. Result oriented Solutions to us mean focus and not just a tick-inthe-box exercise. We commit to solve business challenges and figure out the best ways to reach the desired outcome. Customer centric We are diligent about creating a pleasant experience for our clients. Our foundation lies in the ideologies of understanding the Clients requirements and delivering the best. Transparency and integrity We act with integrity and take pride in providing a transparent, authentic and long association to our customers. Creative We challenge our own thinking and come up with creative solutions that meet our customers needs. Our sincere interest in providing out-of-the-box solutions to our clients have always been appreciated. Fun and flexible We understand that each company has its unique needs and constraints. So we provide flexible options to structure the working engagement. We believe in working hard and playing hard so we make a conscious efort to make the work environment easy and fun for our employees and customers. We use the distributed agile delivery model for our development and configuration projects. Our U.S. Team executes product discovery, business, and technical architecture, user experience design, and project management. Our Offshore Team focuses on the development, testing, and configuration. Are you interested ? Upskilling on the current skill sets Opportunity to work with clients globally Culture of fun, performance, and meritocracy Attractive rewards & recognition program Opportunity to work at Onshore Client offices. Please fill in the details provided below:- Total Experience Experience as a SQL Server Data Warehouse - Experience as a ETL/SQL Server/Data warehousing Experience in T-SQL/Data Warehouse Knowledge in Azure cloud- Experience in Azure data factory Current CTC- Expected CTC- Notice period- Current Org. - Late working day- Job Location- Current Location- Are you good with Noida location-
