Hi I can assist you with this project. I have written complex and dynamic ETL solutions in many roles including my current role. Which is a SSIS ETL developer for a large hospital in the UK. I move In these roles, i have written packages with environment variables, event handler alert messages logging and catalog deployments migrating large data tables (as large as 2 million rows of clinical data ) from various sources to destinations.
I have also designed and implemented complex TSQL procedures, functions, cursors triggers and more as part of ETL solutions as well as for data mart, OLTP and OLAP (or end user delivery reporting and analytics) data models creation.