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.
