Snowflake Data Migration Engineer w/ Python
Hiring : Snowflake Data Migration Engineer w/ Python
Location: 100% Remote Duration : 12–18 Months
Experience: 12+ years
Pay Rate: $65–70/hr C2C Eligibility : USC Only
Interview: Video Interview
Job Description
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· LinkedInSenior 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 SQLData Quality Controls & Validation
- Data Migration & Reconciliation
- Data Profiling & Root-Cause Analysis
- Source-to-Target / Field MappingETL/ELT & Data Integration
- PythonAWS / S3Data 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.