Position title
Snowflake Data Engineer
Description
- Location: DALLAS, TX
- # of Positions: 1
- Eligibility: Open
- Client Name / Domain: TELECOM
- Bill Rate: $65 per hour
- Employment Mode: Contract / Corp-to-Corp
- Contract Duration: 12+ mos. Contract
- Experience: 12+ years
- Skills: AWS S3, SNOWSQL, SNOWPIPE, AWS EC3, SNOWFLAKE, JSON, ORC, PARQUET, KAFKA
Client is looking for Snowflake Data Engineer preferably with Teleom Domain experience.
Responsibilities
- Implementing SCD Techniques like slowly changing dimensions (type1, type2 and type3).
- Use COPY/INSERT,PUT,GET commands for loading data into Snowflake tables from internal,external stages.
- Performance tuning of SnowFlake data warehouse with Query Profiler, Caching and Virtual data warehouse scaling
- Work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
- Loading to snowflake.
Qualifications
- 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.
- 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
Contacts
If you are interested in applying for this role, please send your updated resume to tpjobs@techpeople.us
Hiring organization
TechPeople
Employment Type
Contractor
Duration of employment
12 - 24 mos.
Industry
TELECOM
Job Location
Dallas, TX / C2C | ONSITE
Date posted
January 18, 2024
PDF Export
