Snowflake Data Migration Engineer w/ Python

Snowflake Data Migration Engineer w/ Python

Must have:

• Snowflake & Advanced SQL
• Data Quality Controls & Validation
• Migration testing and production validation
• Experience with Informatica Data Quality/PowerCenter, Oracle, Redshift, Salesforce,
  • • • JSON is a plus.
• Python
• AWS / S3
• MUST HAVE excellent COMMUNICATION
• Must have strong excellent communication
• LinkedIn Page

Senior Data Quality & Snowflake Migration Engineer:

• We are seeking an experienced Senior Data Quality & Snowflake Migration Engineer with strong expertise in Snowflake, SQL, Python, data migration, data integration, and data quality controls.
• The role will focus on ensuring data is accurately profiled, validated, transformed, reconciled, and migrated from legacy and source systems into Snowflake.
• The ideal candidate will have hands-on experience working with complex enterprise datasets and implementing data quality controls throughout the migration lifecycle, from source assessment through production validation.
• The candidate's experience includes data migrations, integrations, Snowflake development, data analysis, mapping, and data-quality implementation.

Key Responsibilities:

• Design and implement data quality controls for large-scale data migrations into Snowflake.
• Perform source data profiling and analysis to identify completeness, accuracy, consistency, duplication, and formatting issues.
• Define and implement pre-migration and post-migration validation controls.
• Develop SQL-based data quality rules, validation queries, and exception reporting.
• Perform source-to-target mapping, field mapping, transformation analysis, and fit-gap assessments.
• Develop Snowflake SQL and ETL/ELT processes for data cleansing, transformation, migration, and integration.
• Implement data reconciliation controls to validate record counts, key attributes, transformations, and source-to-target data accuracy.
• Identify migration exceptions, investigate data-quality defects, perform root-cause analysis, and coordinate remediation.
• Implement data cleansing, standardization, validation, duplicate identification, and data integrity controls.
• Build automated data validation and processing solutions using SQL and Python.
• Create Snowflake views, data extracts, dashboards, and exception reports to support migration monitoring and validation.
• Support migration testing, UAT, production cutover, and post-migration data validation.
• Work closely with data engineers, architects, analysts, and business stakeholders to define data quality acceptance criteria and migration controls.

Required Skills:

• Snowflake & Advanced SQL
• Data Quality Controls & Validation
• Data Migration & Reconciliation
• Data Profiling & Root-Cause Analysis
• Source-to-Target / Field Mapping
• ETL/ELT & Data Integration
• Python
• AWS / S3
• Data cleansing and standardization
• Data lineage and dependency analysis
• Exception reporting and remediation
• Migration testing and production validation
• Experience with Informatica Data Quality/PowerCenter, Oracle, Redshift, Salesforce, JSON is a plus.