Data Migration Lead- II Onsite II C2C contract

Data Migration Lead

Work Mode: Onsite (5 days onsite)

Client Office Locations:

• Bismarck, ND
• Boise, ID
• Burlington, IA
• Fargo, ND
• Grand Forks, ND
• Lewiston, ME
• Minot, ND
• Portland, OR
• Renton, WA
• Spokane, WA
• Salt Lake City, UT
• Vancouver, WA

Job Overview

We are looking for an experienced Data Migration Lead with strong expertise in SQL, Snowflake, data analysis, data integration, and enterprise data migration.

The candidate should have extensive experience analyzing complex data flows, understanding source and target systems, creating source-to-target mappings, performing data validation, and ensuring accurate data migration.

The role also requires the ability to design reusable enterprise data products, document technical requirements, identify data quality issues, and work closely with business and technical teams.

Knowledge of Snowflake Cortex, semantic layers, and AI-ready data products will be an added advantage.

Key Responsibilities

• Lead data discovery and analysis across source systems, data ingestion, transformation, and downstream applications.
• Analyze complex datasets using SQL and identify data quality issues, missing records, duplicates, and inconsistencies.
• Create and maintain source-to-target mapping documents, transformation rules, business requirements, and data lineage.
• Understand existing data structures and develop reusable data products that support multiple business requirements.
• Perform source-to-target data reconciliation and ensure data accuracy throughout migration activities.
• Identify root causes of data discrepancies and coordinate with technical teams to resolve issues.
• Assess the impact of source-system changes, schema modifications, and business-rule changes on downstream applications.
• Work with business stakeholders, architects, engineering, QA, and product teams to gather and document requirements.
• Support data migration, modernization, and new source-system integration initiatives.
• Develop technical specifications, acceptance criteria, validation plans, and data dictionaries.
• Ensure proper documentation of data flows, business rules, and technical processes.
• Explore modern data technologies, including semantic layers, Snowflake Cortex, and AI-ready data products.

Mandatory Technical Skills

1. SQL & Data Analysis – Advanced

• Strong experience writing complex SQL queries, joins, subqueries, and aggregations.
• Data profiling, reconciliation, troubleshooting, and root-cause analysis.
• Source-to-target data comparison and validation.
• Ability to investigate unfamiliar datasets and identify data discrepancies.

2. Snowflake – Working to Intermediate

• Hands-on experience with Snowflake databases, schemas, tables, and views.
• Ability to analyze data across multiple schemas.
• Understanding of Snowflake data environments and data integration.
• Exposure to data migration and modernization projects.

3. Data Migration & Source-to-Target Mapping – Advanced

• Strong experience in enterprise data migration and integration.
• Creating and maintaining source-to-target mapping documents.
• Defining field-level transformations, business rules, keys, and relationships.
• Understanding end-to-end data flow from source systems to downstream applications.
• Experience working with database, file-based, batch, and external data sources.

4. Enterprise Data Product Design

• Experience designing reusable enterprise data products.
• Understanding of data modeling, reusable tables, views, and business logic.
• Ability to develop flexible data solutions for multiple consumers and business use cases.
• Knowledge of dimensional modeling and semantic modeling.

5. Data Validation & Reconciliation – Advanced

• Source-to-target reconciliation and data quality checks.
• Record-count validation and duplicate identification.
• Identifying missing records, incorrect transformations, and data discrepancies.
• Experience supporting UAT and production validation.

6. Technical Documentation & Requirements

• Experience creating technical specifications, data dictionaries, mapping documents, and data lineage.
• Ability to convert business requirements into technical documentation.
• Familiarity with Jira, Confluence, SharePoint, or similar tools.

Good to Have Skills

• Knowledge of semantic layers and semantic data models.
• Exposure to Snowflake Cortex and Cortex Code.
• Experience with AI-assisted SQL development and data analysis tools.
• Understanding of AI-ready data products and AI-driven data consumption.
• Knowledge of APIs, JSON, event-driven architecture, and Kafka.
• Basic Python knowledge for data analysis, reconciliation, and automation.

Ideal Candidate Profile

• 15+ years of overall IT/data experience.
• Strong hands-on SQL and enterprise data migration experience.
• Good understanding of Snowflake and modern data architecture.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and technical documentation skills.
• Ability to independently manage data discovery and migration activities.
• Comfortable working with business and technical stakeholders.
• Willing to work onsite at one of the specified client locations.

Skill Metrix

 

 

Thanks & Regards

Preeti Upadhyay

Sr. Executive Recruiter

E-mail 📩 Preeti@tekintegral.com