← Back to jobs

DPR Solutions Inc Logo
Database Architect

DPR Solutions Inc

 

Albany, NY, USA

Posted On: 11 days ago
Experience: Not specified years
Availability: Onsite
Openings: 1
Category: Database Architect
Tenure: Contract - Corp-to-Corp
Related Jobs

No related jobs found

Description

You will design and implement enterprise-level data warehousing, application integration, and master data management solutions.

This role is hybrid.

Responsibilities

  • Collaborate with business subject matter experts and vendors to define data warehouse and system requirements.
  • Architect, document, and implement normalized data warehouse environments for enterprise applications.
  • Develop data integrations for heterogeneous systems and business intelligence using SQL.
  • Perform comparative analysis to design new transactional databases and improve existing data warehouse structures.
  • Implement systematic data error recovery, cleanup procedures, and self-service BI reporting structures.

Required Skills

  • 84 months of experience in data modeling and designing normalized Data Warehouse environments.
  • 84 months of experience architecting enterprise application integration and master data management.
  • 84 months of experience using Oracle Data Integrator (ODI) and ETL technologies.
  • 84 months of experience developing integrations via SQL.
  • 72 months of experience performing database comparative analysis for transactional systems.
  • 60 months of experience in data computation and presentation to solve business problems.
  • 48 months of experience implementing data error recovery and cleanup procedures.
  • 48 months of experience building Data Lakes, Data Marts, and Data Models using ERWIN.

Education

Not specified

Related Jobs

No related jobs found

← Back to jobs