×
Register Here to Apply for Jobs or Post Jobs. X

Systems Developer; OWB, ODI, PL​/SQL, ETL, SDLC

Job in City of Albany, Albany, Albany County, New York, 12201, USA
Listing for: MVP Consulting Plus
Full Time position
Listed on 2026-03-14
Job specializations:
  • IT/Tech
    Data Engineer, Database Administrator
Salary/Wage Range or Industry Benchmark: 80000 - 100000 USD Yearly USD 80000.00 100000.00 YEAR
Job Description & How to Apply Below
Position: Systems Developer (OWB, ODI, PL/SQL, ETL, SDLC)
Location: City of Albany

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. Work in coordination with a team of developers to expand the current Data Warehouse.
  • 2. Design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture.
  • 3. Work with Business Analyst & customers on analysis and logical design for mappings and ETL.
  • 4. Perform unit testing and correct all identified bugs.
  • 5. Perform complex PL/SQL coding in a Data Warehouse environment.
  • 6. Responsible for load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements.
  • 7. Perform writing of complex stored procedures/triggers in an Oracle database utilizing OWB and ODI.
  • 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.
    #J-18808-Ljbffr
    To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
    (If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
     
     
     
    Search for further Jobs Here:
    (Try combinations for better Results! Or enter less keywords for broader Results)
    Location
    Increase/decrease your Search Radius (miles)

    Job Posting Language
    Employment Category
    Education (minimum level)
    Filters
    Education Level
    Experience Level (years)
    Posted in last:
    Salary