ODI Developer [BizID#6798]

Title: ODI Developer [BizID#6798]

Location: Bellevue, WA (Remote)

Experience: 9+ years

Job Description:

Primary Duties and Responsibilities:

• Translate business and functional requirements into documented technical specifications.
• Utilize development skills to build (code) and unit test new systems functionality per technical specifications, with deliverables to include code builds and documented unit test results
• Assist with application support documentation (release notes, build instructions) as required by the application support teams for acceptance of changes into production
• Assist with troubleshooting, triaging and resolving issues discovered during QAT/UAT (testing phases)
• Act as primary Customer Hub ODI SME for driving/providing LOEs as necessary for new project intake, change requests, production issues, etc
• Facilitate/lead reviews (walkthroughs) of technical specifications and program code with other members of the technical team, communicating design, requirements, feature set, functionality and limitations of systems/applications to team and development lead.

Secondary Duties and Responsibilities:

• Utilize departmental Systems Development Lifecycle Methodology as a guide for development activities.
• Provide on call and after hours support as required for production releases and to respond and provide Tier 1 support on production outages.
• Contribute to and work to meet project schedules by providing accurate estimates of effort required for development deliverables, by providing updates on project progress to development and project management, and by escalating issues that might affect project success to management.
• Maintain technical skills and expertise through continuing education and training.
• Collaborate/Partner with other teams, both internal and external, including 3rd party vendors, Enterprise Testing, Release Planning and Management, Business Systems Analysis, Project Management, and Application Support on successful delivery of systems enhancements.

ODI Developer:

• 3 5 years of demonstrated expertise in ODI 11g & 12c
• Installation, configuration of ODI 12c in Unix / Linux environments.
• Strong knowledge of SQL and working knowledge on PL/ SQL.
• Hands on experience in ODI scripting using python or Java
• Expertise in configuration, setup and deploying applications in WebLogic server.
• Strong knowledge in WebLogic to configure clustering
• Troubleshooting WebLogic server issues.
• Performance tuning of SQLs, ODI, Weblogic and JVM.
• Experience with Oracle Database and flat file systems.
• Experience with CDC using Golden gate and ODI.
• ETL jobs for extracting and loading large volumes of data between two databases.
• Configuring web services in ODI.
• Scheduling ODI jobs, configuration of monitoring and altering mechanisms.
• Troubleshoot and resolve QAT and production issues.
• Good documentation skills for preparing installation, configuration and deployment steps.
• Web/Data Service in ODI (Inbound & Lookup)
• Integration using JMS and ODI
• ODI integration with NoSQL (like Cassandra)
• ODI using spark & sqoop
• ODI Oracle restful services
• ODI EDQ adapters
• ODI GG
• ODI JSON
• Load data from Oracle DB & Files using ODI into Oracle database
• Load balancing & HS in ODI