Technical lead - Python, Oracle PL/SQL, Java

Noida, Uttar Pradesh

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

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

Key Responsibilities

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

📌 Technical lead - Python, Oracle PL/SQL, Java (Noida)
🏢 HCLTech
📍 Noida