IT Data Migration Lead with Banking

Must Have Skills:

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.