Production Specialist (ETL)

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

IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism.