Data Warehouse Developer

1 day ago

Albany, NY, United States Elegant Enterprise-Wide Solutions Full time

About this Position:

Job Title: Data Warehouse Developer

Duties include:

  • Maintaining and developing SQL and PL/SQL for the PARIS Application.
  • Maintaining, converting, and developing all BI Publisher Reports for the PARIS application.
  • Performing database modeling in the context of an online transaction processing ( OLTP ) system.
  • Performing database modeling in the context of an online analytic processing ( OLAP ) system for the Client's Data Warehouse.
  • Tuning SQL for performance.
  • Developing new ETL processes using an enterprise ETL tool.
  • Maintaining existing ETL processes using OWB and/or Attunity Compose.
  • Converting existing OWB ETL processes to Attunity Compose.
  • Maintaining and developing the physical, logical, and business layers in the OAS RPD in a MUDE.
  • Maintaining and developing dashboards, reports, visualizations, and analyses in OAS.

Minimum Qualifications:

  • Availability to begin work on the Anticipated Commencement of Work Date stated and for a minimum of six months.
  • At least one year's experience developing complex reports in Oracle BI Publisher using Microsoft Word to design the layout.
  • At least three years' experience using OBIEE in a multi-user development environment ( MUDE ) developing within the Repository Database ( RPD ) and creating dashboards and analyses.
  • At least three years' experience performing ETL development using an ETL development tool such as Oracle Warehouse Builder, Attunity Compose, Informatica PowerCenter, Pentaho Data Integration, Oracle Data Integration, or Talend Data Integration.
  • At least five years' experience performing Oracle database development using SQL and PL/SQL.
  • At least two years' experience tuning SQL for performance within an Oracle environment.
  • At least three years' experience modeling data for reporting and analytics.

Note: For H-1B and OPT cases, we are seeking candidates from recognised organizations.

"No phone calls please."

  • Lead Data Warehouse Developer

    1 day ago

    Albany, NY, United States Veracity Full time

    Lead Data Warehouse Developer Location: Albany, NY 12236 (Hybrid - up to 50% remote with approval) Contract: 5-Year Contract | (Minimum 6-Month Commitment Before Replacement) Work Hours: 40 hrs / week | Monday-FridayOnsite Requirement: Must be onsite in Albany, NY for minimum first 6 months The Lead Data Warehouse Developer will serve in a senior technical...

  • ETL Data Warehouse Lead

    1 day ago

    Albany, NY, United States InterSources Full time

    ETL Data Warehouse Lead Location: Albany, NY, 12226 Duration: 2 years Contract Position Requirements 84 Months experience developing and testing query solutions using Oracle PL/SQL query 84 Months UNIX Shell Scripting experience 84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming/ IBM DataStage 84 Months...

  • ETL Developer

    5 days ago

    Albany, NY, United States Mindlance Full time

    Provide a short description of the Position: These Data warehouse and business intelligence positions are required to support the continued development and maintenance of DW/BI solutions in response to critical agency requirements for the WCB. These positions will also develop and maintain Pentaho ETL solutions, Pentaho BI schemas, executive dashboards and...

  • ETL Developer

    2 weeks ago

    Albany, NY, United States Mindlance Full time

    Provide a short description of the Position: These Data warehouse and business intelligence positions are required to support the continued development and maintenance of DW/BI solutions in response to critical agency requirements for the WCB. These positions will also develop and maintain Pentaho ETL solutions, Pentaho BI schemas, executive dashboards and...

  • ETL Developer

    24 hours ago

    Albany, NY, United States Mindlance Full time

    Provide a short description of the Position: These Data warehouse and business intelligence positions are required to support the continued development and maintenance of DW/BI solutions in response to critical agency requirements for the WCB. These positions will also develop and maintain Pentaho ETL solutions, Pentaho BI schemas, executive dashboards and...

  • Data Reliability Engineer

    5 days ago

    Albany, NY, United States Excelsior Collage Full time

    The Data Reliability Engineer is an integral part of the Information Technology Services department (ITS), reporting to the Director of Business Intelligence (BI). The role will be involved in efforts to ensure the accuracy, integrity, and security of data within the BI system that supports data processing and analysis needs. Interaction with stakeholders...

  • Data Reliability Engineer

    1 week ago

    Albany, NY, United States Excelsior Collage Full time

    The Data Reliability Engineer is an integral part of the Information Technology Services department (ITS), reporting to the Director of Business Intelligence (BI). The role will be involved in efforts to ensure the accuracy, integrity, and security of data within the BI system that supports data processing and analysis needs. Interaction with stakeholders...

  • Data Reliability Engineer

    10 hours ago

    Albany, NY, United States Excelsior Collage Full time

    The Data Reliability Engineer is an integral part of the Information Technology Services department (ITS), reporting to the Director of Business Intelligence (BI). The role will be involved in efforts to ensure the accuracy, integrity, and security of data within the BI system that supports data processing and analysis needs. Interaction with stakeholders...

  • Warehouse Automation Engineer

    2 weeks ago

    Albany, NY, United States Ryder Full time

    Job Seekers can review the Job Applicant Privacy Policy by clicking here (http://ryder.com/job-applicant-privacy-policy) . Job Description : Summary This Warehouse Automation Engineering position can be responsible for he effort in identifying, evaluating, piloting and deploying new warehouse automation technologies, followed by the installation and...

  • Warehouse Automation Engineer

    1 week ago

    Albany, NY, United States Ryder Full time

    Job Seekers can review the Job Applicant Privacy Policy by clicking here (http://ryder.com/job-applicant-privacy-policy) . Job Description : Summary This Warehouse Automation Engineering position can be responsible for he effort in identifying, evaluating, piloting and deploying new warehouse automation technologies, followed by the installation and...