Mandatory Skills: Snowflake dbt Oracle PLSQL
- 10 years experience in design and implementation of scalable secure and highperformance snowflake architectures
- Strong handson experience in developing and managing endtoend data pipelines with Snowflake and dbt
- Perform architecture reviews and assess system design for scalability maintainability and performance
- Analyze and optimize the performance of Snowflake stored procedures queries and overall workload
- Ensure adherence to Snowflake best practices in data modelling storage and transformation
- Strong proficiency in dbt Data Build Tool for transformation and modelling
- Extensive experience and deep understanding of Oracle PLSQL including performance tuning indexing stored procedures packages and triggers
Desirable
- Good to have development experience with Apache Airflow
Mandatory Skills: ERWIN MS SQL Server TOAD Data Modeler Data Vault (ODS) Modeling ANSI-SQL Dimensional Data Modeling ER Studio Microsoft Fabric GCP BigQuery Redshift Snowflake Databricks TOAD