| DBT Snowflake Lead onsite in WI at Green Bay, Wisconsin, USA |
| Email: [email protected] |
| From: Akriti Srivastava, Urbench [email protected] Reply to: [email protected] Job Title: DBT Snowflake Lead Location: Green Bay, WI (Onsite) Duration: Long Term Contract Visa: USC, GC and H4-EAD Job Description: Extensive experience in DBT DBT CLI DBT Cloud GitHub version control and repository knowledge DBT scripting to design develop PLSQL processes to perform complex ELT processes and data pipeline build In Depth experience on DBT concepts such as Models Materialization Sources Seeds Snapshots Packages Hooks Exposures Analyses Proven experience on End to End DBT project implementation technical solutions including architecting designing and development and guiding team as needed Experience in identifying architecture gaps that can improve availability performance and security for productions systems and working towards resolving those issues along with development team Working experience in Snowflake use of Snowflake stored producers schema modelling performance tuning etc Good Understanding and knowledge on CI CD process and GitHub DBT Snowflake integrations Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions Troubleshooting problem solving and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge on stored procedures Use DBT to build and manage ETL processes for ingesting transforming and loading data into Snowflake Strong experience building ELT pipelines batch and streaming in Snowflake cloud warehouse Experience in implementation of data transformation framework database design troubleshooting and maintenance Proficient in SQL Stored Procedures Functions Triggers in Snowflake Oracle Have working experience in batch load process using any of the database Oracle SQL Snowflake Should have knowledge on creating producer and consumer in Kafka use of Kafka Connectors setup security while data is in Topic Nice to have skills Working experience in Reporting technologies like Tableau or Power BI and Exposure to Cloud Analytics native services of AWS AZURE GCP etc Excellent communication and presentation skills Well versed with Waterfall Agile Scrum and similar project delivery methodologies Experienced in internal as well as external stakeholder management Regular engagement with teams for status reporting and routine activities Possess ownership right from start to finish Keywords: continuous integration continuous deployment business intelligence green card Wisconsin DBT Snowflake Lead onsite in WI [email protected] |
| [email protected] View all |
| Thu Aug 01 00:37:00 UTC 2024 |