ODI development - ETL

Role: ODI development - ETLLocation: Seattle, WA - OnsiteContractExperience Required8–10 years of relevant ETL / ODI development experienceKey ResponsibilitiesODI Development & ETLDesign, 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:LKMIKMCKMJKMHandle incremental, full, and CDC‑based data loads.Implement robust error handling, restartability, logging, and auditing frameworks.Data & Database ManagementWork 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 & SupportTune ODI jobs for high‑volume and high‑performance batch processing.Monitor ODI scenarios, sessions, and logs.Troubleshoot and resolve production issues efficiently.Integration & CollaborationIntegrate data from multiple source systems, including:Oracle databasesFlat filesXMLREST APIsThird‑party systemsCollaborate with:Data architectsBI teamsDBAsBusiness stakeholdersParticipate in design discussions and technical review sessions.Deployment & DocumentationManage 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 & QualificationsStrong 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)