Job description
Category: IT Services
Location:
Responsibilities:
Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix, Python, etc. to do Extract, Load, and Transform data
Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
In-depth understanding of Data Warehouse/ODS, ETL concept and modeling structure principles
Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
Experience gathering and analyzing system requirements
Good working knowledge of any ETL tool (Informatics or SSIS)
Good to have familiarity with data visualization tools (Tableau/Power BI)
Ability to effectively function in a cross-team’s environment
Good to have exposure to AWS / Azure Data ecosystem
Requirements
Skills Required:
Well versed in Snowflake architecture concepts - Cloud Services, Virtual Warehouse, Storage etc.
Good exposure to performance tuning, cost optimization on snowflake.
Exposure to snowflake system hierarchy and schemas/Tables/Views/Stages
Good knowledge of data modelling concepts like dimensional modelling and DWH concepts like change data capture (CDC)
Must have ETL E2E experience in documentation, development, testing & deployment to Production
Ability to provide production support for Data Warehouse issues such data load problems, transformation/translation problems etc.
Worked in Offshore / Onsite Engagements and collaborated across time zones
DetailsOriginally posted on Himalayas
Who can apply
Eligible countries: United States. Accepted UTC offsets: UTC-10, UTC-9, UTC-8, UTC-7, UTC-6, UTC-5, UTC+14. Review the full description for employer-specific work authorization, residency and schedule requirements.