Production Specialist

IQVIA


Date: 3 weeks ago
City: Taguig
Contract type: Full time
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 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:

  • 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 to 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 (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 https://jobs.iqvia.com

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Management Accounting Team Lead

Merck Group, Taguig
8 hours ago
Work Your Magic with us!Ready to explore, break barriers, and discover more? We know you’ve got big plans – so do we! Our colleagues across the globe love innovating with science and technology to enrich people’s lives with our solutions in Healthcare, Life Science, and Electronics. Together, we dream big and are passionate about caring for our rich mix of...

Research Analyst - IRWIN Assistant

FactSet, Taguig
13 hours ago
FactSet creates flexible, open data and software solutions for over 200,000 investment professionals worldwide, providing instant access to financial data and analytics that investors use to make crucial decisions.At FactSet, our values are the foundation of everything we do. They express how we act and operate, serve as a compass in our decision-making, and play a big role in how...

Recruitment Specialist (Thai/Bahasa Bilingual)

Unilever, Taguig
1 day ago
About UnileverWith 3.4 billion people in over 190 countries using our products every day, Unilever is a business that makes a real impact on the world. Work on brands that are loved and improve the lives of our consumers and the communities around us. We are driven by our purpose: to make sustainable living commonplace, and it is our belief...