Talent.com
Senior ODI Consultant

Senior ODI Consultant

Oraclemumbai, maharashtra, in
1 day ago
Job description

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 :

  • 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.
    • Create a job alert for this search

    Senior Consultant • mumbai, maharashtra, in