Job Description
HBITS: HBITS-07-14629
OCFS, Expert, Systems Developer
24 month contract
Interview: Virtual Interview
Work model: 50% telecommuting, 50% Office per week
- -- Project Description --- This 24-month position for a Systems Developer working on an Oracle DataWarehouse/Business Intelligence team.
- -- Day-to-Day Tasks --- 1. 1. Work in coordination with a team of developers to expand the currentData Warehouse.2. 2. Design/model, construct, load, and validate the data tables through theenterprise Data Warehouse architecture.3. 3. Work with Business Analyst & customers on analysis and logical designfor mappings and ETL.4. 4. Perform unit testing and correct all identified bugs.5. 5. Perform complex PL/SQL coding in a Data Warehouse environment.6. 6. Responsible for load issue resolutions, load inquiries, 2nd level testing ofissues and code fixes, infrastructure upgrades and enhancements7. 7. Perform writing of complex stored procedures/triggers in an Oracledatabase utilizing OWB and ODI8. 8. The individual in this position will work under the direction of a TechnicalLead & Project Manager.
- -- Required Qualifications ---
- 84 months experience in reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle DataIntegrator (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 developingdetailed incremental ETL processes.
- 84 months experience developing and testing maps, performing source-to- target mappings, storage capacity planning and developing ETL in OracleData Integrator (ODI)
- 84 months experience in SDLC including: requirement gathering, development, testing, debugging, deployment, documentation andproduction support, load issue resolutions, load inquiries, 2nd level testing ofissues and code fixes, infrastructure upgrades and enhancements (Oracleupgrades).
- 84 months experience working in UNIX or LINUX environment developing Unix Shell Scripting and SFTP protocols
- 84 months experience in building database schemas, tables, views, indexes, and stored procedures
Apply tot his job
Apply To this Job