Staff Engineer, Data Migration Analyst

REQUIREMENTS:

  • Total experience 5.5+ years.
  • Should have 5-8 years of experience in data analysis, system implementation support, testing support, or PMO/BA roles with strong data exposure (banking/financialservices preferred).
  • Should have experience supporting data migration, reconciliation, or test data activities is an advantage.
  • Familiarity with core banking/deposits concepts (CASA/Time Deposit) is a plus.
  • Should have experience with legacy-to-modern platform migrations (AS/400 to modern core banking, cloud-native or microservices architectures) is strongly preferred.
  • Hands-on experience with DMS platforms or other core banking platforms.
  • Should have knowledge of data quality and validation concepts
  • Should have working understanding of ETL concepts and migration lifecycle
  • Should have understanding of banking data objects (customer/account, balances, product parameters, transaction history) and downstream impacts.
  • Should have strong analytical skills; comfortable working with large datasets and spotting patterns/variances.
  • Should have proficiency in SQL (preferred) and Excel; experience with data tools (e.g., Power BI) is a plus.
  • Should have strong documentation discipline (logs, trackers, evidence packs) and attention to detail.
  • Should have good communication skills to coordinate clarifications and follow-ups across IT, vendor, and business SMEs.
  • Should have structured problem-solving and ability to summarize issues and impacts clearly.

RESPONSIBILITIES:

  • Maintain and update migration workplan trackers (mock run schedule, environment data refresh plan, reconciliation checkpoints, cutover readiness checklist).
  • Support requirements-to-data traceability: maintain source-to-target mapping tracker, transformation rule clarifications, and sign-off status across stakeholders.
  • Perform data validation activities using agreed control framework (record counts, control totals, sample-based checks, exception analysis) against vendor outputs.
  • Support reconciliation preparation and review (balance reconciliations, account-level variances, GL/SL tie-outs where applicable); document findings and follow up with owners.
  • Manage defect and exception logs for data migration (capture issues, categorize root cause themes, track to closure, support evidence collation).
  • Coordinate data-related SIT/UAT readiness: confirm test data availability, refresh requests, masking requirements (if applicable), and resolve data blockers with vendor/IT teams.
  • Prepare artifacts and evidence for governance and auditability (mapping approvals, run results, reconciliation reports, signoff packs, cutover runbooks attachments).
  • Produce regular status updates and dashboards for the Data Migration Lead (progress, risks/issues, decisions needed, upcoming milestones).
  • Support cutover activities and mock runs (checklist execution support, results collation, variance reporting, post-run lessons learned capture).
  • Ensure adherence to client data security and access controls when handling extracts, files, and non-production data.

Bachelor’s or master’s degree in computer science, Information Technology, or a related field.