Technical lead - Python, Oracle PL/SQL, Java
India
Apply now
Job Description
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
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
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion.