Senior Specialist - Python

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

Job summary

UAS Continuum Infotech in Mumbai is seeking a skilled data engineer to build, optimize and support data pipelines using Python, SQL and JavaScript with Snowflake and AWS. You will also help design reusable frameworks using stored procedures and Python.

Join a global team as an individual contributor, perform code reviews, follow development guidelines and collaborate with DevOps to standardize deployments. Strong experience in data warehousing, Snowflake features and BI tools is preferred.

Qualifications

• Good communication and problem-solving abilities.
• Strong experience with Data Warehousing including OLTP, OLAP, dimension, facts and data modeling.
• Strong experience with boto3, pandas, numpy, pyarrow, Snowflake Python connector and Snowpark.
• Experience with Snowflake including SQL, Pipes, Stream, Tasks, Time Travel, Data Sharing and Query.
• DevOps experience deploying Python applications (Azure DevOps).
• Experience with Python libraries for data and UI (Matplotlib, Plotly, Streamlit) and scripting (PowerShell, Unix Shell).
• Financial services experience preferred.

Responsibilities

• Build, optimize and support data pipelines using Python, SQL and JavaScript with Snowflake and AWS.
• Build and maintain frameworks using stored procedures and Python to simplify design patterns.
• Collaborate with DevOps to standardize deploying Python applications.
• Resolve overnight batch issues escalated by offshore team.
• Perform code reviews for other team members.
• Adhere to software development guidelines and adopt best practices.
• Work as an individual contributor and collaborate with a global team.

Skills

Communication

Problem solving

Data warehousing

Boto3

Pandas

Numpy

PyArrow

Snowflake connector

Snowpark

SQL

Snowflake SQL

Snowflake Pipes

Snowflake Tasks

Time Travel

Data Sharing

Azure DevOps

Matplotlib

Plotly

Streamlit

Python

Unix Shell

PowerShell

Tableau

Informatica

ActiveBatch

Real-time data streaming

Education

BS/MS in Computer Science

Tools

Tableau

Informatica

ActiveBatch

Azure DevOps

PowerShell

Unix Shell

Python

Snowflake

SQL

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