Production Specialist

Overview IQVIA Taguig, National Capital Region, Philippines Join to apply for the Production Specialist role at IQVIA 1 week ago Be among the first 25 applicants 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 and related metrics with previous releases using dataset documentation or ims-schemas & environment provisioning. Provision ETL databases across Dev, Demo, and Live environments using the provisioning script. Assign appropriate roles and permissions. Reference Database creation, configuration and loading, including running a specific SSIS package on the staging server via the Integration Services Catalog, ensuring it is 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 coordinate with HDE Support for broader access. Quality Assurance - conduct QA in Dev and Demo before proceeding to live and validate data integrity to ensure no significant drop in row counts compared to previous releases. Define and update documentation as necessary to maintain database quality. Serve as first escalation point for issue resolution and track issues. Perform ongoing analysis and evaluation of existing processes with the objective of providing continuous improvements. Coordinate and collaborate with various stakeholders globally. Job Qualifications Bachelor’s 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 in the following applications/tools/systems: Must have - Microsoft SQL Server Management Studio (18), Visual Studio 2022, Snowflake, Gitlab, ID Gatekeeper and; 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 (e.g., 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 setup in McKinley, Taguig. Amenable to work on mid shift as well as night shift if needed. Company 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 Details Seniority level: Not Applicable Employment type: Full-time Job function: Management and Manufacturing Industries: Pharmaceutical Manufacturing Referrals increase your chances of interviewing at IQVIA by 2x Get notified about new Production Specialist jobs in Taguig, National Capital Region, Philippines. Additional related roles and location updates may be shown here. #J-18808-Ljbffr