IQVIA

Data Operations and ETL Analyst

109.6k - 203.4k PLN109 600 - 203 400 PLN/ rok./ rok.UoPUmowa o pracę (brutto)

MidOn-site·WarszawaFull-time·Umowa o pracę

#449865·Dodano miesiąc temu·1

Źródło: IQVIA

Aplikuj teraz

Tech Stack / Keywords

Informatica PowerCenterETL SQLWindowsLinux Snowflake Gitlab JIRA

Firma i stanowisko

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

Wymagania

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.

Obowiązki

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.

Benefity

Incentive plans, bonuses, and/or other forms of compensation.
Range of health and welfare benefits.

Inne informacje

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.

IQVIA

34 aktywne oferty

Zobacz wszystkie oferty

Aplikuj teraz