Foundit - Snowflake/Python Developer (5-6 yrs)

Key Responsibilities :

Snowflake Development :

- Design, develop, and implement Snowflake data models, architecture, and analytics solutions.

- Build and optimize Snowflake data pipelines for efficient ETL and ELT processes.

- Migrate legacy RDBMS such as Teradata, Oracle to Snowflake for improved performance and scalability.

SQL & SnowSQL Expertise :

- Write, optimize, and debug complex SQL queries and SnowSQL scripts for Snowflake.

- Work with Snowflake Streams, Tasks, and Stages for efficient data movement and processing.

- Create and maintain External Tables for integration with other data sources.

Data Migration & Integration :

- Lead and support the migration of legacy data systems (Teradata, Oracle) to Snowflake.

- Translate complex business requirements into data workflows within Snowflake.

Data Handling and Optimization :

- Work with semi-structured data formats like XML and JSON in Snowflake.

- Perform query optimization and improve the performance of complex queries.

Python Scripting and Automation :

- Develop Python scripts to automate data tasks and integrate with Snowflake.

- Build custom Python applications and utilities for Snowflake-related data processing.

Snowflake Procedures and UDFs :

- Design and develop Snowflake Procedures and User Defined Functions (UDFs) for complex data transformations.

Collaboration and Stakeholder Management :

- Work closely with cross-functional teams to understand business requirements and provide effective solutions.

- Collaborate with other data engineers, analysts, and developers to integrate Snowflake solutions into existing workflows.

Required Skills & Experience :

Snowflake Development :

- Minimum 5 years of experience in Snowflake development, with a strong understanding of Snowflake architecture, SnowSQL, Snowpipe, and data warehousing.

Data Migration :

- Experience migrating data from legacy systems like Teradata and Oracle to Snowflake.

SQL Expertise :

- Strong knowledge of SQL, SnowSQL, and complex query optimization techniques.

Python Scripting :

- Experience in Python scripting for data processing and automation.

Data Handling :

- Hands-on experience with semi-structured data (XML, JSON) in Snowflake.

Procedure and UDF Development :

- Proven experience in creating Snowflake Procedures and UDFs for data transformation and complex business logic.

Additional Skills (Good to Have) :

- Knowledge or certification in Snowflake.

- Experience working with Snowflake Streams, Tasks, External Tables, and other Snowflake-specific features.

- Familiarity with data migration projects and best practices.

Preferred Qualifications :

Education :

- Bachelor's degree in Computer Science, Engineering, or a related field.

Certifications :

- Snowflake certification is highly preferred.

Communication Skills :

- Strong written and verbal communication skills for interacting with both technical and business teams