EITACIES Inc.Remote
Senior Data Engineer
California, United States of America
Full Time
2 weeks ago
$60 USD
No Visa Sponsorship
Key skills
ETLOracleSQLSnowflakedbtGitCI/CDCollaboration
About this role
Role Overview
- Support a large-scale Oracle to Snowflake migration initiative
- Involves dbt development, data transformation, pipeline validation and Snowflake optimization
- Strong collaboration across onsite and offshore teams
Requirements
- 5+ years Develop and maintain dbt models
- Perform Oracle to Snowflake data transformation
- Validate data using row count & checksum methods
- Monitor ETL pipelines and ensure data accuracy
- Optimize SQL for Snowflake performance
- Design Snowflake architecture (Bronze/Silver/Gold layers)
- Define dbt standards, macros and CI/CD practices
- Lead UAT and stakeholder coordination
- Handle critical migration issues and production cutover
- Manage offshore delivery teams
- Strong experience in dbt and Snowflake
- Advanced SQL skills
- Experience with Oracle to Snowflake migration
- Data validation and testing expertise
- Experience with Git, VS Code and CI/CD practices
- Bachelor's degree in Computer Science / IT or related field
Tech Stack
- ETL
- Oracle
- SQL