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

synechron; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Synechron is seeking a Senior Python Developer with Snowflake expertise in Bengaluru to design, build, and optimize scalable data solutions. The role focuses on Python development, Snowflake data warehousing, ETL/ELT pipelines, and data integration across cloud platforms.

You will work on optimizing SQL, building robust pipelines, and mentoring teammates while collaborating with architects, analysts, and stakeholders to deliver reliable data products.

Qualifications

• 7+ years of professional Python development experience.
• Strong 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.

Responsibilities

• Design, develop, and maintain Python and Snowflake data pipelines.
• 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.

Skills

Python

Snowflake

SQL

ETL/ELT

Pandas/NumPy

PySpark

Airflow

Cloud platforms

Education

Bachelor's degree in CS/IT

Tools

Git

REST API

CI/CD

Docker

Kubernetes

Matillion

Informatica

Azure Data Factory

Snowflake Streams/Tasks

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.

S YNECHRON'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 appl