What are the responsibilities and job description for the Oracle Data Warehouse Developer – CCWIS / ODI / PL/SQL - Hybrid position at Sarum, LLC?
Department: Information Technology Services
This 14-month position for a Systems Developer with experience working on a Oracle Data Warehouse/Business Intelligence team is needed for the data quality and data collection requirements for state and federal reporting on the Comprehensive Child Welfare Information System (CCWIS). The developer will design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture.
Responsibilities:
- Work in coordination with a team of developers to expand the current Data Warehouse.
- Work with Business Analyst & customers on analysis and logical design for mappings and ETL.
- Perform unit testing and correct all identified bugs.
- Perform complex PL/SQL coding in a Data Warehouse environment.
- Respond to CCWIS data requests.
- Perform writing of complex stored procedures/triggers in an Oracle database. .
Required/Preferred Skills
- 84 months experience in reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality.
- 84 months experience Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environment.
- 84 months experience working in an Oracle Data Warehouse performing development work using PL/SQL.
- 84 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
- 84 months experience developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI).
- 84 months experience in SDLC including: requirement gathering, development, testing, debugging, deployment, documentation and production support, load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements (Oracle upgrades).
- 84 months experience working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols.
- 84 months experience in build database schemas, tables, views, indexes, and stored procedures.
Job Types: Full-time, Contract
Pay: $50.00 - $55.00 per hour
Expected hours: 37.5 per week
Schedule:
- Monday to Friday
Application Question(s):
- Email Address -
Experience:
- Oracle Warehouse Builder (OWB) ETL processes: 8 years (Preferred)
- Oracle Data Integrator (ODI): 8 years (Preferred)
- Data Modeling (Dimensional & Relational),: 8 years (Preferred)
- Oracle Data Warehouse performing development: 8 years (Preferred)
- developing detailed incremental ETL processes.: 8 years (Preferred)
- developing ETL in Oracle Data Integrator (ODI).: 8 years (Preferred)
- requirement gathering, development, testing, debugging: 8 years (Preferred)
- UNIX or LINUX environment developing Unix Shell: 8 years (Preferred)
- build database schemas, tables, views, indexes: 8 years (Preferred)
Ability to Commute:
- Albany, NY (Preferred)
Ability to Relocate:
- Albany, NY: Relocate before starting work (Preferred)
Work Location: On the road
Salary : $50 - $55
