Data Migration Lead

Candidate Must have over 12 years of overall experience in IT

Key Responsibilities

· Analyze and trace end-to-end data flows across source systems, ingestion, enrichment, and downstream data products.

· Perform advanced SQL-based data profiling, reconciliation, validation, troubleshooting, and root-cause analysis.

· Develop detailed source-to-target mappings, data requirements, transformation rules, business definitions, and acceptance criteria.

· Design reusable and scalable enterprise data products that support multiple business use cases and downstream consumers.

· Identify data quality issues, mapping discrepancies, dependencies, and upstream/downstream impacts.

· Support data integration, migration, modernization, and new source-system onboarding initiatives.

· Create and maintain technical documentation, data dictionaries, data lineage, mapping specifications, and validation plans.

· Collaborate with Product, Engineering, Architecture, QA, business teams, and source-system stakeholders.

· Support UAT, production validation, and data-related issue resolution.

· Explore emerging technologies, including semantic layers, Snowflake Cortex, AI-assisted development, and AI-ready data products.

Mandatory Technical Skills

· SQL & Data Analysis: Advanced SQL, complex joins, data profiling, reconciliation, data validation, and root-cause analysis.

· Snowflake: Working knowledge of databases, schemas, tables, views, roles, and enterprise data environments.

· Source-to-Target Mapping & Data Integration: Strong experience with field-level mappings, transformation rules, data lineage, keys, relationships, and multiple data sources.

· Enterprise Data Product Design: Experience designing reusable data products, data models, common business rules, and scalable data structures.

· Data Validation & Testing: Source-to-target reconciliation, record-count validation, duplicate detection, data quality checks, UAT, and production validation.

· Technical Documentation: Strong experience with data dictionaries, technical specifications, business rules, lineage, and mapping documents. Familiarity with Jira, Confluence, SharePoint, or similar tools.