Expert in Automating Data Vault with dbt
Budget: ₹4,000 – ₹7,000 INR
I'm looking for a skilled developer experienced in dbt Datavault to automate the process of building a data vault model from a staging database.
Key Project Requirements:
- implement automatedv for my project
- Utilizing SQL Server for staging and data vault using automatedv package which is already available.
Steps:
- extract the tables and column information in the form or CSV or any
- user will enter it's mapping for datavault model like this column will be satelite or hub like that.
- using that metadata.csv dbt package should run and create data vault model or load data to them. And maintain history.
- if someone added new stagging table then it will be added into our CSV and I'd we provided mapping for datavault model then it will be automatically added to the datavault model sonthe code should be dynamic.. and all these things are handled in automatedv.
We just need to implement it
Your role will be crucial in automating the creation of the dbt package for the data vault model. The dbt package should be designed to automatically load data from the staging database to the data vault.
Ideal Freelancer:
Knowledge in automatedv
- Proficient in dbt Datavault, automate
- Strong experience with SQL Server
- Skilled in implementing advanced automation with real-time monitoring and alerts
This is a great opportunity for someone with a passion for data engineering and automation to contribute to a cutting-edge project. If you have what it takes, I look forward to hearing from you.
Key Project Requirements:
- implement automatedv for my project
- Utilizing SQL Server for staging and data vault using automatedv package which is already available.
Steps:
- extract the tables and column information in the form or CSV or any
- user will enter it's mapping for datavault model like this column will be satelite or hub like that.
- using that metadata.csv dbt package should run and create data vault model or load data to them. And maintain history.
- if someone added new stagging table then it will be added into our CSV and I'd we provided mapping for datavault model then it will be automatically added to the datavault model sonthe code should be dynamic.. and all these things are handled in automatedv.
We just need to implement it
Your role will be crucial in automating the creation of the dbt package for the data vault model. The dbt package should be designed to automatically load data from the staging database to the data vault.
Ideal Freelancer:
Knowledge in automatedv
- Proficient in dbt Datavault, automate
- Strong experience with SQL Server
- Skilled in implementing advanced automation with real-time monitoring and alerts
This is a great opportunity for someone with a passion for data engineering and automation to contribute to a cutting-edge project. If you have what it takes, I look forward to hearing from you.