Senior ODI Developer

Role Overview:

Senior ODI Developer

SQL

PL/SQL

Oracle Data Integrator (ODI)

OCI (Oracle Cloud Infrastructure)

banking

insurance

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:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• 5 to 8 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.
  

Responsibilities

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.
  

Qualifications

About Us