Job Description

Key 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.
• Mentor junior engineers and contribute to establishing engineering best practices within the team.

Required Skills

• 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.
• Experience designing and implementing data warehouse/data lake architectures on Snowflake.
• 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.
• Familiarity with version control (Git) and CI/CD practices for data pipelines.

Good to Have

• Experience with orchestration tools such as Airflow, dbt, or Azure Data Factory.
• Exposure to cloud platforms (AWS, Azure, or GCP) alongside Snowflake.
• Knowledge of data governance, security, and compliance frameworks.
• Prior experience working in Agile/Scrum delivery environments.

Education : Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field (or equivalent practical experience).

Key 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.
• Mentor junior engineers and contribute to establishing engineering best practices within the team.

Education : Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field (or equivalent practical experience).

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.