> Markdown version of [/jobs/ext/2585423-data-engineer-snowflake-migration](https://www.wearedevelopers.com/jobs/ext/2585423-data-engineer-snowflake-migration). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Engineer (Snowflake Migration)

- **Company:** Mphasis
- **Location:** United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Amazon Web Services, Amazon Elastic Compute Cloud, Amazon S3, Data Analysis, Business Logic, Batch Processing, Big Data, Databases, Continuous Integration, Data Validation, Information Engineering, Extract Transform Load (ETL), Data Warehousing, Github, Python (Programming Language), Microsoft SQL Server, Oracle (Applications), Oracle SQL Developer, Performance Tuning, Query Optimization, SQL Stored Procedures, SQL Server Integration Services, Data Processing, Data Ingestion, Informatica Powercenter, Snowflake, Integration Frameworks, Data Management, Cloudwatch, Data Pipelines, Legacy Systems, Jenkins, Control M
- **Published:** August 25, 2026
- **Apply:** https://www.dice.com/job-detail/cc656afe-a960-4b08-8795-3f8819b5ff96

## About the Role

Must Have:

 * 10+ years of Data Engineering, ETL, and Data Warehouse experience.
 * Strong Snowflake SQL development and performance tuning experience.
 * Experience migrating ETL processes from SSIS, Informatica, SQL Server, or Oracle environments.
 * Strong Python development skills.
 * Hands-on experience with Control-M scheduling and monitoring.
 * AWS experience with:

 * EC2
 * S3
 * AWS Batch
 * Secrets Manager
 * CloudWatch

GitHub and Jenkins CI/CD experience.

Experience with data comparison, reconciliation, and migration validation.

## Description

We are looking for an experienced Lead Data Engineer to support a large-scale Data Warehouse modernization and migration initiative. The ideal candidate will analyze existing ETL processes built on SSIS, Informatica, SQL Server Stored Procedures, and Oracle PL/SQL packages, understand the underlying business logic, and migrate them to Snowflake SQL and Python-based data processing frameworks.

This role requires strong expertise in Snowflake, Python, AWS, Control-M, GitHub, Jenkins, SSIS, Informatica, Oracle PL/SQL, SQL Server.. In addition to migration activities, the candidate will be responsible for data validation, report adoption support, and decommissioning legacy ETL processes.

Key Responsibilities:

 * Analyze and understand existing ETL and database processes built using:

 * SSIS
 * Informatica
 * SQL Server Stored Procedures
 * Oracle PL/SQL Packages

Convert and optimize existing business logic into Snowflake SQL.

Develop and maintain Python-based data ingestion and orchestration processes.

Build scalable data pipelines and batch processing solutions.

Configure, schedule, monitor, and troubleshoot jobs using Control-M.

Work with AWS services including EC2, S3, AWS Batch, Secrets Manager, and CloudWatch/Log Monitoring.

Perform Snowflake performance tuning and query optimization.

Execute data validation and reconciliation between legacy systems and Snowflake.

Partner with Reporting and Analytics teams to validate reports and ensure successful adoption of migrated data.

Support UAT, parallel runs, and production cutovers.

Decommission legacy ETL jobs, scheduling processes, and obsolete data platforms after successful migration.

Manage source code using GitHub and support CI/CD deployments through Jenkins.


## Related Videos

- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [The Road to MLOps: How Verivox Transitioned to AWS](https://www.wearedevelopers.com/videos/1050-the-road-to-mlops-how-verivox-transitioned-to-aws)
- [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next)
- [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data)
- [Our GitOps approach for deploying an Identity Provider and an API Gateway in a SaaS company](https://www.wearedevelopers.com/videos/776-our-gitops-approach-for-deploying-an-identity-provider-and-an-api-gateway-in-a-saas-company)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)