Python Developer – Snowflake, ETL/ELT, Advanced SQL & Cloud Data Engineering

Synechron; India; On-site; INR 3,000,000 - 4,200,000; Full time

Job summary

Synechron seeks a Senior Python Developer with Snowflake expertise to build, optimize, and support scalable cloud-based data solutions. The role focuses on Python development, Snowflake data warehousing, ETL/ELT pipelines, SQL optimization, and data integration.

The position requires 7+ years of Python development experience, strong Snowflake knowledge, and proficiency with cloud platforms (AWS/Azure/GCP). You will design end‑to‑end data pipelines, mentor peers, and collaborate with

Qualifications

• 7+ years of Python development experience.
• Strong Snowflake data warehouse experience.
• Advanced SQL, stored procedures, and query optimization.
• ETL/ELT pipeline development.
• Proficiency with Pandas, NumPy, PySpark.
• Experience with Airflow, Matillion, Informatica, or Azure Data Factory.
• Experience with cloud platforms (AWS, Azure, or Google Cloud).
• Git and REST API integration.
• Certifications in Snowflake, cloud technologies, or data engineering are a plus.

Responsibilities

• Design, develop, and maintain Python and Snowflake data pipelines.
• Build and optimize ETL/ELT workflows for large-scale data.
• Create Snowflake databases, schemas, tables, views, procedures, streams, and tasks.
• Develop data models for reporting, analytics, and BI.
• Optimize SQL queries and compute usage in Snowflake.
• Integrate APIs, databases, cloud storage, and external systems.
• Implement data quality, security, governance, and compliance controls.
• Troubleshoot production issues and improve pipeline reliability.
• Mentor team members and contribute to data engineering standards.

Skills

Python development

Snowflake data warehouse

Advanced SQL

ETL/ELT pipeline development

Pandas/NumPy/PySpark

Airflow/ETL tools

Cloud platform experience (AWS/Azure/G

Education

Bachelor’s degree in CS/IT or related field

Snowflake/Python/cloud certifications

Tools

dbt

Docker

Kubernetes

Kafka

CI/CD tooling

Job description

Job Summary

Synechron is seeking a Senior Python Developer with Snowflake expertise to build, optimize, and support scalable cloud-based data solutions. The role focuses on Python development, Snowflake data warehousing, ETL/ELT pipelines, SQL optimization, and data integration.

Software Requirements

Required:

• - 7+ years of Python development experience
• - Strong Snowflake data warehouse experience
• - Advanced SQL, stored procedures, and query optimization
• - ETL/ELT pipeline development
• - Pandas, NumPy, and PySpark
• - Apache Airflow, Matillion, Informatica, or Azure Data Factory
• - AWS, Azure, or Google Cloud experience
• - Git and REST API integration

Preferred:

• - Snowflake Streams, Tasks, Snowpipe, and dynamic tables
• - dbt, Docker, Kubernetes, and CI/CD
• - Kafka or other data-streaming platforms
• - Data quality and monitoring tools

Overall Responsibilities

• Design, develop, and maintain Python and Snowflake data pipelines.
• Build and optimize ETL/ELT workflows for large-scale data.
• Create Snowflake databases, schemas, tables, views, procedures, streams, and tasks.
• Develop data models for reporting, analytics, and business intelligence.
• Optimize SQL queries, Snowflake warehouses, clustering, and compute usage.
• Integrate APIs, relational databases, cloud storage, and external systems.
• Implement data quality, security, governance, and compliance controls.
• Troubleshoot production issues and improve pipeline reliability.
• Collaborate with architects, analysts, developers, and business stakeholders.
• Mentor team members and contribute to data engineering standards.

Technical Skills

Programming:

• - Essential: Python, advanced SQL, scripting, testing, and error handling.
• - Preferred: Java, Scala, or asynchronous Python.

Databases/Data Management:

• - Essential: Snowflake, data modeling, dimensional modeling, schemas, tables, views, stored procedures, Streams, Tasks, and query tuning.
• - Preferred: Snowpipe, dbt, NoSQL, and data cataloging.

Cloud:

• - Essential: AWS, Azure, or Google Cloud.
• - Preferred: Cloud storage, Docker, Kubernetes, and infrastructure automation.

Frameworks and Libraries:

• - Essential: Pandas, NumPy, PySpark, and an orchestration tool.
• - Preferred: Great Expectations, FastAPI, Flask, or Kafka.

Development Tools:

• - Essential: Git, CI/CD, Agile, code reviews, automated testing, logging, and monitoring.
• - Preferred: Docker, SonarQube, infrastructure-as-code, and observability tools.

Security:

• - Essential: Access control, encryption, secure credentials, data privacy, and secure API integration.
• - Preferred: OAuth 2.0, OpenID Connect, Snowflake masking policies, and row-access policies.

Experience Requirements

• 7+ years of professional Python development experience.
• Strong experience in Snowflake, data engineering, ETL/ELT, SQL, and data modeling.
• Experience integrating APIs, databases, cloud storage, and external systems.
• Experience supporting production data platforms and resolving performance issues.
• Financial services or regulated-industry experience is preferred.
• Equivalent technical experience, training, or relevant projects may be considered.

Day-to-Day Activities

• Develop Python code, SQL scripts, Snowflake objects, and orchestration workflows.
• Build data ingestion, transformation, validation, and publishing processes.
• Monitor pipelines, data quality, query performance, and warehouse utilization.
• Investigate failed jobs, data issues, and production incidents.
• Participate in planning meetings, design discussions, code reviews, and retrospectives.
• Collaborate with technical teams and business stakeholders.
• Prepare technical documentation and support materials.
• Make implementation decisions within approved architecture and security standards.

Qualifications

Bachelor’s degree in computer science, information technology, data engineering, or a related field, or equivalent practical experience. Snowflake, cloud, Python, or data engineering certifications are preferred. Completion of Synechron security, compliance, and role-specific training is required. Ongoing learning in Python, Snowflake, cloud technologies, security, and data governance is expected.

Professional Competencies

• Strong analytical and problem-solving skills.
• Clear communication with technical and non-technical stakeholders.
• Effective collaboration and mentoring abilities.
• Ability to manage priorities and meet delivery commitments.
• Adaptability to changing requirements and technologies.
• Focus on automation, data quality, security, performance, and efficient resource use.

SYNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more. All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile‑first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,500+, and has 58 offices in 21 countries within key global markets. For more information on the company, please visit our website or LinkedIn community. At Synechron, we are committed to integrating sustainability into our business strategy, ensuring responsible growth while minimizing environmental impact. Employees play a key role in driving our sustainability initiatives, from reducing our carbon footprint to fostering ethical and sustainable business practices across global operations. All positions are required to adhere to our Sustainability and Health Safety standards, demonstrating a commitment to environmental stewardship, workplace safety, and sustainable practices.