Oracle Data Integrator Technical Lead

Tata Consultancy Services Limited

Mentor (OH)

On-site

USD 120,000 - 140,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Discretionary Incentive
Medical Coverage
401K Plan
Certification & Training Reimbursement
Vacation & Holidays

Job summary

Tata Consultancy Services Limited in Mentor, OH is seeking a Senior Engineer with deep ODI expertise to design, develop, and maintain ODI 12c data integration solutions for enterprise environments. You will craft mappings, packages, and load plans, and optimize performance while ensuring data accuracy across sources and targets.

The role requires hands-on ODI, SQL, and warehousing knowledge, plus experience with migrations, deployments, and incident resolution in a global delivery context.

Qualifications

  • Extensive IT experience in enterprise data integration and delivery.
  • 4+ years hands-on ODI experience.
  • Strong knowledge of ODI 12c and mappings, packages, procedures, scenarios, and load plans.
  • Experience with performance tuning and optimization of ODI jobs and SQL.
  • Data validation and reconciliation across source/target systems.
  • ODI migration, release and deployment across environments.

Responsibilities

  • Design, develop, configure, and maintain ODI 12c solutions for enterprise data integration.
  • Develop and maintain ODI mappings, packages, procedures, scenarios, variables, sequences, and load plans.
  • Configure Knowledge Modules (KMs) and manage load plans, scheduling and restart mechanisms.
  • Develop ETL/ELT workflows and perform data extraction, transformation, and loading across systems.
  • Work with SQL for data extraction, validation, and troubleshooting and support data warehouse solutions.
  • Handle ODI code migration and deployment across development, test, UAT, and production environments.

Skills

ODI 12c
SQL
Data Warehousing
ETL/ELT
Load Plans
Knowledge Modules
Performance Tuning
Data Validation
Migration & Deployment
Troubleshooting
Documentation
Communication

Education

Bachelor's degree in Computer Science

Tools

Oracle Database
Oracle EBS
PL/SQL
Linux/Unix scripting

Job description

Job Description
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
  1. Design, develop, configure, and maintain Oracle Data Integrator (ODI) 12c solutions for enterprise data integration requirements.
  2. Develop and maintain ODI mappings, packages, procedures, scenarios, variables, sequences, and load plans.
  3. Configure and customize Knowledge Modules (KMs) based on integration and data-processing requirements.
  4. Design and manage load plans, scheduling, dependencies, exception handling, and restart/recovery mechanisms.
  5. Develop complex ETL/ELT workflows for extracting, transforming, and loading data across heterogeneous source and target systems.
  6. Work extensively with SQL for data extraction, transformation, validation, reconciliation, and troubleshooting.
  7. Support data warehouse and data integration solutions, including incremental and full-load processing.
  8. Perform performance tunin g and optimization of ODI mappings, SQL queries, load processes, and batch jobs.
  9. Perform source-to-target data validation and reconciliation to ensure completeness and accuracy of data.
  10. Handle ODI code migration and deployment across development, test, UAT, and production environments.
  11. Participate in implementation, enhancement, testing, deployment, and production-support activities.
  12. Conduct root-cause analysis and resolve ODI batch failures, data issues, performance problems, and production incidents.
  13. Work closely with business users, database teams, application teams, and other integration stakeholders to understand and deliver requirements.
  14. 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.
Location

Mentor, OH

Function

TECHNOLOGY

Role

Senior Engineer

ID

438898

Skills

Oracle Data Integrator (ODI)

Desired Candidate Profile

Qualifications

BACHELOR OF COMPUTER SCIENCE

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Oracle Developer
Senior Oracle Developer

Motion Recruitment • Irving (TX)

On-site
USD 100,000 - 130,000
ODI Developer
ODI Developer

Cambay • Chicago (IL)

On-site
USD 90,000 - 115,000
ODI Technical Lead: Enterprise Data Integration
ODI Technical Lead: Enterprise Data Integration

Tata Consultancy Services Limited • Mentor (OH)

On-site
USD 120,000 - 140,000
Discretionary Incentive
Medical Coverage
401K Plan
+2
Oracle Data Integrator (ODI)
Oracle Data Integrator (ODI)

Sonsoft Inc • Baltimore (MD)

On-site
USD 90,000 - 150,000
Senior ODI Developer: Lead Oracle Data Integration
Senior ODI Developer: Lead Oracle Data Integration

Motion Recruitment • Irving (TX)

On-site
USD 100,000 - 130,000
Oracle Data Integration
Oracle Data Integration

Pyramid Global Technologies • Austin (TX)

On-site
AUD 120,000 - 180,000
Sr. Oracle ODI ETL Developer (Remote)
Sr. Oracle ODI ETL Developer (Remote)

Cedent • United States

Remote
USD 55,104 - 82,656
Health Insurance
Dental Insurance
Vision Insurance
ODI Developer
ODI Developer

Spruce Infotech • Austin (TX)

On-site
USD 90,000 - 120,000
Senior ODI Engineer - Local to Tampa, FL Only
Senior ODI Engineer - Local to Tampa, FL Only

Noblesoft Solutions • Saint Petersburg (FL)

On-site
USD 80,000 - 100,000
Senior Data Engineer
Senior Data Engineer

The Hanover Insurance Group • Worcester (MA)

Remote
USD 105,000 - 130,000