Information Technology_USA - USA_Developer

**Please strictly adhere to the following resume naming convention:

ALL CAPS, NO SPACES BETWEEN UNDERSCORES

PTN_US_GBAMSREQID_CandidateBeelineID
Example: PTN_US_9999999_SKIPJOHNSON0413

: -


MSP Owner: Michelle Lee
Location: Seattle, WA
Duration: 6 months
skill id: 10680548

Experience Required

8-10 years of relevant ETL / ODI development experience

Key Responsibilities
ODI Development & ETL

Design, develop, and implement ODI mappings, packages, procedures, and load plans.
Build and maintain ELT data integration workflows with performance optimization.
Develop reusable Knowledge Modules, including:

LKM
IKM
CKM
JKM

Handle incremental, full, and CDC-based data loads.
Implement robust error handling, restartability, logging, and auditing frameworks.

Data & Database Management

Work extensively with Oracle databases (11g, 12c, 19c).
Develop and optimize complex SQL and PL/SQL queries for large-volume datasets.
Ensure data quality, consistency, and integrity across target systems.
Perform impact analysis for schema changes and data model updates.

Performance Monitoring & Support

Tune ODI jobs for high-volume and high-performance batch processing.
Monitor ODI scenarios, sessions, and logs.
Troubleshoot and resolve production issues efficiently.

Integration & Collaboration

Integrate data from multiple source systems, including:

Oracle databases
Flat files
XML
REST APIs
Third-party systems

Collaborate with:

Data architects
BI teams
DBAs
Business stakeholders

Participate in design discussions and technical review sessions.

Deployment & Documentation

Manage ODI deployments across environments:

Development (DEV)
System Integration Testing (SIT)
User Acceptance Testing (UAT)
Production (PROD)

Support production releases, hotfixes, and post-deployment validation.
Create and maintain technical documentation and operational runbooks.

Required Skills & Qualifications

Strong hands-on experience with Oracle Data Integrator (ODI).
Expertise in ETL/ELT design and performance tuning.
Proficient in Oracle SQL and PL/SQL.
Experience supporting enterprise-scale data integration solutions.
Strong analytical, troubleshooting, and communication skills.

Skills: Oracle Data Integrator (ODI), Project Code :