Find & Apply For Database Architect Jobs in Franklin, Tennessee

Position Title:

Data Architect Oracle to

Snowflake Migration Lead Location:

Franklin, TN (Hybrid)

Duration:

12+ Months (Contract)

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 Key Responsibilities:

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.

Required Qualifications & Skills:

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.

Preferred Qualifications:

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.