Headquartered in Toronto, Sapien Information Services is a leading provider of
hosted services and next generation applications for interactive marketing, businesiintelligence, customer data integration and communications.
Position: Oracle Data Warehouse Developer
Department: IT Managed Services/Business Intelligence
Reports to: Director, IT Managed Services
Status: Full Time
Headquartered in Toronto, Sapien Information Services is a leading provider of hosted
services and next generation applications for interactive marketing, business
intelligence, customer data integration and communications. Our energetic team of
senior strategic thinkers and technical consultants provides ground breaking analytical
business and customer intelligence data solutions and communications tools for high
profile clients, in a variety of industries. We have exciting growth plans for the business
and are looking for dynamic professionals to help us make our plans a reality.
We are presently looking for an Oracle Data Warehouse Developer to join our team. If
you are an energetic and self‐motivated professional who is passionate about pushing
the boundaries of your own knowledge and expertise, talk to us about growing yourself
and your career. We have a welcoming culture and a reputation for accountability and
innovation. Our diverse projects, fun environment and passion for our customers will
enable you to contribute your ideas, affect change and grow your personal sphere of
This function is responsible for supporting large Oracle Data Warehouses in an efficient,
timely and error‐free manner. The Data Warehouse Developer provides technical
support and direction in developing and supporting system‐level programs, and
interfacing with customers and Business Intelligence Analysts on requirements. The
Data Warehouse Developer has responsibility for production support and maintenance
of the Data Warehouse, and works with other team members in optimizing system
performance and participates in all phases of the Data Warehouse development cycle
with minimal direction. Additionally, the individual will be responsible for addressing
operational issues to meet established Service Level Agreements for product delivery
Designing, developing, managing and maintaining multiple internal data
warehouses running on Oracle Database 10g and using Oracle Warehouse
Builder 10g Release 1 and Release 2.
Testing and QA activities for daily OWB ETLs and jobs, resolving data load issues
on an on‐going basis as well as carrying out pro‐active testing and quality control
activities to ensure data warehouse data integrity and quality is maintained.
Designing, developing and maintaining existing PL/SQL code to implement
business logic for multiple clients and carrying out one‐time operational
Work with individuals across the organization to build requirements and
architect solutions to support business requirements.
Document code and design support documentation.
Participate in establishing project plans and estimating work.
Participate in the application functional design process.
Specific Technology Skills
Bachelors Degree required, preferably in Computer Science, or an equivalent
combination of education and experience.
At least 5 years of previous/proven experience in Database and Data Warehouse
design and development including Data Mart structures and Oracle PL/SQL
Strong knowledge of ETL tools and strong experience with Oracle Warehouse
Builder, Oracle Enterprise Manager and Oracle Warehouse Builder Execution
Thorough working knowledge of Oracle Database Servers 9i, 10g and 11g,
PL/SQL, Oracle Application Server with Portal and Oracle Discoverer.
Experience with UNIX‐based operating systems, to develop shell scripts to carry
out and schedule system ETL‐ related activities including file transfers and
synchronization between multiple hosts, data import/export from flat files and
data comparison and archiving.
Experience with CRM and marketing data warehouse implementations.
Experience providing support for disaster recovery exercises (or actual disaster
Experience with OLAP and reporting tools.
Knowledge of statistics and data mining is a plus.
This individual will be a team leader.
Demonstrated problem determination, analysis and resolution skills.
Strong teamwork and interpersonal skills.
Strong customer service skills.
Decision Making: must be able to properly prioritize projects and problems
according to established guidelines.
Communicate with account team and internal customers to define/clarify
Communicate changing status of projects to production or project manager and
internal customers on a timely basis.
Communicate status and escalate problems as necessary according to defined
Work and communicate in a professional, team environment with other IT staff
Applicants should apply by submitting their resume and cover letter to
firstname.lastname@example.org. In the “Subject” field specify “Sapien Careers: Oracle Data
Applicants will be expected to provide suitable references from current or former
employers upon request.