Zensar
Create a free account
One signup unlocks everything for this job:
- Apply to this job and track your application
- See your personalized profile match score
- Generate an AI cover letter for this role
Pune · On-site · 3-5 Yrs · Aug 31
Information Technology Support Services · 5001 to 10000 Employees · Pune, India
Zensar is a leading digital solutions & technology services company, helping businesses thrive in a world of constant change. Looking for a workplace where employees realize their full potential, are recognized for the impact they make, & enjoy the company of the people they work with? Welcome to Zensar! With a strong track record of innovation, investment in digital solutions, & commitment to client success, at Zensar, you can help clients achieve new thresholds of performance. A subsidiary of RPG Group, Zensar has its HQ in India, & offices across the world, including Mexico, South Africa, the UK, & the US. Visit www.zensar.com to know more.
Hiring: Engineering
What employees say
+ Good learning opportunities and supportive team environment.
− Some processes can be improved for better communication.
More reviews on the company profile.
Interview experience · Senior Software Engineer
The interview process was smooth and comfortable. The questions were simple, relevant, and easy to understand. The interviewer was friendly, knowledgeable, and supportive, making the overall conversation engaging, positi
Very_easy difficulty · Bangalore Rural · 982 reports
More interview insightsJob description
Overview
Key Responsibilities
Responsibilities
- Design, develop, and optimize ETL/ELT pipelines using Snowflake, SQL, and PySpark to support analytics and reporting needs.
- Write complex, high-performance SQL queries and stored procedures; tune queries and warehouse configurations for cost and performance efficiency.
- Develop and maintain SnowSQL scripts for data loading, transformation, automation, and orchestration within the Snowflake environment.
- Build and manage data ingestion pipelines using Python and PySpark for large-scale structured and unstructured data processing.
- Implement data modeling, schema design, and data quality/validation frameworks within Snowflake.
- Manage Snowflake objects such as warehouses, databases, schemas, roles, and access controls, following best practices for security and governance.
- Troubleshoot and resolve performance bottlenecks, data pipeline failures, and data quality issues.
- Collaborate with business analysts, data scientists, and other engineering teams to understand requirements and translate them into robust technical solutions.
- Document technical designs, data flows, and standard operating procedures clearly for team and stakeholder use.
- Actively use AI-assisted tools (e.g., Copilot, ChatGPT, Claude, or similar) to accelerate coding, debugging, documentation, and query optimization tasks.
Qualifications
- Strong proficiency in SQL, including complex joins, window functions, query optimization, and performance tuning.
- Solid working knowledge of Python, particularly PySpark, for data processing and transformation at scale.
- Strong Snowflake development experience, including SnowSQL, Snowpipe, Streams, Tasks, and Snowflake's role-based access control model.
- Excellent verbal and written communication skills, with the ability to explain technical concepts to non-technical stakeholders.
- Demonstrated ability to effectively use AI/GenAI tools to improve productivity in coding, testing, and documentation.
- Exposure to cloud platforms (AWS, Azure, or GCP) alongside Snowflake.
- Knowledge of data governance, security, and compliance frameworks.
Verify Python for this role
Free PRACTICE for Python adds a verified skill signal that can boost how roles like this rank for you — optional, not required to browse or apply.
Sign up — verify Python free →Want match scores and deeper insight? Create a free candidate profile