> Markdown version of [/jobs/ext/655651-data-engineer-oracle-to-snowflake-migration](https://www.wearedevelopers.com/jobs/ext/655651-data-engineer-oracle-to-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 Oracle to Snowflake Migration - **Company:** Metalight Solutions Inc - **Location:** Santa Clara, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Airflow, Amazon Web Services, Data Analysis, Microsoft Azure, Big Data, Continuous Integration, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Migration, Data Profiling, Data Warehousing, DevOps, Dimensional Modeling, Information Lifecycle Management, Python (Programming Language), Oracle Databases, Oracle (Applications), Oracle SQL Developer, Performance Tuning, Query Optimization, SQL Stored Procedures, PL-SQL, Workflow Management Systems, Google Cloud, Snowflake, Database Optimization, Git, Data Pipelines, Sql Tuning - **Published:** June 26, 2026 - **Apply:** https://www.dice.com/job-detail/6e671c59-c33e-4356-a31e-fefdcbfcc91e ## About the Role * 5+ years of experience as a Data Engineer or similar role. * Strong hands-on experience with Oracle SQL, PL/SQL, and database performance tuning. * Proven experience migrating data to Snowflake, including Snowflake SQL, Snowpipe, Streams, Tasks, and Time Travel. * Proficiency with Python, ETL/ELT tools, and cloud platforms (AWS, Azure, or Google Cloud Platform). * Solid understanding of data warehousing concepts, dimensional modeling, and data governance. * Experience with CI/CD, Git, and DevOps practices for data engineering. Preferred Skills: * Experience with DBT, Airflow, or similar orchestration tools. * Knowledge of Informatica, Matillion, or Fivetran. * Familiarity with Snowflake cost optimization and workload management. * Strong analytical, communication, and cross functional collaboration skills. ## Description We are seeking a highly skilled Data Engineer to lead and execute large-scale data migration initiatives from Oracle databases to Snowflake on the cloud. The ideal candidate has deep expertise in data modeling, ETL/ELT development, performance optimization, and cloud data engineering best practices. This role will work closely with architecture, analytics, and platform engineering teams to ensure a seamless, secure, and high quality migration., * Design, build, and optimize data pipelines to migrate structured and semi structured data from Oracle to Snowflake. * Develop scalable ETL/ELT workflows using tools such as Informatica, DBT, Matillion, or Python-based frameworks. * Perform data profiling, validation, reconciliation, and quality checks to ensure accuracy and completeness post migration. * Optimize Snowflake warehouse performance, including clustering, partitioning, caching, and query tuning. * Collaborate with data architects to define data models, schemas, and transformation logic aligned with business requirements. * Implement best practices for security, governance, and data lifecycle management within Snowflake. * Troubleshoot migration issues related to SQL performance, data types, stored procedures, and dependencies. * Support CI/CD automation for data pipelines and maintain documentation for all migration processes. ## Related Videos - [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) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [DevOps Maturity Check – a way to balance autonomy and alignment](https://www.wearedevelopers.com/videos/58-devops-maturity-check-a-way-to-balance-autonomy-and-alignment) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [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) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [A Guide to Green Tech and Green IT Careers](https://www.wearedevelopers.com/magazine/374-a-guide-to-green-tech-and-green-it-careers)