Description
6 months, possible extension.
8+ years of experience with Oracle DB, ETL, and Data integration technologies including Star Schema design
5+ years of experience with Oracle Data Integrator (ODI) in Data Warehouse and MDM environments Hands on experience with Oracle RAC on Unix/Linux platform
Hands on experience with Oracle Golden Gate (as it relates to ODI Change Data Capture)
Hands on experience with ODI in a High Availability environment including WebLogic clustering and Load balancing
Hands on experience with ODI Administrative tools including OEM and ODI Console
Hands on experience with WebLogic in the context of Fusion Middleware
Proficient with Linux/Unix including bash and/or ksh
Bachelor or graduate degree in field of computer science or engineering discipline.
Experience in the analysis, design, development and implementing of major Database structures
Problem-solving ability and proven ability to work to exacting deadlines
Proficient with latest versions of SQL and all related database tools
Communicate with managerial, administrative and technical staff to determine information needs, data flows and systems definitions
Demonstrate strong attention to detail, strong interpersonal skills, verbal, written and presentation skills.
Demonstrate creativity and intellectual curiosity around problem resolution and solution definition.
The ODI/ETL Specialist will be responsible building data integration solutions utilizing the Oracle Data Integration platform including ODI and Golden Gate. Along with working directly within the team to build solutions that are stable, scalable, and follow best practices the specialist must be able to provide practical advice based on experience with real life data integration projects using the Oracle DI software stack.Principal
Duties and Responsibilities:
Work closely with the Architecture, Development, DBA, and QA Teams in a collaborative environment
Provide architectural guidance/evaluation for ODI solutions actively being developed including performance optimization and high availability
Build low latency end to end ETL/ELT solution using Oracle Golden Gate and ODI for replication and Change Data capture
Map business requirements into ODI Interfaces, Packages, and Load Plans using source to target mappings documents
Enforce business rules using ODI Constraints and data quality functions
Setup Java EE ODI Agents running in a WebLogic server cluster for High Availability
Design and build components to assist with automation of common tasks via the ODI SDK
Extend the base ODI Knowledge Modules to create customized versions that will be re-usable across the company's data integration projects
Create both Design and Interface docs in support of Data integration projects
Collaborate with the Development teams in a multi-user environment to promote code changes into Subversion (SCM) for deployment to QA and Production environments.
Build automated testing scripts around ODI projects Skills
8+ years of experience with Oracle DB, ETL, and Data integration technologies including Star Schema design
5+ years of experience with Oracle Data Integrator (ODI) in Data Warehouse and MDM environments
Hands on experience with Oracle RAC on Unix/Linux platform
Hands on experience with Oracle Golden Gate (as it relates to ODI Change Data Capture)
Hands on experience with ODI in a High Availability environment including WebLogic clustering and Load balancing
Hands on experience with ODI Administrative tools including OEM and ODI Console
Hands on experience with WebLogic in the context of Fusion Middleware
Proficient with Linux/Unix including bash and/or ksh
Bachelor or graduate degree in field of computer science or engineering discipline.
Experience in the analysis, design, development and implementing of major Database structures
Problem-solving ability and proven ability to work to exacting deadlines
Proficient with latest versions of SQL and all related database tools
Communicate with managerial, administrative and technical staff to determine information needs, data flows and systems definitions
Demonstrate strong attention to detail, strong interpersonal skills, verbal, written and presentation skills.
Demonstrate creativity and intellectual curiosity around problem resolution and solution definition