HBITS - 06-13860-Systems Developer - Expert
Apply NowCompany: Knowledge Builders, Inc.
Location: Albany, NY 12203
Description:
Job Description
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.
Day to Day Tasks
Mandatory Qualifications
Systems Developer - Develops and implements applications and programs for the
backend processing systems used in businesses and organizations
Expert - 84+ months: Candidate is able to provide guidance to large teams
and/or has extensive industry experience and is considered at the
top of his/her field.
Requested Qualifications
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.
Day to Day Tasks
- 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.
- The individual in this position will work under the direction of a Technical Lead & Project Manager.
- Perform writing of complex stored procedures/triggers in an Oracle database
Mandatory Qualifications
Systems Developer - Develops and implements applications and programs for the
backend processing systems used in businesses and organizations
Expert - 84+ months: Candidate is able to provide guidance to large teams
and/or has extensive industry experience and is considered at the
top of his/her field.
Requested 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 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
- Bachelor's Degree