Data Warehouse Developer jobs in United States
info-icon
This job has closed.
company-logo

Compu-Vision Consulting Inc. ยท 2 weeks ago

Data Warehouse Developer

Compu-Vision Consulting Inc. is seeking a Data Warehouse Developer who will work with OSC staff to maintain existing processes and systems. The role involves converting existing processes from Oracle Warehouse Builder to Attunity Compose and developing new processes to integrate new datasets into the data warehouse.

ConsultingInformation TechnologyOutsourcingSoftware
check
Growth Opportunities
check
H1B Sponsor Likelynote

Responsibilities

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 FirstNY 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

Qualification

ETL developmentAttunity ComposeSQLPL/SQLDatabase modelingPerformance tuningBI Publisher ReportsDashboardsVisualizations

Required

experience performing ETL development using Attunity Compose
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 FirstNY 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

Preferred

additional years of experience beyond what is required to meet Minimum Qualification

Company

Compu-Vision Consulting Inc.

twittertwitter
company-logo
Compu-Vision Consulting Inc. is a dynamic IT consulting enterprise.

H1B Sponsorship

Compu-Vision Consulting Inc. has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (2)
2022 (1)
2021 (9)
2020 (12)

Funding

Current Stage
Growth Stage
Company data provided by crunchbase