Snowflake Developer (Architect)

VidPro Consultancy Services; Pune City; Hybrid; INR 80,000 - 140,000; Full time

Job summary

An established industry player is seeking a talented Snowflake Developer to join their Data Engineering team in Pune. This role offers a unique opportunity to work with cutting-edge technologies in a hybrid environment, where you will design and maintain data pipelines, optimize data architectures, and collaborate with cross-functional teams. The ideal candidate will have over 8 years of experience in Data Warehousing and a strong command of SQL, Snowflake, and related tools. If you're passionate about data and eager to contribute to innovative projects, this position is perfect for you.

Qualifications

• 8+ years of experience in Data Engineering with a focus on Data Warehousing.
• Expertise in Snowflake and SQL for data integration and ELT processes.

Responsibilities

• Develop and maintain data pipelines using Snowflake and DBT.
• Collaborate with stakeholders to translate business needs into technical solutions.

Skills

Snowflake

SQL

Informatica

Power BI

Data Warehousing

Data Integration

Data Modeling

Python

Fivetran

DBT

Education

Graduate degree in Computer Science

Graduate degree in Statistics

Graduate degree in Informatics

Tools

PowerCenter

Airflow

Azure

Tableau

Sigma Computing

Job description

1 week ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

VidPro Consultancy Services provided pay range

This range is provided by VidPro Consultancy Services. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

Exp: 8 - 14 Yrs
Work Mode: Hybrid
Location: Bangalore, Chennai, Kolkata, Pune, and Gurgaon
Primary Skills: Architect, Snowflake, Snowpipe, SQL, DWH, Power BI, ETL, and Informatica.

We are seeking a skilled Snowflake Developer with a strong background in Data Warehousing (DWH), SQL, Informatica, Power BI, and related tools to join our Data Engineering team. The ideal candidate will have 8+ years of experience in designing, developing, and maintaining data pipelines, integrating data across multiple platforms, and optimizing large-scale data architectures. This is an exciting opportunity to work with cutting-edge technologies in a collaborative environment and help build scalable, high-performance data solutions.

Key Responsibilities

• Minimum of 5+ years of hands-on experience in Data Engineering, with a focus on Data Warehousing, Business Intelligence, and related technologies.
• Data Integration & Pipeline Development: Develop and maintain data pipelines using Snowflake, Fivetran, and DBT for efficient ELT processes (Extract, Load, Transform) across various data sources.
• SQL Query Development & Optimization: Write complex, scalable SQL queries, including stored procedures, to support data transformation, reporting, and analysis.
• Data Modeling & ELT Implementation: Implement advanced data modeling techniques, such as Slowly Changing Dimensions (SCD Type-2), using DBT. Design and optimize high-performance data architectures.
• Business Requirement Analysis: Collaborate with business stakeholders to understand data needs and translate business requirements into technical solutions.
• Troubleshooting & Data Quality: Perform root cause analysis on data-related issues, ensuring effective resolution and maintaining high data quality standards.
• Collaboration & Documentation: Work closely with cross-functional teams to integrate data solutions and create clear documentation for data processes, models, and pipelines.

Skills & Qualifications

• Expertise in Snowflake for data warehousing and ELT processes.
• Strong proficiency in SQL for relational databases and writing complex queries.
• Experience with Informatica PowerCenter for data integration and ETL development.
• Experience using Power BI for data visualization and business intelligence reporting.
• Experience with Fivetran for automated ELT pipelines.
• Familiarity with Sigma Computing, Tableau, Oracle, and DBT.
• Strong data analysis, requirement gathering, and mapping skills.
• Familiarity with cloud services such as Azure (RDBMS, Data Bricks, ADF), with AWS or GCP.
• Experience with workflow management tools such as Airflow, Azkaban, or Luigi.
• Proficiency in Python for data processing (other languages like Java, Scala are a plus).

Education

Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or a related quantitative field.