Sr ODI Developer

Role: ODI Developer

Location: Remote

Duration: 12+ Months

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.