Data Warehouse job assurance
Budget: ₹1,500 – ₹12,500 INR
Role: Data Warehouse Developer
Data Warehouse Expert Needed –data modeling - SCD Types Implementation & ETL development
Description:
The project focused on Pensioner Concessions data, and I’m seeking a data warehouse expert to provide support and guidance as I need to implement and enhance key components of existing solution.
Key Areas I Need Help With:
Data model design
Converting dimension tables from SCD Type 1 to SCD Type 2
Designing and modifying ETL processes (using SSIS)
Careful Implementing change as I am working on live data and historical data preservation
Updating data models and ensuring consistency across layers (Landing → DW → DM)
Writing efficient SQL queries and troubleshooting ETL data issues
Sorting Mapping
Tech Stack:
SQL Server (SSMS)
SSIS (SQL Server Integration Services)
Azure DevOps (for version control)
Visual Studio (for SSIS development)
I am looking for:
Someone who can guide me during development (like a mentor connecting twice or thrice in a week for few hours. Flexible as per expert timings)
We can connect on zoom or team viewer for taking control of my system when we are connecting
Data Warehouse Expert Needed –data modeling - SCD Types Implementation & ETL development
Description:
The project focused on Pensioner Concessions data, and I’m seeking a data warehouse expert to provide support and guidance as I need to implement and enhance key components of existing solution.
Key Areas I Need Help With:
Data model design
Converting dimension tables from SCD Type 1 to SCD Type 2
Designing and modifying ETL processes (using SSIS)
Careful Implementing change as I am working on live data and historical data preservation
Updating data models and ensuring consistency across layers (Landing → DW → DM)
Writing efficient SQL queries and troubleshooting ETL data issues
Sorting Mapping
Tech Stack:
SQL Server (SSMS)
SSIS (SQL Server Integration Services)
Azure DevOps (for version control)
Visual Studio (for SSIS development)
I am looking for:
Someone who can guide me during development (like a mentor connecting twice or thrice in a week for few hours. Flexible as per expert timings)
We can connect on zoom or team viewer for taking control of my system when we are connecting