Video Interview
Tech Valley Talent (TVT) is an HBITS PRIME Vendor, and we have an opening for an Expert Systems Developer HBITS-06-13623
DURATION: 24 Months
LOCATION: Albany, NY –
Onsite
This position is for a systems developer with experience working on a Oracle Data Warehouse/Business Intelligence team. The developer will design/model, construct, load and validate the tables through the enterprise Data Warehouse architecture.
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.
- 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
- Bachelor’s Degree
Day-to-Day tasks - Ongoing requests to add new tables, columns to the ODS
- Coding and configuration for initial set up of New Agencies
- Ownership logic needs to be applied for New Agencies
- ODS Maintenance Activities:
- responding to missing files questions
- responding to missing data questions
- technical issues
- database and network issues
TVT is an Information Technology (IT) professional business leader providing IT services to the public sector. Our firm is founded on the values of high integrity, trust, honesty, and commitment. We take pride in providing exceptional value to our clients by supplying and delivering the best IT project-based and hourly talent across the nation. We are business partners with many technology solution providers such as IBM, AWS, Google, Microsoft, Oracle, Tableau, Salesforce, and others. Tech Valley Talent provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type protected by federal, state, or local laws. This policy applies to all terms and conditions of employment.