Senior Python Developer - Snowflake & Cloud Data Engineering

Synechron Technologies; Bengaluru; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

Synechron Technologies is seeking a Senior Python Developer with Snowflake expertise to design, build, and optimize scalable cloud-based data solutions. You will focus on Python development, Snowflake data warehousing, ETL/ELT pipelines, and SQL optimization to support reporting, analytics, and BI initiatives.

You'll collaborate with architects, analysts, and business stakeholders, mentor junior team members, and help advance data engineering standards while ensuring data quality, security, and

Qualifications

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

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.

Skills

Python development

Snowflake data warehouse

Advanced SQL

ETL/ELT pipelines

Pandas

NumPy

PySpark

Airflow

Matillion

Informatica

Azure Data Factory

Git & REST API

Education

Bachelor's degree in Computer Science/IT/Data Engineering

Tools

Snowflake

dbt

Docker

Kubernetes

Matillion

Informatica

Azure Data Factory

Apache Airflow

AWS

Google Cloud

Git

REST API

Job description

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

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

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

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

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 .