Senior Pharmacovigilance Data Migration Consultant

🔥 0 minutes ago

🇮🇳 India – Remote

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

EVERSANA

WebsiteLinkedInAll Job Openings

5001 - 10000 employees

💼 Consulting

🏥 Healthcare

⚕️ Healthcare Insurance

Consulting • Healthcare • Healthcare Insurance

EVERSANA is a comprehensive service provider focused on integrated commercial solutions for the life sciences industry. The company offers a wide range of services including advisory and management consulting, regulatory consulting, patient services, market access strategies, pricing and revenue management, medical affairs, and digital transformation. EVERSANA is known for its expertise in drug commercialization, enabling companies to effectively launch and manage pharmaceutical products. With a platform powered by data and analytics, EVERSANA addresses challenges related to drug pricing, market access, patient adherence, and product delivery, helping companies optimize their commercial strategies and enhance patient outcomes. The company emphasizes innovation and has been recognized for its use of AI and data analytics within the life sciences sector.

📋 Description

• Configure, maintain, and optimize Oracle Argus Safety for pharmacovigilance operations and regulatory reporting • Lead end-to-end pharmacovigilance data migration projects from legacy safety systems into target safety systems • Perform source system assessment, data profiling, gap analysis, and migration impact assessments • Analyze and convert PostgreSQL databases and database objects into Oracle Database/Oracle Autonomous Database • Design and maintain source-to-target mapping documents, transformation rules, migration specifications, and data conversion documentation • Develop SQL and PL/SQL scripts for extraction, transformation, loading, reconciliation, validation, and migration reporting • Perform data extraction, cleansing, standardization, transformation, and loading • Execute schema conversion and optimize migrated database objects • Conduct data validation and reconciliation between source and target systems • Support migration of Cases, Products, Events, Licenses, Studies, Regulatory Reports, Literature, Users, Workflow Data, Attachments, and Configuration Data • Develop and execute migration validation plans, reconciliation reports, exception reports, and post-migration verification • Support SIT, UAT, Performance Testing, Regression Testing, and Production Validation • Troubleshoot migration issues involving data quality, database conversion, mapping, configurations, and integrations • Develop and maintain Oracle BI Publisher reports and validation reports • Collaborate with Pharmacovigilance, Regulatory Affairs, Business Analysts, Database Administrators, Validation Teams, and Oracle Support • Support integrations between Oracle Argus Safety and external applications using APIs and web services • Ensure compliance with GxP, FDA 21 CFR Part 11, EMA, ICH E2B(R3), GAMP 5, and validation standards • Prepare migration plans, data mapping specifications, validation documents, technical design documents, SOPs, and migration summary reports • Support Oracle Argus upgrades, cloud migrations, OCI, and ADB modernization initiatives • Mentor junior consultants and provide technical guidance • Recommend automation opportunities and continuous improvements

🎯 Requirements

• Strong expertise in PostgreSQL database administration and development • Hands-on experience converting PostgreSQL databases to Oracle Database and Oracle Autonomous Database (ADB) • Experience with PostgreSQL-to-Oracle schema conversion, including tables, indexes, constraints, sequences, views, triggers, stored procedures, and functions • Strong SQL and PL/SQL programming skills • Experience developing migration scripts, stored procedures, packages, and automation utilities • Experience using Oracle SQL Developer Migration Workbench or equivalent schema conversion tools • Strong understanding of Oracle Database architecture, Oracle Autonomous Database (ADB), and performance tuning • Experience with ETL processes, data transformation, and migration automation • Ability to optimize SQL queries and improve migration performance for high-volume datasets • Experience performing data assessment, profiling, cleansing, transformation, validation, reconciliation, and migration activities • Ability to develop and maintain source-to-target mapping documents and migration specifications • Experience executing complex SQL-based reconciliation and data validation activities • Ability to identify and resolve migration defects, mapping inconsistencies, and data quality issues • Experience conducting pre-migration, mock migration, production migration, and post-migration verification • Experience supporting SIT, UAT, Regression Testing, and Production Validation • Ability to perform record-level reconciliation • Bachelor’s degree/Masters Degree in IT Stream preferred • 7+ years of relevant experience in safety IT Systems

🏖️ Benefits

• Great Place to Work certification • Equal Opportunity Employer • Diversity, Equity & Inclusion commitment • Inclusive culture • Employee development and talent investment