Analyze, interpret, and reverse-engineer existing Oracle Data Integrator (ODI) workflows and data transformation logic
Document and understand current data flows, dependencies, and legacy data structures
Design Snowflake-optimized data models and ELT patterns that improve performance and scalability
Write performance-aware SQL and implement ELT transformations within Snowflake
Restructure inefficient or “stair-step” legacy models into normalized, maintainable, and scalable architectures
Cleanse legacy artifacts, including redundant columns, null-handling inconsistencies, and outdated dependencies
Design conformed and curated data objects to support analytics and reporting needs
Build modular, testable transformation pipelines using DBT or approved transformation tools
Manage Snowflake development environments, including roles, access control, and governance for development work
Establish data validation and reconciliation patterns to compare Oracle vs. Snowflake resultsImplement data quality checks to ensure accuracy and consistency during migration
Collaborate closely with QA and review teams to validate transformation logic and performance outcomes
Requirements
Must reside within the United States
Must be authorized to work in the United States without sponsorship now or in the future
Must be able to pass a background check
Tech Stack
Oracle
SQL
Benefits
Work remotely anywhere in the United States with flexible work hours