Data Migration Specialist

Role: Data Migration LeadLocation: NY/NJ Remote (Customer location -New York, NY 10045, open to onsite for critical meetings when neededTerm: Full Time Job Responsibilities:Total Exp. of 8+ yearsOwn end-to-end data migration strategy including scope (static data, trades, market data, historical data) and approach (phased vs big bang)Design and implement ETL frameworks using Python for data extraction, transformation, and loading into CalypsoDevelop and optimize complex PL/SQL scripts for data validation, reconciliation, and database-level transformationsDefine source-to-target data mapping between legacy systems and Calypso data model (trades, counterparties, books, portfolios, cashflows)Drive data profiling, cleansing, and enrichment activities, identifying gaps and inconsistencies in legacy dataEstablish reconciliation frameworks:Trade-level reconciliationPosition-level reconciliationPnL-level reconciliationCollaborate with Front Office, Middle Office, and Back Office teams to validate business-critical data (e.g., trades, settlements, accounting)Lead mock migrations and dress rehearsals, ensuring repeatability, accuracy, and performance of migration cyclesDefine and enforce data quality controls, validation rules, and audit trails to meet regulatory and compliance requirementsWork closely with integration teams to align migration with upstream/downstream systems (market data, payments, GL)Optimize migration performance (handling millions of trades) using batching, parallel processing, and database tuningManage data cutover planning and execution, including rollback strategies and contingency planningCoordinate with testing teams to ensure complete coverage of migrated data across SIT, UAT, and regression cycles