Production Specialist (SQL)

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, and live environments using S...