We are looking for a proactive, hands-on Lead Data Migration Engineer & Architect (1015 years experience) to own and drive the end-to-end migration of client payroll data from OSC into iiPay. This is not a simple data port. You will design the solution architecture, define the data models and transformation logic, and then execute hands-on: building and running the data mapping, transformation, and validation processes to ensure payroll entities are accurately restructured for iiPays data model, across multiple concurrent global clients, under tight program deadlines.

Key Responsibilities

- Own, drive, and deliver end-to-end data migration approach and delivery from OSC to iiPay across multiple concurrent global payroll clients

- Proactively align with Program and Operations leads on client prioritization, sequencing, dependencies, and delivery timelines

- Extract and profile payroll client data and documents from the OSC legacy .NET platform and underlying SQL databases

- Design and implement data mapping and transformation logic between OSC’s data structures and iiPay’s target data model (this is not a like-for-like migration; structural and semantic transformation is required)

- Develop and optimize SQL queries and ETL pipelines for data transformation, cleansing, and validation to automate loading into iiPay

- Build and execute rigorous data reconciliation processes with robust control frameworks, exception reporting, and audit trails to guarantee data integrity

- Investigate and resolve data quality issues, migration blockers, and cross-functional dependencies with urgency and minimal escalation

- Deliver client migrations on time in a high-pressure, deadline-driven program environment; you set the pace, not follow it

- Proactively identify, flag, and mitigate data risks, issues, and upstream/downstream dependencies before they become blockers

- Present progress, risks, and outcomes with clarity and confidence to senior stakeholders up to C-suite level; no hand-holding required

- Define the end-to-end solution architecture for each client migration: data flows, system integration points, transformation layers, and target-state data models in iiPay
- Produce technical design documentation (HLD/LLD, data flow diagrams, entity-relationship mappings) that serve as the blueprint for execution

Technical & Architecture Competencies

- Proven track record designing and delivering data migration architectures end-to-end, including data profiling, mapping, transformation, validation, and reconciliation methodologies

- SQL Server mastery including advanced TSQL, performance tuning, schema analysis and data extraction; complex queries, multi-table joins, stored procedures, performance tuning, and large-scale data reconciliation




- DB2 LUW expert proficiency including SQL PL, tablespaces, sequences, triggers, and optimisation
- DB2 performance tuning for highvolume workloads
- Automation & scripting using Python, PowerShell, or Bash
- Migration Architecture — Designs and governs the full SQL Server DB2 migration framework, including ETL, validation, cutover, and stabilisation
- CrossPlatform Conversion — Architects translation of SQL Server schemas, stored procedures, and identity logic into DB2 SQL PL and existing DB2 structures.
- Informatica ETL Architecture — Builds highperformance Informatica pipelines using reusable transformations, partitioning, and pushdown optimisation.
- Global Payroll Data Architecture — Designs multicountry payroll data flows, multicurrency handling, and statutory data structures.
- Security, Quality & Cutover Architecture — Defines validation frameworks, secure data movement, compliance controls, and global cutover strategies with minimal downtime

- Hands-on experience with ETL/ETL tools (Azure Data Factory, AWS Glue, Informatica, Talend, or similar) and strong Python scripting for automation and data manipulation

- Advanced Excel proficiency for large-dataset analysis, pivot tables, XLOOKUP/INDEX-MATCH, and reconciliation reporting

- Ability to build clear, structured executive-level presentations that communicate migration status, risks, and decisions

- Working knowledge of middleware, integration platforms, and API-based data exchange patterns between payroll systems

- Experience designing data architectures: schema design, data modeling (conceptual, logical, physical), and entity-relationship mapping for complex payroll/HR domains

- Ability to produce clear technical design artifacts: solution architecture diagrams, data flow diagrams, HLD/LLD documentation

- Understanding of migration patterns and trade-offs: big-bang vs. phased cutover, parallel-run validation, rollback strategies, and data versioning
- Exposure to cloud-native data platforms and services (Azure, AWS) for scalable migration pipeline design

Delivery, Leadership & Communication

- Track record of successfully delivering complex, multi-client data migration programs across geographies with measurable outcomes

- Demonstrated ability to manage multiple parallel client migrations simultaneously without dropping quality or timelines





- Obsessive attention to data integrity and detail; you catch errors others miss

- Self-directed with solid ownership mentality; you don’t wait for instructions, you drive the work forward

- Thrive (not just survive) in fast-paced, high-pressure, ambiguous environments where priorities shift and deadlines are non-negotiable

- Exceptional communication skills; able to translate complex data concepts into clear business language for both technical teams and non-technical executives

- Proven experience presenting concisely and credibly to senior leaders and C-suite executives to drive decisions on architecture, sequencing, and risk trade-offs

- Ability to articulate risks, blockers, and dependencies crisply in both written and verbal formats, with actionable recommendations (not just problem statements)

- Confident, credible, and composed in high-stakes client-facing and internal governance settings

Role Minimum Requirements

Baseline Qualifications

- Bachelor’s degree in Computer Science, Information Technology, Data Engineering, or a related discipline (Master’s degree preferred)
- 10–15 years of progressive experience in data migration, data engineering, or data architecture roles, with at least 8 years leading migration workstreams
- Based in India (hybrid from Mumbai office or fully remote within India); must be available for overlap with UK/EU business hours as needed
- Well versed with API-based integrations between payroll systems and/or middleware platforms
- Demonstrated experience in global Payroll & HR, or financial services data environments
- Fluent in English with excellent written and verbal communication skills

Desirable

- Direct experience with migrations onto global payroll SaaS platforms
- Experience with .NET-based legacy system decommissioning and data archival strategies
- Understanding of multi-country payroll data structures, statutory requirements, and cross-border data considerations
- Familiarity with business change management processes in large-scale enterprise transformation programs

Why Vistra

This is a career-defining opportunity. You will be at the center of a global transformation program with direct visibility to senior leadership. At Vistra, we offer flexible working arrangements and prioritize the growth of our people.

We invest in continuous learning, mentorship, and career progression. You will sharpen your expertise across global payroll, data engineering, and enterprise transformation while working alongside some of the best in the industry.

If you’re the kind of person who runs toward complexity, takes pride in getting things done right, and wants your work to matter, we want to hear from you.

📌 Lead Data Migration Engineer & Architect -Contract Role (Mumbai)
🏢 VISTRA
📍 Mumbai