ETL & Data Operations Analyst - Healthcare Data

IQVIA; Warszawa; Sur place; PLN 110 000 - 203 000; Plein temps

Résumé du poste

IQVIA is seeking a Data Operations and ETL Analyst to support end-to-end processing of healthcare and market data in the LPD production environment. You will ensure timely, accurate data workflows from parsing to loading, collaborating with global teams to maintain data integrity and SLA adherence.

The role requires hands-on ETL experience with Informatica PowerCenter, data validation, and production support.

Qualifications

• Bachelor’s degree in Information Technology, Computer Science, Data Analytics, Engineering, or a 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.
• Experience working with healthcare, pharmaceutical, or commercial data environments is preferred.

Responsabilités

• Execute and monitor manual and automated LPD data processing workflows.
• Manage data processing activities from Parser through OD and BO loading environments.
• Validate and prepare incoming source files for processing.
• Manually trigger workflow executions when required to support production timelines.
• Monitor workflow status and investigate processing failures or exceptions.
• 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.
• 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.
• 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.

Connaissances

ETL concepts

SQL troubleshooting

Batch scripting

Data quality validation

Formation

Bachelor’s degree in IT / CS / Data Analytics

Outils

Informatica PowerCenter

WinSCP

Snowflake

JIRA

GitLab

Description du poste

IQVIA is seeking a Data Operations and ETL Analyst to support end-to-end processing of healthcare and market data in the LPD production environment. You will ensure timely, accurate data workflows from parsing to loading, collaborating with global teams to maintain data integrity and SLA adherence.

The role requires hands-on ETL experience with Informatica PowerCenter, data validation, and production support.