Technical lead - Python, Oracle PL/SQL, Java

Job Summary

JD: Oracle Data Integrator
Role Overview
We are seeking a highly experienced ODI Architect with deep expertise in Oracle Data Integrator (ODI) 12c and 14c to lead the design, development, optimization, and automation of enterprise-scale data integration solutions. The candidate should have strong ELT/ETL fundamentals, hands‑on ODI configuration and orchestration experience, excellent PL/SQL skills, and the ability to translate complex business requirements into robust data integration architectures.

Required Skills & Experience

Core ODI Expertise
10+ years of hands‑on experience in Oracle Data Integrator (ODI) 12c & 14c.
Strong experience in ODI design, development, configuration, and performance tuning.
Expertise in ODI agents, load plans, scenarios, KMs, topologies, and security.

Database & PL/SQL
Deep experience in Oracle PL/SQL including:
Packages, procedures, functions
Triggers, views, materialized views
Advanced exception handling
Performance tuning & optimization

Strong understanding of Oracle database architecture and SQL tuning.
ETL/ELT & Data Engineering- Excellent knowledge of ETL/ELT concepts, data modeling, data warehousing, and integration design.
Experience working with large volumes of data, complex transformations, and enterprise data flows.

Automation
Practical experience with Ansible, Groovy, or similar automation tools/scripts.
Ability to automate ODI deployments, configuration, and recurring operational tasks.

Preferred Skills (Nice to Have)
Knowledge of Oracle Cloud / OCI Data Integration services.
Experience with Git, Jenkins, Azure DevOps, or similar DevOps tools.
Exposure to real‑time or near real‑time streaming integrations.

Key Attributes
Strong analytical and problem‑solving skills.
Ability to lead and mentor development teams.
Excellent communication and client management skills

Key Responsibilities

1. Lead a team of developers in the design, development, and implementation of software solutions using python, pl/sql, and java.
2. Collaborate with project managers and stakeholders to define technical requirements and create project timelines.
3. Conduct code reviews, provide technical guidance, and ensure adherence to coding standards and best practices.
4. Troubleshoot technical issues, identify and implement solutions to enhance system performance and reliability.
5. Stay updated on emerging technologies and recommend software upgrades to optimize operational efficiency.

Skill Requirements

null

Other Requirements

null