Who We Are
Artmac Soft is a technology consulting and service-oriented IT company dedicated to providing innovative technology solutions and services to Customers.
Job Description
Job Title : Senior Snowflake Data Engineer (AWS and ETL Specialist)
Job Type : FullTime/C2C/1099
Experience : 10 to 15 years
Location : Seattle, WA (Hybrid)
Responsibilities
- At least 10+ years of software development experience, and minimum 2 years of experience on Snowflake development in AWS
- Snowflake data engineers will be responsible for supporting data intelligence solutions around Snowflake Data Warehouse.
- A solid experience and understanding of architecting, designing and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse is a must.
- Snowflake SQL Writing SQL queries against Snowflake, developing scripts in python to do Extract, Load, and Transform data
- Hands-on experience with Snowflake utilities such as Snow SQL, Snow Pipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
- In-depth understanding of Data Warehouse/ODS, ETL concept and modelling structure principles
- Understanding data transformation and translation requirements and which tools to leverage to get the job done
- Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modelling.
- Experience gathering and analyzing system requirements
- Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflakes Snow SQL Writing SQL queries against Snowflake
- Experience with AWS terraforms
Qualification
- Bachelor's degree or equivalent combination of education and experience.