Job Description

Technical:

• Extensive experience in PL/SQL and Unix/Linux Shell Scripting
• Strong hands-on experience in procedures, functions and packages in Oracle
• Hands-on experience in writing queries and good knowledge on views, materialized views
• Should have experience in analytical functions, hierarchical queries , pivot and unpivot
• Strong hands-on experience in query performance tuning, explain plan, hints and parallel query
• Working experience in fact and dimension table
• Expertise in external table, SQL loader and also table partition, sub-partition and indexing
• Knowledge on gathering tables stats and analyzing tables
• Working experience in fact and dimension tables

Principal Accountabilities:

• Design, develop, test, debug, and automate ETL processes using Oracle PL/SQL and implement enhancements to existing ETL packages
• Provide project, system, and other technical documentations
• Document work/procedures in accordance with the agreed standards
• Write unit and integration test plans/scripts and execute them
• Conduct and coordinate analysis, design, and implementation of systems (application and database)
• Review and get the design approved from the leads and onshore stakeholders
• Report the progress of work in a timely manner
• Take part in reviews of own work and implement the review comments
• Ability to understand complex concepts and processes quickly
• Participate in organization and department process improvement activities
• Good time management and organizational skills
• Ability to work independently and use good judgment
• Ability to work in an agile team environment

Soft Skills:

• Good communication, interpersonal, and problem-solving skills
• Good team player

Educational Background:

• Bachelor's/Master's degree in Engineering or equivalent experience

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