Job Details

HBITS: HBITS-07-14630

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 Data
Warehouse/Business Intelligence team.

--- Day-to-Day Tasks ---
1. 1. Work in coordination with a team of developers to expand the current
Data Warehouse.
2. 2. Design/model, construct, load, and validate the data tables through the
enterprise Data Warehouse architecture.
3. 3. Work with Business Analyst & customers on analysis and logical design
for 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 of
issues and code fixes, infrastructure upgrades and enhancements
7. 7 .Perform writing of complex stored procedures/triggers in an Oracle
database utilizing OWB and ODI
8. 8. The individual in this position will work under the direction of a Technical
Lead & Project Manager.

--- Required Qualifications ---
• 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 building database schemas, tables, views, indexes,
and stored procedures