ODI - IT Data Warehouse Developer

Description

About this Position The purpose of the Senior Developer, IT Data Warehouse position is to . . .
Design, develop, test and implement logic to extract, transform & load data from transactional applications into the DW using Oracle Data Integrator (ODI) and PL/SQL
Help End Users Understand and query data to accomplish their business purposes
Partner with Database and Middleware Administrators to achieve great application performance
Demonstrate advanced skills while coaching and mentoring less senior team members
Position Outcomes & Activities You will be measured on the following both individually and as a team Design, code, test and deliver insightful and architecturally sound business solutions
Document code and projects so others can easily understand
Fulfill customer requirements as measured in customer survey scores
Show insight; know your application design & data; offer simple, working solutions
Apply team coding, documenting and testing standards and recommend process improvements
Recognize upstream and downstream impacts; communicate effectively (verbally & in writing)
Learn the Business Process Your Application Supports so your code will better support the business
Improve your application and team processes
Decrease incidents and increase uptime of your application
All other duties as assigned
Attendance as required by department
Basic Position Requirements Minimum requirements to succeed in this position are Required Minimum of 5 years DW design and development experience; Required Minimum of 5 years Information Systems experience
Required Knowledge of ETL tools Oracle Data Integrator Enterprise Edition
Required Proficiency in PL/SQL coding, troubleshooting, and performance tuning Required Experience with Oracle (preferably version 11)
Required Knowledge of Unix Scripting and job scheduling Required Participate in a (24X7) oncall rotation where you will be responsible to monitor production failure notifications and resolve issues.
Remain compliant with our policies, processes and legal guidelines
Work onsite at the required CA work location
Preferred Experience in Data Quality and Cleansing, Data Governance, Metadata usage and management, and Master data management. Expertise in lifecycle database design, 3NF, and dimensional design concepts
Position Knowledge and Skills To succeed in this role you need the following Knowledge, Skills and Abilities Code expertly in your application while following team coding and testing standards
Respond promptly and effectively to largescale problems, projects and tasks.
Organize, with ability to multitask and prioritize multiple requests.
Convey complex information in a timely and easily understood way to all levels of the organization.
Demonstrate insight; make recommendations as opportunities arise.
Be selfdriven, motivated to help, and able to perform with minimal supervision.
Maintain customer focus; keep the customers and companys best interest in mind. Work well with abstract concepts. Be analytical. Solve problems.
Position Values To succeed in this role, you must demonstrate PRIDE (our Company core values) Positive Keep a positive attitude; focus on solutions; collaborate; be enjoyable to work with.
Respectful Value teamwork; share success; appreciate others; promote trust in communications.
Insightful Make timely well considered decisions; create innovative solutions; continuously learn. Direct Communicate clearly and objectively; dont fear difficult conversations. Raise concerns through proper channels. Earnest Be honest, sincere and consistent. Work hard and pursue our goals relentlessly.