MS sql server
Must-Have Skills (Mandatory) 1. Extensive experience with the MS SQL Server suite - SQL, SSIS, and Power BI. 2. Advanced SQL expertise: Strong skills in scripting complex business logic using T-SQL. 3. SSIS development: Demonstrated track record in designing, developing, and deploying high-performance SSIS packages. 4. ETL/ELT architecture: Proven skills in building and managing robust ETL/ELT pipelines using SSIS, Azure Data Factory, and Microsoft Fabric. 5. Data modelling: Proficient in designing high-performance relational and non-relational schema models. Experience with data normalisation, dimensional modelling, and NoSQL schema design. 6. Analytics and data warehousing: Prior involvement in data analytics, data warehousing projects; and experience in delivering interactive Power BI dashboards. 7. Autonomous delivery: Ability to deliver results as an independent contributor, with minimal supervision. 8. Stakeholder management: Excellent communication and stakeholder management skills, including collaboration with business executives. 9. Data Governance: Practical experience implementing strict data governance measures—encryption, masking, and implementing data security techniques, including Row-Level and Column-Level Security (RLS/CLS). Good to Have (Optional) 1. Experience developing complex data transformation workloads using Python and PySpark. 2. Exposure to management of SQL Server (2019+), Azure SQL, Azure Virtual Machines, and other Azure Services. 3. Experience in deploying/integrating GPT models via Azure AI Foundry/Cognitive Services. 4. Familiarity with Salesforce, Jitterbit, CData, Dbamp. At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus. Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself. We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status. Apply To This Job