Snowflake with Oracle PLSQL Consultant

  • Pittsburgh, PA
  • Posted 8 hours ago | Updated 2 hours ago

Overview

On Site
Accepts corp to corp applications
Contract - 10 Month(s)

Skills

Snowflake with Oracle PLSQL

Job Details

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, Google Cloud Platform BigQuery, Redshift, Snowflake, Databricks, TOAD

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.