Snowflake Developer

Skills

Eight years of programming skills experience in database development Experience with Snowflake cloud-based data warehouse Experience developing data ingestion processes using Kafka RabbitMQ etc. Experience with Snowflake SnowSQL and writing use defined functions Experience developing Python based code that reads/writes data into databases Strong understanding of various data formats such as CSV XML JSON etc. 5+ years? experience developing ETL ELT and Data Warehousing solutions 5+ years? experience developing SQL scripts and stored procedures that processes data from databases 5+ years? experience in loading source system data extracts into data warehouse 5+ years? experience with batch job scheduling and identifying data/job dependencies 3-5 years? experience AWS cloud Azure or Google cloud Ability to learn or existing familiarity with Git-based source code management systems (UI and/or CLI) Education Master?s degree in Computer Science Electrical Engineering or related and 7 years of relevant work experience. Bachelor?s degree in Computer Science Electrical Engineering or related and 10 years of relevant work experience.

Description

Develop ETL pipelines in and out of data warehouse using combination of Python and Snowflake?s SnowSQL

Design and develop data movements using Snowflake capabilities like Snow SQL, Tasks, Streams, Time travel, Data sharing and stored procedures

Use Big Data technologies such as Kafka, Snowflake and related technologies to store, curate, process and publish datasets for consumption by downstream business users and applications

Integrate on-premise infrastructure with public cloud (AWS, AZURE) infrastructure

Participates in the development, improvement and maintenance of database applications

Works with IT partners and user community for project definition; works on multiple platforms and multiple projects concurrently

Performs independent technical analysis, debugging and troubleshooting as well as code and unit testing for complex scope modules, and projects

Multidisciplinary work supporting data pipelines, data warehouses and reporting services

Actively test and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.

Managing database security, including account administration, password policy, data encryption, network encryption, and firewall rules.

Ability to translate requirements for BI and Reporting to Database design and reporting design

Ability to understand data pipelines and modern ways of automating data pipeline using cloud based and on-premise technologies

Collaborate with business and IT partner teams to develop business capability and technology roadmaps, staying abreast of emerging strategic capabilities and data availabilities.

Superior time management skills and project management fundamentals (schedule and resourcing)