DE&A - Core - Data Engineering - Microsoft SQL Server

Job Title

Job Description

At least 5+ years experience writing advanced stored procedures using Microsoft SQL. SQL proficiency should include ability to read and understand complex stored procedures and be able to translate data flow to others as well as the ability to create complex data flows using only SQL stored procedures.

Experience designing and building relational and dimensional data models to support business intelligence projects. Experience in a DWH environment with large tables a plus.

Experience pulling data from an Event driven application and modeling that data into relational models. Experience parsing JSON to materialize data a plus.

5+ years experience evaluating vague or incomplete business requirements and being able to translate into a working business intelligence data model which can be used for decision support, analytics and reporting.

Responsibilities

At least 5+ years experience writing advanced stored procedures using Microsoft SQL. SQL proficiency should include ability to read and understand complex stored procedures and be able to translate data flow to others as well as the ability to create complex data flows using only SQL stored procedures.

Experience designing and building relational and dimensional data models to support business intelligence projects. Experience in a DWH environment with large tables a plus.

Experience pulling data from an Event driven application and modeling that data into relational models. Experience parsing JSON to materialize data a plus.

5+ years experience evaluating vague or incomplete business requirements and being able to translate into a working business intelligence data model which can be used for decision support, analytics and reporting.

Qualifications

At least 5+ years experience writing advanced stored procedures using Microsoft SQL. SQL proficiency should include ability to read and understand complex stored procedures and be able to translate data flow to others as well as the ability to create complex data flows using only SQL stored procedures.

Experience designing and building relational and dimensional data models to support business intelligence projects. Experience in a DWH environment with large tables a plus.

Experience pulling data from an Event driven application and modeling that data into relational models. Experience parsing JSON to materialize data a plus.

5+ years experience evaluating vague or incomplete business requirements and being able to translate into a working business intelligence data model which can be used for decision support, analytics and reporting.

About Us

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.

Job Info

Job Identification 139261

Posting Date 01/13/2026, 09:45 AM

Job Shift Day Job

Locations Plot No. 4, MIDC, Kharadi, Pune, Maharashtra, 411014, IN

Work from Anywhere Yes

Minimum Experience (In Years) 5

Maximum Experience (In Years) 8