Production Specialist

IQVIA


Date: 7 hours 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

Transportation Supervisor

PH Global Jet Express Inc. (J&T Express), Taguig
15 hours ago
In-charge of the overall truck fleet operation. Responsible for coordinating the usage of motor vehicles in the yard which includes fleet maintenance records, GPS monitoring, and all pre-trip and post-trip documentation. The Fleet Supervisor leads and manages the dispatch team, drivers and related field employees.Qualifications Bachelor's degree of any course, preferably in Logistics/Operations At least 3 year(s) of working experience...

Incidents & Escalations Specialist

Zendesk, Taguig
1 day ago
Who we're looking forWe are seeking a dedicated Incident and Escalations Specialist to join our vibrant team in the Philippines. This outstanding opportunity is perfect for an individual passionate about improving customer experience and driving flawless incident resolution processes. You will be a key player in building scalable incident and escalation management processes, ensuring our operations run smoothly and efficiently.What...

Manager Solution Architecture

DXC Technology, Taguig
1 day ago
Job Description: Essential Job Functions: • Manage and lead architecture projects, ensuring they meet project objectives and timelines. • Collaborate with solution architects to deliver technical solutions that align with architectural standards. • Participate in the definition and implementation of architectural standards and guidelines. • Provide technical guidance for architecture projects, helping to resolve complex issues. • Evaluate and recommend...