Job Details:
Must Have Skills:
We are seeking an IT Data Migration
Lead to drive a cross ‑ organization
migration of banking and financial datasets — covering
Customer/KYC, Accounts & Products, Loans & Deposits, Cards &
Payments, Treasury, Risk, and Finance/GL. The role owns end ‑ to ‑ end migration strategy, data quality, reconciliation, and
regulatory compliance to ensure accurate, complete, and secure data
transition with zero/minimal business disruption across EOD/BOD cycles and
financial close periods.
Key Outcomes (First 30/60/90 Days)
· 30 days: Migration strategy, scope, and data domain inventory
finalized; risk & control framework baselined; mock run plan drafted.
· 60 days: Source ‑ to ‑ target mappings and transformation rules signed off; profiling
completed with remediation backlog; first mock run executed and reconciled.
· 90 days: Rehearsal migrations completed with green reconciliation;
cutover plan and rollback criteria baselined; stakeholder sign ‑ offs obtained.
Nice to Have Skills:
Good communication, Team Leader
Detailed Job Description:
) Strategy & Governance
· Own the end ‑ to ‑ end data
migration strategy (waves vs big ‑ bang)
aligned to release and financial close calendars.
· Define in ‑ scope/out ‑ of ‑ scope data domains, success criteria, KPIs, and acceptance thresholds.
· Establish data controls and governance in line with SOX, BCBS 239,
GDPR/DPDP, PCI DSS, and internal policies.
· Chair data working groups; act as Data SPOC across Business,
Operations, Risk, Finance/Controllership, Security, and Vendors/SIs.
2) Source & Target Analysis
· Lead deep analysis of source systems (Core Banking, Cards, Payments,
Trade, Treasury, Risk, GL/sub ‑ ledgers)
and target platforms.
· Drive canonical data model alignment; author/source ‑ to ‑ target mapping specifications and transformation
rules.
· Define data retention, archival, and purging strategy for
decommissioning legacy systems.
3) Data Quality, Profiling & Cleansing
· Own profiling of critical attributes (completeness, validity,
duplicates, referential integrity, PII sensitivity).
· Prioritize and drive remediation of data quality issues with business
owners and system SMEs.
· Define standardization (e.g., product hierarchies, customer types),
survivorship, and deduping rules (MDM alignment).
4) Migration Factory Execution Oversight
· Collaborate with ETL/Data Engineering teams on extraction,
transformation, load sequencing, and performance tuning.
· Review SQL/ELT logic, parameterization, data masking/encryption, and
error handling; enforce code review checklists.
· Plan and supervise rehearsal runs, dress rehearsals, and cutover
execution with clear go/no ‑ go and
rollback criteria.
5) Validation, Reconciliation & Controls
· Define multi ‑ level reconciliations: record counts, control
totals, financial tie ‑ outs
(GL/sub ‑ ledger), and attribute ‑ level checks.
· Coordinate business validation, UAT, and sign ‑ offs; ensure continuity of reports (MIS, regulatory, IFRS 9/CECL
analytics).
· Maintain auditable lineage, metadata, and evidence packs for
internal/external audit.
6) Risk, Security & Compliance
· Implement data protection controls for PII/PCI data: masking,
tokenization, encryption, key management, access control.
· Ensure segregation of duties, maker ‑ checker, and break ‑ glass
procedures during cutover.
· Manage regulatory data obligations (KYC/AML data, sanctions screening
history, customer consent, retention policies).
7) Stakeholder Management & Communication
· Publish migration dashboards on readiness, DQ defects, reconciliation
status, and risks/issues.
· Drive decision forums for exceptions, data ownership conflicts, and
scope trade ‑ offs.
· Provide concise executive updates and steerco materials.
Qualifications & Experience
· 10–15 years in Data/Analytics with 5+ years leading complex migrations
in Banking/Financial Services.
· Proven delivery of at least 2 large migrations across banking domains
(Retail, Corporate, Cards/Payments, Treasury, Risk, Finance).
· Strong SQL; exposure to ETL/ELT and data platforms (e.g.,
Informatica/Talend, Azure Data Factory/Databricks/Synapse, Snowflake,
BigQuery, Redshift).
· Understanding of data warehousing, lakehouse, and streaming ingestion
patterns.
· Hands ‑ on experience with data quality tooling and
metadata/lineage (e.g., Collibra/Atlan/Purview).
· Familiarity with controls and regulations: SOX, BCBS 239, GDPR/DPDP,
PCI DSS; knowledge of KYC/AML concepts.
· Excellent stakeholder management, vendor oversight, and documentation
skills.