Associate Tech Specialist Job Dallas Maine USA,IT/Tech

Location: Dallas

Position :

- Snowflake Data Engineer

Location :

- Denver CO / Dallas TX (day 1 Onsite)

Having 3+ years of Relevant experience in working with Snowflake cloud data warehouse and exposure to AWS S3.

Implementing SCD Techniques like slowly changing dimensions (type1, type2 and type3).
Experience in working with AWS S3 and Snowflake cloud data warehouse.
Good exposure in Snowflake Cloud Architecture and SnowSQL and SNOWPIPE for continuous data ingestion.
Handling large and complex data sets like JSON, ORC, PARQUET, CSV files from various sources like AWS S3.
Hands-on experience in bulk loading and unloading data into Snowflake tables.
Experience in writing complex SQL scripts using Statistical Aggregate functions and Analytical functions to support ETL in snowflake cloud data warehouse.
Used COPY/INSERT,PUT,GET commands for loading data into Snowflake tables from internal,external stages.
Experience with performance tuning of Snow Flake data warehouse with Query Profiler, Caching and Virtual data warehouse scaling
Extensively worked in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
Hands on exp loading to snowflake.
Knowledge on redshift (Good to have)
Knowledge on AWS EC2, lambda
Strong Data warehouse exp
Good to have python
Should strong on SQL quries
Kafka not must. Good to have

To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction