Production Specialist
Production Specialist
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
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 its configured with the correct parameters especially the Snowflake database name.
Backup and restore the reference database across dev demo and live environments using SQL Target parameters.
Integration Configuration- request and insert required IDs via ID Gatekeeper for integration scripts execute integration scripts in Snowflake (Dev) and SQL servers (Demo & Live).
Permissions Management- applying new dataset permissions across all environments & run auto grant release permission script in Live and coordinating with HDE Support for broader access.
Quality Assurance- conducting QA in Dev and Demo before proceeding to live and validating data integrity and ensure no significant drop in row counts compared to previous releases.
Defines and updates documentation as necessary to maintain database quality.
Serves as first escalation point for issue resolution and keeps track of said issues.
Performs ongoing analysis and evaluation of existing processes with the objective of providing continuous improvements.
Coordination and collaboration with various stakeholders globally.
Job Qualifications:
Bachelors degree in information technology Information Systems Software/Computer Engineering or equivalent with minimum of four (4) years of experience related to IQVIA production and development or experience with applications mentioned below.
Proficient in SQL- ability to write queries to manipulate and retrieve data understand basic to intermediate SQL syntax and structure.
Knowledgeable to the following applications/tools/systems:
Must have-Microsoft SQL Server Management Studio (18) Visual Studio 2022 Snowflake Gitlab ID Gatekeeperand;
Nice to have - JIRA ARA
Version Control Proficiency- Manage changes in code collaborate with others and maintain a history of project development understanding in basic Git terminology (commit create branch merge clone push pull)
Proficient in Microsoft Excel for data entry analysis (eg macro functions formula etc.)
Proficient in written and oral communication skills with a customer service focused approach and stakeholder management.
Ability to proactively identify complex problems and needs and develop solutions/recommendations to solve problems.
Amenable to work on Hybrid set up in Mckinley Taguig
Amenable to work on Mid shift as well as night shift if needed.
IQVIA is a leading global provider of clinical research services commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more at
Required Experience:
IC
Employment Type
Full-Time
