Data Engineer

Overview:

Description:

The ideal candidate would be responsible for designing, developing, testing, deploying, and maintaining enterprise-level applications using the Snowflake platform.

• Knowledge of SQL language and cloud-based technologies

• Profound knowledge and hands-on experience in SnowflakePlatform Architecture.

• Proficient in SQL for data validation and querying, withexperience in Snow SQL scripts.

• Excellent understanding of Snowflake Internals, Stages, andIntegrations in Snowflake.

• Extensive experience in T-SQL stored procedures and complexquery development.

• Design and implement features for identity and accessmanagement

• Implement novel query optimization, major security competencieswith encryption

• Solve performance issues and scalability issues in the system

• Experience in SQL query performance tuning, includingproficiency with Query Profiler, Micro-partition pruning, Data spilling and understanding of optimizer and execution plans.

• Experience with productionized data ingestion and processingpipelines using Snow SQL

• Data warehousing concepts, data modeling, metadatamanagement

• Create, test, and implement enterprise-level apps with Snowflake

Desirable Skills:

• Experience in integrating Snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus.

• Strong understanding of CI/CD workflows, unit testing and integration testing, and deployment patterns.

• Strong ability in documenting design solutions effectively.

• Familiarity with a variety of tools including Jira, ServiceNow, Confluence, GIT, and Flyway.

• Experience in Azure cloud services including Azure SQL MI and ADF, particularly in database and data management contexts is plus