Senior Snowflake Data Migration Engineer (SQL / Python)
Job Description
OperAxis is hiring a Senior Snowflake Data Migration Engineer for a Banking / Financial Services client. You'll make sure data is accurately profiled, validated, transformed, reconciled and migrated from legacy and source systems into Snowflake, building data quality controls across the full migration lifecycle, from source assessment through production validation. The ideal candidate has hands-on experience with complex enterprise datasets, Snowflake development, source-to-target mapping and data quality implementation, plus excellent communication skills. Duration: 12-18+ months Requirements • Strong Snowflake and advanced SQL • Data quality controls, validation and reconciliation for large-scale migrations • Data profiling, root-cause analysis and exception reporting • Source-to-target and field mapping, transformation analysis and fit-gap assessment • ETL/ELT and data integration • Python for automated validation and data processing • AWS / S3 • Migration testing, UAT, production cutover and post-migration validation • Excellent written and verbal communication • Active LinkedIn profile • Preferred: Informatica Data Quality / PowerCenter, Oracle, Redshift, Salesforce and JSON • Must be a U.S. citizen
Responsibilities
- Design and implement data quality controls for large-scale data migrations into Snowflake
- Profile source data to find completeness, accuracy, consistency, duplication and formatting issues
- Define pre-migration and post-migration validation controls, and write SQL-based data quality rules and validation queries
- Perform source-to-target mapping, field mapping, transformation analysis and fit-gap assessments
- Develop Snowflake SQL and ETL/ELT processes for cleansing, transformation, migration and integration
- Build reconciliation controls for record counts, key attributes, transformations and source-to-target accuracy
- Investigate migration exceptions and data quality defects, run root-cause analysis and coordinate remediation
- Automate validation and processing with SQL and Python, and build Snowflake views, extracts, dashboards and exception reports
- Support migration testing, UAT, production cutover and post-migration validation
- Work with data engineers, architects, analysts and business stakeholders on acceptance criteria and migration controls