Oracle - FDI OAC ODI - Senior Associate

About the role

You will have the opportunity to contribute to work that may involve building new ELT/ETL pipelines; migrating on-premise integration workloads to the cloud; modernizing legacy Data Warehouse feeds; and integrating Oracle Data Integrator with GoldenGate, OCI Data Integration, and other Oracle data platform services.

What you'll do

• As an ODI developer, you will have multiple responsibilities depending on the project type
• One type of project may involve migrating existing ETL/ELT workloads to Oracle Cloud Infrastructure
• Another might involve building new integration pipelines directly within ODI, or modernizing them using OCI GoldenGate Data Transforms
• Design, develop, and implement ETL/ELT processes using Oracle Data Integrator (ODI) to extract, transform, and load data across heterogeneous source and target systems
• Design and build reusable Knowledge Modules (KMs), including customization of RKM, LKM, IKM, and CKM for specific project needs

What you need

• 5–8 yrs of experience
• SQL
• ETL
• Data warehousing
• Hadoop
• Spark
• Kafka
• B.Tech or B.E. or M.Sc

Good to have

• Python
• R
• Shell scripting
• Data modelling
• LLMs
• CI/CD