27 Aug
|
Zorba AI
|
Bengaluru
27 Aug
Zorba AI
Bengaluru
We are looking for an experienced Snowflake / SQL Developer with 6-10 years of experience in Data Engineering, Data Warehousing, ETL/ELT development, and cloud-based data platforms.
The ideal candidate should have strong hands-on expertise in Snowflake and Advanced SQL , with experience in developing scalable data warehouse solutions, building ETL/ELT pipelines, optimizing queries, implementing data security, and supporting analytics and reporting requirements.
Experience with AWS and Python is preferred but not mandatory.
Key Responsibilities
- Design, develop, and maintain scalable Snowflake data warehouse solutions .
- Develop complex and optimized SQL queries, stored procedures, functions, and data transformations .
- Work extensively with Snowflake databases, schemas, tables, views, stages, warehouses, and file formats.
- Develop and maintain ETL/ELT data pipelines for batch and incremental data processing.
- Implement and manage Snowflake Streams, Tasks, and Snowpipe .
- Perform SQL and Snowflake query optimization and performance tuning .
- Implement data loading,
transformation, validation, and reconciliation processes.
- Design and maintain data models including Star Schema, Snowflake Schema, fact and dimension tables .
- Implement appropriate Snowflake security, RBAC, and access controls .
- Troubleshoot data pipeline failures and performance issues.
- Collaborate with Data Engineers, Architects, Analysts, and business stakeholders.
- Follow Git, CI/CD, Agile, and DevOps practices.
- Develop Python scripts for automation and data processing where required.
- Work with AWS services such as S3, Glue, IAM, and Lambda where applicable.
- Prepare technical documentation and participate in knowledge-sharing activities.
Required Skills
- 6+ years of experience in Data Engineering, ETL, or Data Warehousing.
- Solid hands-on experience with Snowflake .
- Excellent proficiency in Advanced SQL .
- Strong knowledge of:
- Complex joins
- CTEs
- Subqueries
- Window
📌 Snowflake+AWS_Expert (Bengaluru)
🏢 Zorba AI
📍 Bengaluru