| Snowflake Data Engineer // Location :-Dallas TX (day 1 Onsite) //60$ max rate (PLEASE DONT SEND DATA ENGINEER PROFILES WITH OUT SNOWFLAKE EXP) at Dallas, Texas, USA |
| Email: [email protected] |
| (Please share candidate location and expected rate and visa with resume) Snowflake Data Engineer Location :-Dallas TX (day 1 Onsite) Job Details Resource with around 8 to 9 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 quries Kafka not must. Good to have -- Pragathi Madunala Senior Recruiter [email protected] +1 732 466 2860 Ext : Avance Consulting |1170 Rt 22 | Bridgewater Suite#301 | New Jersey 08807| Disclaimer: This e-mail communication and any attachments to it are confidential and privileged to Avance Consulting and are strictly intended only for the personal and confidential use of the designated recipient(s) named above. If you are not the intended recipient of this message, you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited and may be unlawful. Please notify the sender immediately and destroy all copies of this message along with all attachments there to. sender notified by Mail Track for Gmail Click to remove -- Keywords: sthree database information technology Texas Snowflake Data Engineer // Location :-Dallas TX (day 1 Onsite) //60$ max rate (PLEASE DONT SEND DATA ENGINEER PROFILES WITH OUT SNOWFLAKE EXP) [email protected] |
| [email protected] View all |
| Tue Jul 09 20:05:00 UTC 2024 |