RIM Migration Analyst – TrackWise to RIM

Zensar Technologies | Healthcare & Life Sciences Practice Experience: 3–5 Years | Focus: Data Migration Only (No Configuration / No Development)

Role Overview

Zensar Technologies is seeking a RIM Migration Analyst to support data migration engagements transitioning clients from legacy TrackWise environments to Veeva Vault RIM. This is a hands-on migration execution role — the mandate is profiling, mapping, reconciling, and validating the movement of regulatory data and documents, not configuring systems or writing code.

The right candidate has worked inside a life sciences data migration project, understands what regulatory document repositories look like under the hood, and can be trusted to own mapping workbooks, run reconciliation checks, and keep migration logs clean enough to survive a GxP audit.

Key Responsibilities

Data Profiling & Source Analysis

Analyse TrackWise source data — document types, metadata fields, submission objects, registration records, and folder hierarchies — and document findings in structured profiling reports.
Identify data quality issues: missing metadata, duplicate records, broken relationships, inconsistent taxonomy, and legacy free-text fields requiring normalisation.
Work with client regulatory operations and IT teams to clarify source data ambiguities and obtain legacy system access for profiling exercises.

Source-to-Target Mapping

Populate and maintain source-to-target mapping workbooks covering TrackWise entities to Veeva Vault RIM objects (Submissions, Registrations, Submission Archive, Documents).
Document transformation rules, default value logic, conditional mapping decisions, and known exceptions.
Flag mapping conflicts and gaps to the Migration Lead for resolution; track decisions and rationale in the mapping log.
Keep the mapping specification current across all migration iterations and scope changes.

Migration Execution Support

Coordinate with technical ETL teams to ensure extraction and load parameters align with approved mapping specifications — no hands-on coding required.
Participate in migration dry runs, validate loaded data against source counts and mapping rules, and document reconciliation results.
Raise and track data exceptions, work with business and technical teams to resolve or formally accept exceptions within agreed thresholds.
Maintain migration run logs, load reports, and exception registers as project artefacts.

Validation & GxP Compliance

Support preparation of migration validation deliverables: Data Migration Plan, Migration Test Scripts, IQ/OQ evidence packs, and Migration Closure Report.
Execute migration test scripts during OQ/PQ cycles; record evidence in a manner compliant with GxP audit trail requirements.
Assist the Migration Lead and client QA teams during validation reviews and mock audits.

Reporting & Communication

Produce weekly migration status updates covering profiling progress, mapping completion, run results, and open issues.
Maintain issue and risk registers for the migration workstream; escalate blockers promptly to the Migration Lead.
Participate in client working sessions and contribute structured inputs on data findings and mapping decisions.

Required Skills & Experience

Skill / Domain	Expectation
TrackWise	Working knowledge of TrackWise data structures, document types, and metadata model — direct project exposure preferred
Veeva Vault RIM	Familiarity with Vault RIM objects and document model in a migration or functional context (not configuration)
Data Migration Execution	3–5 years in data migration roles — mapping, profiling, reconciliation, and validation in life sciences or regulated industries
Data Mapping	Able to independently author and maintain source-to-target mapping workbooks with transformation logic
GxP / CSV Awareness	Understanding of validated system migration requirements; can execute test scripts and produce audit-ready evidence
Analytical Rigour	Detail-oriented; comfortable working with large data sets, spotting anomalies, and driving issues to resolution
Documentation	Clear, structured documentation habits — mapping specs, run reports, and exception logs must be inspection-ready
Tools	Advanced Excel for mapping and reconciliation; JIRA or equivalent for issue tracking; SharePoint / Vault for artefact management

Preferred Qualifications

Direct exposure to TrackWise Digital (Sparta Systems) — familiarity with its submission, registration, and CAPA modules.
Prior involvement in a Veeva Vault RIM implementation or migration alongside a Veeva SI partner.
Awareness of eCTD structure and regulatory dossier organisation — useful context for Submissions Archive mapping decisions.
Exposure to other legacy regulatory or quality document systems: Documentum, OpenText, Pilgrim SmartSolve.
IIBA ECBA / CCBA, or equivalent business analysis certification.
Basic familiarity with IDMP data standards.