Position title

Mobile Device Developer / Lead

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 USA

Duration of employment

10-12 mos.

Industry

TELECOM

Job Location

Plano, TX (Hybrid) / C2C

Date posted

November 3, 2024

Valid through

April 5, 2024

PDF Export