Engineer Sr Lead Software

Zensar Technologies; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Zensar Technologies in Pune seeks an expert SQL/SQL Server professional to design and tune queries for large, high‑volume datasets. The role emphasizes data integrity in transactional systems with experience in Capital Markets or Investment Banking platforms.

You will influence performance and reliability across critical data pipelines and partner with product and business stakeholders. The ideal candidate has hands-on SQL tuning, indexing, and partitioning skills, and can operate in a

Qualifications

• Expert-level SQL / SQL Server skills (query design, tuning, indexing, partitioning).
• Proven experience handling large, complex, high-volume datasets.
• Deep understanding of transactional systems and data consistency.
• Strong experience in Capital Markets / Investment Banking platforms.

Responsibilities

• Roles include developing and optimizing data queries for large datasets.
• Ensure data integrity and performance across transactional systems.

Skills

SQL Server

Large data handling

Transactional systems

Capital Markets

Job description

Job Description:

Required Skills & Expertise
Mandatory

Expert‑level SQL / SQL Server skills (query design, tuning, indexing, partitioning)
Proven experience handling large, complex, high‑volume datasets
Deep understanding of transactional systems and data consistency
Strong experience in Capital Markets / Investment Banking platforms

Good to Have

.NET / C# backend development experience
Exposure to microservices or service‑oriented architectures
Experience with batch processing, EOD / EOM jobs
Familiarity with Agile delivery and CI/CD practices

Soft Skills

Strong analytical and problem‑solving mindset
Ability to lead through influence and technical credibility
Excellent communication with business and technical stakeholders
Ownership mindset with focus on system reliability and performance

Responsibilities

Required Skills & Expertise
Mandatory

Expert‑level SQL / SQL Server skills (query design, tuning, indexing, partitioning)
Proven experience handling large, complex, high‑volume datasets
Deep understanding of transactional systems and data consistency
Strong experience in Capital Markets / Investment Banking platforms

Qualifications

Mandatory

Expert‑level SQL / SQL Server skills (query design, tuning, indexing, partitioning)
Proven experience handling large, complex, high‑volume datasets
Deep understanding of transactional systems and data consistency
Strong experience in Capital Markets / Investment Banking platforms

Good to Have

.NET / C# backend development experience
Exposure to microservices or service‑oriented architectures
Experience with batch processing, EOD / EOM jobs
Familiarity with Agile delivery and CI/CD practices

Soft Skills

Strong analytical and problem‑solving mindset
Ability to lead through influence and technical credibility
Excellent communication with business and technical stakeholders
Ownership mindset with focus on system reliability and performance

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 Zensarand 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.

Requirements: