Snowflake Data Engineer
oraclecloud
|
Experience: 8+ Years
|
Pune
|
Posted 14 hours ago
Job Description
- Snowflake Development
- Design and implement efficient and bi-temporal schemas leveraging micro-partitioning and clustering keys for optimal performance.
- Develop and optimize SQL queries, stored procedures, and Snowpark-based transformations.
- Implement query performance tuning and cost optimization strategies.
- Data Engineering
- Build and maintain Python-based ETL/ELT pipelines for sourcing historical market data from internal and external providers.
- Integrate with quant libraries to identify data quality issues and validate risk inputs.
- Data Quality & Remediation
- Detect and remediate common data quality issues (gaps, stale data, outliers).
- Implement algorithms for gap-filling, back-filling, and anomaly correction to ensure data is fit for VaR and SVaR calculations.
Essential Experience/ Skills:
- 8+ years of hands-on experience in developing applications using Relational Databases and Big-data platforms.
- Snowflake Expertise
- Strong experience in schema design, micro-partitioning, clustering, and query optimization.
- Proficiency in Snowpark and stored procedures.
- Expert-level SQL for complex queries and performance tuning.
- Programming
- Advanced Python for data engineering and integration.