Snowflake Data Engineer -Dallas TX (day 1 Onsite) at Dallas, Texas, USA |
Email: [email protected] |
From: susmitha, yochana [email protected] Reply to: [email protected] Hello , Hope youre doing well!! Im a Recruiter with Yochana IT Solutions, a national IT staffing solutions provider with 14 plus years of experience delivering value to leading companies across the U.S and Canada. I'm currently staffing for an Snowflake Data Engineer Below you will find the job description, if you are qualified and interested please send me your Updated Word Document Resume. My apologies if this position is not an ideal fit, we'll keep you in mind for other suitable positions and referrals would be appreciate Role : Snowflake Data Engineer Location : Dallas TX (day 1 Onsite) Duration: Long Term Contract Resource with around 10+ years of experience in DWH area who can work independently Strong hands on SQL skills/ Stored procedures / writing complex queries Good knowledge of Data warehousing and all related concepts Hands on experience in Data Ingestion from different sources Exposure to any of the cloud DB (Snowflake/ Redshift) 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 SnowFlake 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 Datawarehouse exp Good to have python Should strong on SQL queries Kafka not must. Good to have Thanks & Regards, Susmitha Manda- Resource Specialist Yochana IT Solutions Inc. Email: [email protected] | Address : 23000 Commerce Drive, Farmington Hills, MI 48335 | www.yochana.com/ Please follow us on: USA | CANADA | INDIA Keywords: sthree database information technology Michigan Texas |
[email protected] View all |
Fri Feb 09 00:01:00 UTC 2024 |