onsite
Snowflake Developer - Marktine Technology Solutions Pvt Ltd
Software Engineer
Snowflake Developer responsible for writing complex SQL queries, building ETL pipelines with Python and Unix scripts, and managing Snowflake utilities such as SnowSQL, SnowPipe, Tasks, and Streams. Requires deep knowledge of data warehousing concepts, OLTP/OLAP modeling, and experience with ETL tools.
About the role
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
Originally posted on Himalayas