DescriptionJob Description: Senior ODI Developer (OCI PaaS/IaaS Expertise)
Role Overview:
We are seeking a highly skilled Senior ODI Developer with strong hands-on experience in SQL PL/SQL and Oracle Data Integrator (ODI) projects particularly on OCI (Oracle Cloud Infrastructure) PaaS or IaaS platforms. The ideal candidate will design implement and optimize ETL processes leveraging cloud-based solutions to meet evolving business needs. Prior experience in banking or insurance projects is a significant advantage.
Key Responsibilities:
- Design develop and deploy ETL processes using Oracle Data Integrator (ODI) on OCI PaaS/IaaS.
- Configure and manage ODI instances on OCI ensuring optimal performance and scalability.
- Develop and optimize complex SQL and PL/SQL scripts for data extraction transformation and loading.
- Implement data integration solutions connecting diverse data sources like cloud databases on-premise systems APIs and flat files.
- Monitor and troubleshoot ODI jobs running on OCI to ensure seamless data flow and resolve any issues promptly.
- Collaborate with data architects and business analysts to understand integration requirements and deliver robust solutions.
- Conduct performance tuning of ETL processes SQL queries and PL/SQL procedures.
- Prepare and maintain detailed technical documentation for developed solutions.
- Adhere to data security and compliance standards particularly in cloud-based environments.
- Provide guidance and best practices for ODI and OCI-based data integration projects.
Skills and Qualifications:
- Mandatory Skills:
- Strong hands-on experience with Oracle Data Integrator (ODI) development and administration.
- Proficiency in SQL and PL/SQL for complex data manipulation and query optimization.
- Experience deploying and managing ODI solutions on OCI PaaS/IaaS environments.
- Deep understanding of ETL processes data warehousing concepts and cloud data integration.
- Preferred Experience:
- Hands-on experience in banking or insurance domain projects with knowledge of domain-specific data structures.
- Familiarity with OCI services like Autonomous Database Object Storage Compute and Networking.
- Experience in integrating on-premise and cloud-based data sources.
- Other Skills:
- Strong problem-solving and debugging skills.
- Excellent communication and teamwork abilities.
- Knowledge of Agile methodologies and cloud-based DevOps practices.
Education and Experience:
- Bachelors degree in computer science Information Technology or a related field.
- 4 to 6 years of experience in ODI development with at least 2 years of experience in OCI-based projects.
- Domain experience in banking or insurance is an added advantage.
Career Level - IC2
ResponsibilitiesKey Responsibilities:
- Design develop and deploy ETL processes using Oracle Data Integrator (ODI) on OCI PaaS/IaaS.
- Configure and manage ODI instances on OCI ensuring optimal performance and scalability.
- Develop and optimize complex SQL and PL/SQL scripts for data extraction transformation and loading.
- Implement data integration solutions connecting diverse data sources like cloud databases on-premise systems APIs and flat files.
- Monitor and troubleshoot ODI jobs running on OCI to ensure seamless data flow and resolve any issues promptly.
- Collaborate with data architects and business analysts to understand integration requirements and deliver robust solutions.
- Conduct performance tuning of ETL processes SQL queries and PL/SQL procedures.
- Prepare and maintain detailed technical documentation for developed solutions.
- Adhere to data security and compliance standards particularly in cloud-based environments.
- Provide guidance and best practices for ODI and OCI-based data integration projects.
QualificationsCareer Level - IC2
Required Experience:
Senior IC