Role description

Role Description:

* Responsible for leading and implementing very large scale data intelligence solutions around Snowflake Data Warehouse
* Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, data sharing, cross platform database replication, failover, virtual warehouse sizing, query performance tuning, zero copy clone, time travel and understand how to use these features
* Experience in Teradata- Snowflake migration or other database migrations and ETL experience.
* Experience with AWS or Azure, data storage and management technologies such as blob, S3, google cloud storage, etc.
* Translate requirements for BI and Reporting to Database design and reporting design
* Expertise in Snowflake – Data modelling techniques like dimensional modelling/3NF/ DataValult
* Must be able to build an ELT solution using Snowflake/SnowSQL and implementing stored procedures and standard DWH+ETL concepts
* Proficiency in RDBMS, complex T-SQL/SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot (Must Have)
* Prior experience in RFP/Pre-Sales/Solutioning/Project Estimation
* Must have performed customer facing roles along with stakeholder management
* DB/DW migration experience
* Working knowledge of Python scripting language.

Knowledge, Experience and Skills

Required Skills:
* Minimum 2+ years of experience in Snowflake (Must Have)
* 4+ years of experience in RDBMS like Teradata/Oracle /SQL Server/PostgreSQL
* 4+ years of experience in ETL Tools like Informatica/Teland/ADF/Matillion/Any other ETL tools
* Any other ETL tools 1+ year of experience in other cloud platforms (AWS/GCP/AZURE)

Preferred Skills:

* Excellent presentation and communication skills, both written and verbal Ability to problem solve and architect in an environment with unclear requirements

Location -UAE

Nikita is a recruitment consultant with international recruitment experience across the MENA region. She specialises in projects in IT, Digital Transformation and Net Zero industries including Nuclear.

Nikita Seth