Oracle Data Integrator (ODI) Developer/ Lead

United States Digital Space LLC; Karnataka; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

United States Digital Space LLC seeks an experienced Data Engineer / Data Integrator (ODI) Developer to design, develop, optimize, and support enterprise Data Warehouse solutions using ODI, SQL, and PL/SQL. The role emphasizes building scalable ETL/ELT pipelines and data integration frameworks for a fast-paced enterprise environment.

The ideal candidate will have 4+ years of ODI development, end-to-end DW implementation experience, performance tuning, and strong communication skills to translate

Qualifications

• Bachelor's Degree in Computer Science, Information Systems, Software Engineering or related discipline (or equivalent experience).
• 4+ years of ODI development experience.
• End-to-end Data Warehouse implementation experience.
• Strong SQL and PL/SQL expertise.
• ETL/ELT architecture and implementation.
• ODI Repositories, Designer, Operator, Agents, Load Plans.
• Knowledge Modules (KM) customization.
• Performance tuning.
• Data modelling.
• Git version control.
• Strong communication skills.
• Experience translating business requirements into technical solutions.

Responsibilities

• Design, develop, test, deploy, and maintain enterprise ETL/ELT solutions using ODI.
• Develop reusable mappings, load plans, workflows, and automation frameworks.
• Design and optimize SQL and PL/SQL packages, procedures, functions, triggers, and views.
• Implement data quality, auditing, exception handling, error recovery, and logging frameworks.
• Optimize ETL jobs, SQL queries, indexing, and partitioning strategies for high performance.
• Build and maintain scalable data warehouse schemas and validate data integrity.
• Collaborate with business users to convert business requirements into technical specifications.
• Manage code using Git and participate in deployment, testing, and production support activities.

Skills

ODI development

Data warehouse design

ETL/ELT pipelines

SQL

PL/SQL

Performance tuning

Data modelling

Git version control

Communication skills

Requirements translation

Education

Bachelor's Degree in Computer Science or related field

Tools

ODI

Git

SQL/PLSQL

Job description

We are looking for an experienced Data Engineer / the company Data Integrator (ODI) Developer to design, develop, optimize, and support enterprise Data Warehouse solutions using the company Data Integrator (ODI), the company Database, and PL/SQL.

The ideal candidate has strong experience building scalable ETL/ELT pipelines, optimizing database performance, developing reusable integration frameworks, and partnering with business stakeholders to translate requirements into technical solutions.

This role requires excellent analytical skills, hands-on the company database expertise, and the ability to deliver high-quality solutions in a fast-paced enterprise environment.

Key Responsibilities

• Design, develop, test, deploy, and maintain enterprise ETL/ELT solutions using the company Data Integrator (ODI).
• Develop reusable mappings, load plans, workflows, and automation frameworks.
• Design and optimize the company SQL and PL/SQL packages, procedures, functions, triggers, and views.
• Implement data quality, auditing, exception handling, error recovery, and logging frameworks.
• Optimize ETL jobs, SQL queries, indexing, and partitioning strategies for high performance.
• Build and maintain scalable data warehouse schemas and validate data integrity.
• Collaborate with business users to convert business requirements into technical specifications.
• Manage code using Git and participate in deployment, testing, and production support activities.

Qualifications & Skills

Mandatory

• Bachelor's Degree in Computer Science, Information Systems, Software Engineering or related discipline (or equivalent experience)
• 4+ years of the company Data Integrator (ODI) development experience
• End-to-end Data Warehouse implementation experience
• the company SQL and PL/SQL expertise
• ETL / ELT architecture and implementation
• ODI Repositories, Designer, Operator, Agents, Load Plans
• Knowledge Modules (KM) customization
• Performance tuning
• Data modelling
• the company Database development
• Git version control
• Strong communication skills
• Experience translating business requirements into technical solutions

Good-to-Have

• Python scripting
• Shell scripting
• AI / Generative AI awareness
• AI-assisted Data Engineering tools
• Financial Services domain experience
• Experience working in global enterprise environments

Self-Assessment Questions

• Do I have 4+ years of hands-on the company Data Integrator (ODI) development experience?
• Have I independently delivered end-to-end Data Warehouse implementations?
• Am I comfortable developing advanced the company SQL and PL/SQL solutions?
• Have I optimized ETL workflows for performance and scalability?
• Can I translate business requirements into technical ETL designs with minimal supervision?