Oracle ODI Developer

Our client is a global technology company headquartered in Santa Clara, California. it focuses on helping organisations harness the power of data to drive digital transformation, enhance operational efficiency, and achieve sustainability. over 100 years of experience in operational technology (OT) and more than 60 years in IT to unlock the power of data from your business, your people and your machines. We help enterprises store, enrich, activate and monetise their data to improve their customers’ experiences, develop new revenue streams and lower their business costs. Over 80% of the Fortune 100 trust our client for data solutions.

The company’s consolidated revenues for fiscal 2024 (ended March 31, 2024). approximately $57.5 billion USD., and the company has approximately 296,000 employees worldwide. It delivers digital solutions utilising Lumada in five sectors, including Mobility, Smart Life, Industry, Energy and IT, to increase our customers’ social, environmental and economic value.

• Job Title: Oracle ODI Developer
• Location: Gurgaon
• Experience: 9 To 12 Years
• Job Type: Contract to hire.
• Notice Period: Immediate joiners.
• Mandatory Skills:

Key Responsibilities:

Design and develop PL/SQL packages, procedures, functions, trigger, views and materalized views.

Optimize SQL queries and database performance.

Perform unit testing and support system testing and UAT.

Troubleshoot and resolve production issues related to database and backend logic.

Maintain documentation for code, processes, and configurations.

Design and develop ETL solutions using Oracle Data Integrator (ODI).

Create and manage ODI mappings, packages, procedures, and load plans.

Integrate data from various sources including Oracle, SQL Server, flat files.

Monitor and troubleshoot ODI jobs and performance issues.

Collaborate with data architects, DBAs, and business analysts to understand requirements.

Maintain and optimize existing ODI workflows and repositories.

Ensure data quality, consistency, and security across integration processes.

Document technical specifications, workflows, and operational procedures."