Senior Specialist - Snowflake

UAS Continuum Infotech; Mumbai; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

UAS Continuum Infotech seeks a data engineer in Mumbai to build, optimize and support data pipelines using Python, SQL and JavaScript on Snowflake & AWS. You will develop frameworks with stored procedures and Python, while coordinating with DevOps to standardize deployments.

Ideal candidates have strong Snowflake experience, data warehousing expertise, and a track record in real-time streaming and UI data tooling. BS/MS in CS is required; Mumbai-based on-site work is expected.

Qualifications

• BS/MS in Computer Science or equivalent.
• Strong communication and problem-solving abilities.
• Experience with data warehousing (OLTP/OLAP, data modeling).
• Proficient with Snowflake features and Python data tooling.
• Experience in ETL tools and real-time data streaming a plus.

Responsibilities

• Build, optimize & support data pipelines using Python, SQL & JavaScript on Snowflake & AWS.
• Develop and maintain data-warehousing frameworks with stored procedures and Python.
• Collaborate with DevOps to standardize deployment of Python applications.
• Resolve overnight batch issues escalated by offshore team.
• Review code and ensure adherence to development guidelines and best practices.
• Act as an individual contributor and collaborate with global teams.

Skills

Data warehousing

Python

SQL

Snowflake

Pandas/Numpy

JavaScript

DevOps

ETL tools

Real-time streaming

UI libraries

Shell scripting

Communication

Team collaboration

Education

BS/MS in Computer Science

Tools

boto3

Snowpark

Snowflake Python Connector

Pandas

Numpy

Job description

Responsibilities

• 1. Building, Optimizing & supporting data pipelines utilizing Python, SQL & Java Script utilizing Snowflake & AWS
• 2. Building & maintaining frameworks using stored procedures & Python to simplify design patterns
• 3. Working with DevOps team to standardize deploying python application
• 4. Resolving overnight batch issues escalated by offshore team
• 5. Perform Code review for other team members
• 6. Has an eye for details, adhere to software development guidelines and adopt best practices
• 7. Ability to work as a Individual contributor & collaborating with Global team

Requirements

Skills Required

• Good Communication, & problem-solving abilities
• Strong experience with Data Warehousing- OLTP, OLAP, Dimension, Facts, Data Modeling
• Strong experience in using boto3, pandas, numpy, pyarrow, snowflake python connector & Snowpark
• Experience with Snowflake including SQL, Pipes, Stream, Tasks, Time Travel, Data Sharing, Query

Optimization

• Experience with Scripting language in Snowflake including SQL Stored Procs, Java Script Stored Procedures & Python UDFs
• Understanding of Snowflake Internals & experience in integration with Reporting & UI applications

Advantageous Skills

• Familiarity with building Reports using reporting tools such as Tableau
• High level understanding of ETL tools such as Informatica
• Familiarity with batch schedulers such as Active Batch
• Experience with Real time data streaming using message queues
• Experience in Python building UI interface with libraries such as Matplotlib, plotly, streamlit
• Devops experience specially utilizing Azure Devops for deploying Python applications
• Experience with scripting such as Power Shell, Unix Shell
• Experience working in Financial services preferably buy side firms

Academic Requirements

• BS/MS degree in Computer Science or equivalent education