Job Description
Job Responsibilities:
Executes dataset onboarding process where data assets are onboarded from various sources but primarily from CDD (Central Data Distribution)/ Data IQ.
Configure and execute the ETL script using the specified database name and create a new ETL database instance.
Perform post-load analysis by comparing row counts & etc. with previous releases using dataset documentation or ims-schemas & environment provisioning
Provision ETL databases across Dev, Demo, and Live environments using the provisioning script.
Assigning appropriate roles and permissions.
Reference Database creation, configuration and loading, this includes running a specific SSIS package on the staging server via the Integration Services Catalog, ensuring it's configured with the correct parameters, especially the Snowflake database name.
Backup and restore the reference database across dev, demo, ...