> Markdown version of [/jobs/ext/4275121-data-architect-oracle-to-snowflake-migration-iics](https://www.wearedevelopers.com/jobs/ext/4275121-data-architect-oracle-to-snowflake-migration-iics). 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 Architect (Oracle to Snowflake Migration & IICS)

- **Company:** TRUSTIT LLC
- **Location:** Franklin, TN, United States
- **Contract:** Contract
- **Skills:** Amazon Web Services, Amazon S3, Continuous Integration, Data Architecture, Data Validation, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Dimensional Modeling, Python (Programming Language), Meta-Data Management, Oracle (Applications), Oracle SQL Developer, Performance Tuning, Role-Based Access Control, Cloud Services, Migration Manager, DataOps, SQL Stored Procedures, PL-SQL, Enterprise Data Management, Snowflake, Database Migration, Git Flow, Information Technology, Physical Data Models, Data Pipelines
- **Published:** October 26, 2026
- **Apply:** https://www.dice.com/job-detail/0049dfcb-9422-4dc3-9399-6dbb1534b84f

## About the Role

* Proven hands-on experience as a Data Architect designing and delivering enterprise data platforms.
 * Demonstrated experience executing end-to-end Oracle to Snowflake database migrations.
 * Strong hands-on experience using erwin Data Modeler for enterprise schema design.
 * Expert knowledge of Snowflake features (warehouses, stages, Streams, Tasks, Stored Procedures, Time Travel, RBAC).
 * Deep experience with IICS (Informatica Intelligent Cloud Services) for data integration and ETL/ELT workflow conversion.
 * Practical Oracle background (PL/SQL, data modeling, performance tuning) and advanced SQL optimization skills.
 * Bachelor s or Master s degree in Computer Science, IT, Data Engineering, or a related field., * Experience with schema conversion/migration accelerators (e.g., SnowConvert).
 * Knowledge of Python or Snowpark for data transformation and automation.
 * Exposure to AWS (S3), CI/CD pipelines, Git workflows, and DataOps practices.
 * SnowPro Advanced Architect certification.

## Description

* Core Specialty: Enterprise Data Architecture, Database Migration (Oracle to Snowflake), Data Governance, Medallion Architecture
 * Data Modeling: erwin Data Modeler (Conceptual, Logical, Physical)
 * Primary Tech Stack: Snowflake (Streams, Tasks, Stored Procedures, Snowpipe, Time Travel, RBAC), Oracle PL/SQL, IICS (Informatica Intelligent Cloud Services)
 * Preferred Tools & Credentials: SnowConvert, AWS S3, Python / Snowpark, DataOps / CI/CD, SnowPro Advanced Architect Certification, * Oracle to Snowflake Migration: Lead the migration strategy and execution for moving enterprise data and workloads from Oracle to Snowflake, including schema conversion, data validation, and performance tuning.
 * IICS Re-Platforming: Re-engineer existing Informatica Intelligent Cloud Services (IICS) workflows to Snowflake-native ELT pipelines (Streams, Tasks, Stored Procedures, Snowpipe).
 * Enterprise Data Modeling: Design and maintain conceptual, logical, and physical data models using erwin Data Modeler, enforcing dimensional modeling and data warehousing best practices.
 * Modern Architecture & Governance: Implement Medallion architecture patterns (Bronze/Silver/Gold) and define data governance standards (data quality, lineage, metadata management, cataloging, RBAC).
 * Performance & Cost Optimization: Optimize query execution, virtual warehouse performance, and storage cost efficiency across the Snowflake environment.