Exp- 7+ years
Notice- Immediate only
Location- Bangalore/Hyderabad
Strong expertise in Snowflake Dynamic Tables.
Excellent understanding of Data Modeling (Dimensional Modeling, Star Schema, Snowflake Schema).
Strong understanding of Oracle Supply Chain (SCM) and Manufacturing data models, including Safety Stock planning, Inventory Analytics, and Bill of Materials (BOM) with multi-level BOM structures and component hierarchies.
Collaborate with business stakeholders, data architects, BI developers, and application teams to understand requirements and deliver high-quality data solutions.
Oracle
Strong experience in Snowflake Performance Optimization, including query tuning, clustering, micro-partition pruning, warehouse optimization, caching, and cost optimization
Strong experience in developing Snowflake Stored Procedures using JavaScript and Snowflake Scripting
Advanced SQL programming and complex query development
Hands-on experience with Snowflake Tasks, Streams, and Change Data Capture (CDC)
Experience with Snowpipe for automated data ingestion
Strong experience in ETL/ELT design and implementation
Expertise in query optimization, troubleshooting, and performance tuning
Experience implementing Snowflake Security, including Users, Roles, RBAC, Grants, and Access Control
Knowledge of warehouse sizing, workload management, concurrency handling, and cost optimization
Experience orchestrating Tasks, Streams, and Dynamic Tables for end-to-end data pipelines
Experience working on enterprise-scale Data Warehouse and Lakehouse implementations
Strong understanding of Git for source code management, branching, merging, and version control
Experience with CI/CD and deployment automation is an added advantage