Previous Job
Previous
Sr. Oracle Developer (ODI & Informatica)
Ref No.: 16-04215
Location: West Chester, Pennsylvania
Our client in West Chester, PA has an immediate need for a Sr. Oracle Developer (ODI & Informatica REQUIRED).
Skills & Experience Needed:
Hands on experience with technical design, coding and delivering enterprise class data management systems
Oracle Data Integrator (ODI) Design and Development experience and strong ability on using the right mix of functionality and promoting re-usability
Experience in Enterprise Data warehouse (EDW) or Data Mart DM implementation
Experience creating and reviewing ETL design and mapping specifications documents
Strong PL/SQL skills
Design, development and implementation of complex data management and reporting solutions, with integrated UI and workflow components.
Demonstrated experience with design and construction of data interfaces from transactional legacy systems into a dimensional data model.
Promote design of re-usable components and services
Ensure software projects are completed according to project requirements and are properly documented with traceability through project specifications including functional and technical documents.
Provide Level 2 production support on a rotating basis.
Provide IT representation with internal customers and IT areas.
Participate in architecture and design sessions with team members and peers.
Interact and work directly with customer team members on projects and support issues.
Build relationships with business customers and peers across the IT organization.
Facilitate communication upward and across project teams including project status.
Follow change management and problem management processes.
Assist in the definition and implementation of architectural improvement measures within the
environment.
Propose and institute software development process improvements.
Who is our ideal candidate?  
10+ years of design and development of Data integration using ETL/ELT, Oracle, and PL-SQL
5+ years Oracle Data Integrator (ODI), Data Mart design and development
5+ years report design and development
Experience writing stored procedures and tuning queries.
Strong Experience with Informatica.
Financial, insurance industry, or actuarial experience
Pluses:
Experience with Java.
Experience with Business Objects/OBIEE.
Data warehouse experience.