US Citizen

Green Card

EAD (OPT/CPT/GC/H4)

H1B Work Permit

Corp-Corp

W2-Permanent

W2-Contract

Contract to Hire

Consulting/Contract

UG :- - Not Required

PG :- - Not Required

No of position :- ( 1 )

Post :- 19th Nov 2025

Telecom domain is preferred

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