Snowflake Architect - Manager

8 - 10 years

30 - 35 Lacs

kochi

Posted:-1 days ago| Platform:

Apply

Skills Required

erwin sql iam xml saml json mysql sem api etl oauth communication skills snowflake masking sql queries oracle configuring azure blob rbac presentation skills amazon rds sql server snowflake sql cassandra integration sns user management aws

Work Mode

Work from Office

Job Type

Full Time

Job Description

Snowflake Security & Integration
Experience in configuring Snowflake Security integration services like OAuth, SAML.
Expertise in configuring Snowflake API, Storage, and Notification integration services.
Strong knowledge of Snowflake RBAC management, user management, and role management.
Data Masking & Access Control
Experience in configuring Dynamic Masking Policies and Tag-Based Masking Policies.
Database & Warehouse Management
Experience in creating and managing databases, schemas, and Snowflake warehouses.
Data Migration & ETL
Expertise in migrating SQL queries/DDLs from Oracle, MySQL, MS SQL, Cassandra to Snowflake SQL.
Experience in automating file loading from AWS S3/Azure Blob using Snowpipe and Snowflake ingestion best practices.
Strong background in transforming semi-structured data using Snowflake Stored Procedures.
Experience in loading structured and semi-structured data into Snowflake from AWS S3/Azure Blob.
Data Pipelines & Frameworks
Experience in developing pipelines using a metadata-driven framework.
Hands-on experience in database design & data modeling using Erwin tool.
Data Governance & Validation
Implemented data validation, error handling, auditing, and reconciliation mechanisms.
Performance Optimization & Reporting
Experience in optimizing Snowflake performance for efficient querying and storage.
Ability to generate reports (CSV, JSON, XML) using Snowflake tasks and streams and ETL tools.
Data Integration & Scheduling
Experience in integrating and scheduling end-to-end data ingestion, profiling, and transformation flows in Snowflake.
Hands-on experience with Snowflake Data Sharing (inbound and outbound).
Advanced Snowflake Features
Experience in creating and managing External Tables, Iceberg Tables, Dynamic Tables, UDFs, UDTFs, and Procedures.
Implemented functionality for ServiceNow request generation in failure cases.
Cloud & Orchestration Tools
Hands-on experience with AWS (S3, SQS, SNS, EC2, RDS, IAM) and Azure (Blob Storage, IAM).
Experience in workflow orchestration using Apache Airflow.

Skills and attributes for success

Use an issue-based approach to deliver growth, market, and portfolio strategy engagements for corporates
Strong communication, presentation and team building skills and experience in producing high quality reports, papers, and presentations.
Experience in executing and managing research and analysis of companies and markets, preferably from a commercial due diligence standpoint.

More Jobs at EY

Core Audit Manager- Bangalore

Chennai, Bengaluru

5 - 8 yrs

INR 20 - 32 Lacs

UK Payroll - Senior

Bengaluru

4 - 8 yrs

INR 3 - 8 Lacs

UK Payroll- Advanced Analyst

Bengaluru

2 - 4 yrs

INR 1 - 5 Lacs

Associate - SaT - TMT - SaT - TCF - Transaction Diligence - New Delhi

Delhi

Experience: Not specified

Salary: Not disclosed

Executive - Assurance - CHS - ASU - Audit - Audit Services - Ahmedabad

Ahmedabad, Gujarat

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.