Data Engineer - Oracle data integrator and BI

We are currently seeking a Data Engineer - Oracle data integrator and BI to join our team in NA, Texas (US-TX), United States (US).

Job Description: Data Engineer – Oracle Data Integrator (ODI) & BI Specialist (Intermediate Level)

Project: – Project Sunshine

Role Overview

We are seeking an Intermediate-Level Data Engineer with expertise in Oracle Data Integrator (ODI) and Business Intelligence (BI) to support the Project Sunshine initiative. This role will focus on designing, developing, and supporting data pipelines and BI solutions that enable reliable, high-quality data delivery for analytics and reporting.

Key Responsibilities

Data Engineering & Oracle Data Integrator (ODI) Development

Design, develop, and maintain ETL/ELT pipelines using Oracle Data Integrator (ODI)

Build and manage data integration workflows for ingesting and transforming data from multiple sources

Develop reusable data integration components and frameworks

Ensure data pipelines are scalable, reliable, and optimized for performance

Data Pipeline Operations & Support

Monitor, troubleshoot, and support production data pipelines (L2/L3 support)

Perform root cause analysis (RCA) and resolve data processing issues

Manage job scheduling, execution, and failure recovery processes

Ensure consistent and timely data availability across platforms

Data Modeling & Integration

Support logical and physical data modeling aligned to enterprise standards

Perform source-to-target mapping and define transformation logic

Integrate data across enterprise systems and maintain data consistency

Maintain metadata, data lineage, and documentation for pipelines and models

Business Intelligence & Reporting Support

Support BI reporting tools and platforms (e.g., Power BI, Tableau, or similar)

Develop and optimize datasets for reporting and analytics

Collaborate with BI developers to ensure accurate data delivery for dashboards

Support performance optimization for reporting queries and semantic layers

Performance Optimization & Data Quality

Optimize ETL processes and query performance to improve efficiency

Implement data quality checks, validation rules, and reconciliation processes

Identify and resolve data anomalies and inconsistencies

Continuously improve pipeline performance and reliability

Collaboration & Delivery

Work closely with data architects, DBAs, BI developers, and business stakeholders

Translate business requirements into technical data pipeline solutions

Participate in Agile development processes and sprint cycles

Support data platform modernization initiatives within Project Sunshine

Required Qualifications

3–6 years of experience in Data Engineering, ETL development, or data integration roles

Hands-on experience with Oracle Data Integrator (ODI)

Experience building and supporting enterprise data pipelines

Strong experience working with large, complex datasets

Technical Skills

Strong SQL and data integration expertise

Experience with Oracle databases and data platforms

Experience with ETL/ELT tools and pipeline orchestration

Experience with BI tools (Power BI, Tableau, Cognos, or similar)

Familiarity with scripting or programming languages (Python, Shell, etc.)

Preferred Qualifications

Experience with cloud data platforms (Azure preferred)

Exposure to data warehousing and dimensional modeling concepts

Experience in healthcare or regulated environments

Experience supporting data modernization or migration initiatives

Key Success Metrics

Reliable and efficient data pipeline performance

High-quality data delivery for BI and analytics use cases

Reduced pipeline failures and faster incident resolution

Successful delivery of Project Sunshine data integration milestones

About NTT DATA:

NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com