STEP Data Migration Expert

Sandoz India; Andhra Pradesh; On-site; INR 3,500,000 - 5,200,000; Full time

Job summary

Sandoz India is seeking a Senior Data Migration Lead to define and execute the STEP data migration approach across data objects, applications, and deployment waves. You will translate business requirements into detailed specifications, drive ETL development with SAP Data Services/BODS, and coordinate mock data loads and cutover activities in a regulated environment.

The role requires strong analytical skills, experience with data governance, and collaboration with data owners, SMEs, and

Qualifications

• 10+ years of experience in data migration, data conversion, data management, ERP implementation, or enterprise transformation.
• Experience with SAP S/4HANA data migration concepts and data governance practices preferred.
• Strong analytical and problem-solving skills with ability to drive issue closure across multiple teams.
• Proficiency in coordinating mock data loads, cutover activities, and validation in regulated environments.
• Experience using Jira and HP ALM for project collaboration and testing activities.

Responsibilities

• Define and support the STEP data migration approach for assigned data objects, applications, and business domains.
• Translate requirements into detailed data migration specs, including mappings, transformation rules, and reconciliation criteria.
• Collaborate with data owners, stewards, SMEs, and technical teams to identify data readiness gaps and ownership responsibilities.
• Implement ETL jobs using SAP Data Services/BODS and approved migration tooling.
• Coordinate mock loads, dry runs, production rehearsals, and cutover activities with issue tracking and escalation as needed.
• Perform pre-load and post-load validation, including record counts, field checks, sampling, and business validation.
• Ensure complete, traceable, audit-ready migration deliverables and sign-off documentation in line with GxP and SOPs.

Job description

Major Accountabilities

• Define and support the execution of the STEP data migration approach for assigned data objects, applications, deployment waves, and business domains.
• Translate business and functional requirements into detailed data migration specifications, including source-to-target mappings, transformation rules, value mappings, data quality rules, extraction logic, load requirements, and reconciliation criteria.
• Partner with business data owners, local data owners, data stewards, SMEs, functional consultants, and technical teams to identify data scope, cleansing needs, ownership responsibilities and data readiness gaps.
• Implement business requirements in terms of ETL jobs using SAP Data Services/BODS and further approved migration tooling.
• Execute and coordinate mock data loads, washing machine cycles, dry runs, production data load rehearsals, and cutover migration activities, ensuring that defects, timing, dependencies, and readiness issues are captured, tracked, resolved, and escalated as required.
• Perform and govern pre-load and post-load validation, including record count reconciliation, field-level checks, sampling reviews, business validation, exception handling, defect retesting, evidence collection, and formal processes.
• Ensure migration deliverables are complete, accurate, traceable, and audit-readily documented, including migration object lists, functional designs, mapping documents, load files, validation reports, reconciliation evidence, defect logs, migration plans, and sign-off documentation.
• Responsible for performing all assigned activities in compliance with GxP regulations, company SOPs, and data integrity requirements.

Key Performance Indicators

• Data migration scope, object lists, mappings, and transformation rules completed and approved according to plan.
• Mock load, dry run, and production load milestones completed on time and within agreed quality thresholds.
• Data defects identified, prioritized, resolved, retested, and closed within agreed timelines.
• Pre-load and post-load reconciliation completed with documented evidence and business sign-off.
• Data readiness, cleansing, validation, and sign-off status transparently reported.
• Migration deliverables completed in line with STEP quality, validation, compliance, and audit expectations.
• Cutover migration activities executed according to plan with minimal disruption to business continuity.
• Reusable migration assets, templates, reports, and lessons learned improved across deployment waves.

Ideal Background

Education

• Bachelor’s degree in Computer Science, Information Technology, Data Management, Engineering, Business Administration, Supply Chain, Finance, or a related field; Master’s degree preferred.
• Formal training or certification in SAP Data Services/BODS.
• Strong knowledge of SAP S/4HANA data migration concepts, master data and transactional data structures, data conversion methods, and enterprise transformation delivery.
• Knowledge of data governance frameworks, data quality management, data validation, and regulated system delivery practices is preferred.

Languages

• Fluent English required, both oral and written.

Experience and Skills

• 10+ years of experience in data migration, data conversion, data management, ERP implementation, or enterprise transformation within a global multinational organization, preferably including SAP S/4HANA programs.
• 7+ years hands-on experience in SAP Data Services/BODS, ETL methods, SQL, data profiling, and validation reports.
• Experience working with master data and transactional data objects across one or more business domains such as Finance, Procurement, Supply Chain, Manufacturing, Quality, Commercial, Asset Management, or Enterprise Foundation.
• Proven ability to define source-to-target mappings, transformation logic, value mappings, data quality rules, reconciliation methods, and migration acceptance criteria.
• Experience supporting mock loads, production data load rehearsals, cutover migration execution, hypercare, and post-load validation in business‑critical environments.
• Experience in use of Jira and HP ALM for collaboration on‑and planning of day‑to‑day project tasks as well as execution of informal and formal testing activities relating to data migration.
• Strong analytical and problem‑solving skills, with the ability to investigate data defects, resolve root causes, manage ambiguity, and drive issue closure across multiple teams.
• Excellent stakeholder management and communication skills, with the ability to work effectively with business data owners, SMEs, functional consultants, technical teams, vendors, quality, validation, and program leadership.
• Proven ability to operate in a complex, fast‑paced transformation program with multiple workstreams, deployment waves, dependencies, and competing priorities.
• Experience in pharmaceutical, biotechnology, life sciences, manufacturing, or other regulated industries is preferred.
• Strong documentation discipline and ability to produce clear, structured, compliance‑ready migration deliverables, status reports, risks, decisions, and sign‑off materials.