Collaborate with business stakeholders data architects and IT teams to gather and understand data migration requirements. Analyze legacy banking and insurance systems (e.g. core banking policy admin claims CRM) to identify data structures and dependencies. Work with large-scale datasets and understand big data architectures (e.g. Hadoop Spark Hive) to support scalable data migration and transformation. Perform data profiling cleansing and transformation using SQL and ETL tools with the ability to understand and write complex SQL queries and interpret the logic implemented in ETL workflows. Develop and maintain data mapping documents and transformation logic specific to financial and insurance data (e.g. customer KYC transactions policies claims). Validate migrated data against business rules regulatory standards and reconciliation reports. Support UAT by preparing test cases and validating migrated data with business users. Ensure data privacy and security compliance throughout the migration process. Document issues risks and resolutions related to data quality and migration.