Oracle Data Integrator Technical Lead

Role: Senior Engineer

Required Skills: Oracle Data Integrator (ODI)

Qualification: BACHELOR OF COMPUTER SCIENCE

Experience: 10 - 18 Years

Function: TECHNOLOGY

Apply By: 2027-01-09

Must-Have Technical/Functional Skills

• Demonstrated extensive IT experience relevant to enterprise data integration and delivery.

• Minimum 4+ years of hands-on Oracle Data Integrator experience.

• Strong working knowledge of Oracle Data Integrator 12c.

• Hands-on expertise in:

• ODI Mappings

• Packages and Procedures

• Knowledge Modules

• Load Plans and Scenarios

• Scheduling and Job Monitoring

• Variables and Sequences

• Error Handling and Restartability

• Strong SQL skills and good understanding of relational database concepts.

• Good understanding of data warehousing, ETL/ELT concepts, source-to-target mappings, and data integration architecture.

• Hands-on experience with performance tuning and optimization of ODI jobs and SQL.

• Experience in data validation and reconciliation between source and target systems.

• Experience in ODI migration, release, and deployment activities across multiple environments.

• Proven experience across implementation, enhancement, and production support engagements.

• Strong troubleshooting and analytical skills.

• Good communication, technical documentation, and customer-interaction skills.

Roles & Responsibilities

• Design, develop, configure, and maintain Oracle Data Integrator (ODI) 12c solutions for enterprise data integration requirements.
• Develop and maintain ODI mappings, packages, procedures, scenarios, variables, sequences, and load plans.
• Configure and customize Knowledge Modules (KMs) based on integration and data-processing requirements.
• Design and manage load plans, scheduling, dependencies, exception handling, and restart/recovery mechanisms.
• Develop complex ETL/ELT workflows for extracting, transforming, and loading data across heterogeneous source and target systems.
• Work extensively with SQL for data extraction, transformation, validation, reconciliation, and troublesho oting.
• Support data warehouse and data integration solutions, including incremental and full-load processing.
• Perform performance tuning and optimization of ODI mappings, SQL queries, load processes, and batch jobs.
• Perform source-to-target data validation and reconciliation to ensure completeness and accuracy of data.
• Handle ODI code migration and deployment across development, test, UAT, and production environments.
• Participate in implementation, enhancement, testing, deployment, and production-support activities.
• Conduct root-cause analysis and resolve ODI batch failures, data issues, performance problems, and production incidents.
• Work closely with business users, database teams, application teams, and other integration stakeholders to understand and deliver requirements.
• Prepare technical designs, mapping specifications, deployment documents, support documents, and operational procedures.

Other Skills, If Any

• Experience integrating ODI with Oracle Database and enterprise applications such as Oracle EBS.
• Good knowledge of PL/SQL and database objects such as procedures, functions, views, and materialized views.
• Experience working with large data volumes and optimizing batch-processing performance.
• Understanding of ODI repository architecture, Master Repository and Work Repository, and ODI Agent configuration.
• Exposure to Linux/Unix scripting and enterprise job-scheduling tools would be advantageous.
• Experience working in global or distributed delivery environments.

Salary Range: $120,000 - $140,000 per year

TCS Employee Benefit and Summary:

Discretionary Annual Incentive.

Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.