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 datab...