Job Summary
We are seeking an experienced ODI Developer with Snowflake to design, develop, and support ETL/ELT solutions for enterprise data integration.
The ideal candidate will have hands-on experience with Oracle Data Integrator (ODI), Oracle RMS, Snowflake, SQL, and data warehousing.
Key Responsibilities
- Develop and maintain ETL/ELT processes using ODI.
- Design and optimize data pipelines in Snowflake.
- Create ODI mappings, packages, and load plans.
- Develop complex SQL queries and stored procedures.
- Perform data validation, troubleshooting, and performance tuning.
- Collaborate with cross-functional teams to deliver data integration solutions.
Required Skills
- 5+ years of Oracle Data Integrator (ODI) experience.
- 2+ years of Snowflake experience.
- Good to have experience with Oracle RMS.
- Strong SQL and Oracle Database knowledge.
- Experience with ETL/ELT and data warehousing concepts.
- Familiarity with Snowpipe, Streams, and Tasks is a plus.
- Experience with Git, Jenkins, Python, or cloud platforms (AWS/Azure) is preferred.