Overview
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
* 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.
Responsibilities
* 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.
* 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.
* 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).
* 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.
* 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.
* 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).
* 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.
Nice to Have
* M&A integration experience and cross border data transfers.
* Experience with IFRS 9/CECL data flows, Basel risk data aggregation, liquidity and market risk datasets.
* Exposure to core banking and adjacent platforms (e.g., Temenos/Flexcube/Finacle, SAP S/4HANA Finance, Murex, Calypso).
* Automation of reconciliations, synthetic data generation for testing, and data virtualization.
Indicative Tech Stack (Exposure)
* Data Integration: Informatica, Talend, Azure Data Factory, Glue; ELT with Databricks/Spark, Synapse, Snowflake.
* Data Quality & Lineage: Informatica DQ, Ataccama, Collibra, Atlan, Microsoft Purview.
KPIs & Success Metrics
* Data completeness and accuracy ≥ agreed thresholds per domain.
* Financial reconciliation: GL tie out variance within tolerance (e.g., ≤ 0.1%).
* DQ defects: identification and closure rate meeting plan; zero critical unresolved at cutover.
* Cutover success: on time with no Sev 1 data incidents; rollback not triggered.
* Audit readiness: 100% evidence pack completeness (lineage, approvals, results).
* 14 years; led retail corporate bank migrations across core banking and cards.
* Strong mapping/reconciliation; SQL Informatica; senior stakeholder management.
* Comfort with regulatory reporting continuity and GL/sub ledger tie outs.
#J-18808-Ljbffr