Data Engineer with Snowflake

Position : Data Engineer with Snowflake

Location : Dallas TX (day 1 Onsite)

Duration : 1 Year

Required Skills: Big Data, ETL, DWH, SQL, Python, AWS, Telecom Domain.

Job Details

• Telecom domain is needed
• 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