Data Architect (Oracle to Snowflake Migration & IICS)
TRUSTIT LLC
Franklin, TN, United States
8 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source
Tech stack
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
+18 more
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
Job 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.
Requirements
- 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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦