Msp OwnerLocation: Seattle, WA Duration: 6 monthsSkill ID: Experience Required: 8–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: LKMIKMCKMJKM.Handle 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 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 & 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.