Data Operations and ETL Analyst

IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries.

• Bachelor's degree in Information Technology, Computer Science, Data Analytics, Engineering, or related field.
• 2 to 5 years of experience in Data Operations, Production Support, ETL operations, or Application Support.
• Experience supporting production environments and managing critical data processing workflows.
• Preferred experience with healthcare, pharmaceutical, or commercial data environments.

Technical Skills:

• Experience with Informatica PowerCenter (Workflow Manager and Workflow Monitor).
• Knowledge of ETL concepts and data integration processes.
• Proficient in SQL and database troubleshooting.
• Experience with Windows and Linux server environments.
• Familiarity with file transfer tools (e.g., WinSCP).
• Batch scripting and job scheduling skills.
• Data quality validation and reconciliation experience.

Preferred Skills:

• Production Support / Application Support experience.
• Incident and problem management.
• Root Cause Analysis (RCA).
• Process improvement and operational excellence methodologies.
• Knowledge of healthcare data processing environments.
• Nice to have: Snowflake, Gitlab, JIRA.

Data Processing & Workflow Management:

• Execute and monitor manual and automated LPD data processing workflows.
• Manage data processing activities from Parser through Operational Data (OD) and Business Objects (BO) loading environments.
• Validate and prepare incoming source files for processing.
• Manually trigger workflow executions when required.
• Monitor workflow status and investigate processing failures or exceptions.

Informatica Administration & ETL Support:

• Utilize Informatica PowerCenter Workflow Manager and Workflow Monitor to execute and manage ETL jobs.
• Review mappings, file dependencies, directories, and workflow configurations.
• Upload and manage source files on Informatica servers.
• Perform session locking and unlocking activities to prevent workflow conflicts during manual processing.
• Coordinate deployment and execution of country-specific workflows.

Production Support & Troubleshooting:

• Investigate and resolve data loading issues across OD and BO environments.
• Analyze ETL failures, log files, workflow errors, and data discrepancies.
• Support month-end and period-close activities.
• Troubleshoot database and workflow-related issues impacting data availability.
• Perform root cause analysis and recommend corrective actions.

Data Quality & Validation:

• Verify file naming conventions, control files, and loading requirements.
• Conduct data validation checks before and after workflow execution.
• Ensure data completeness, accuracy, and consistency throughout the ETL lifecycle.
• Support data reconciliation and issue resolution.

Process Control & Operational Excellence:

• Follow established production control procedures and operational standards.
• Maintain documentation, runbooks, and knowledge articles.
• Identify opportunities for automation and process improvements.
• Support business continuity and disaster recovery activities.

Stakeholder Collaboration:

• Work closely with Operations, Technical Support, Database Administrators, and Global Production Teams.
• Communicate processing status, incidents, risks, and resolutions to stakeholders.
• Participate in operational reviews and continuous improvement initiatives.

IQVIA has a zero tolerance policy for candidate fraud. All submitted information must be truthful and complete. False statements or omissions may result in disqualification or termination.