Data Architect (Oracle to Snowflake Migration & IICS)

• 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.