Full-Time
Data Warehouse Architect
Arete Technologies
No salary listed
East Lansing, MI, USA
In Person
Category
 Data & Analytics (2) |
|---|
| , |
Required Skills
Bash
SQL
ETL
Oracle
Requirements
- Experienced SQL and PL/SQL developer on Oracle database platform
- Deep understanding of data warehouse and star schema
- Develop ETL scripts and write PL/SQL code from data model, dataflow diagram and technical design specifications
- Ability to work on a wide variety of development needs from simple queries to complex queries and multidimensional analysis
- Ability to follow best coding standards practices
- Expert in performance tuning of ETL/SQL code
- Analyze and provide resolutions for production data issues
- Familiar with Unix shell scripting and job automation
Responsibilities
- Support for development and maintenance of Oracle Data Warehouse to support OBIEE and BIP reporting tools for ABC
- Responsible for the successful delivery of business intelligence information to the entire organization and experience in Data Warehouse and BI development and implementations
- Involved in gathering business requirements and creating technical designs
- Designing, developing, and supporting new and current ETL processes employing industry standards and best practices to enhance loading of data from and into different source/ target systems
- Provide support to the organization’s business requirements in the application and consumption of information from the Data Warehouse
- Part of the team to review, analyze, modify, and create ETLs, testing, debugging, integration and implementation processes
- Documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized
- Delivering of huge data integration projects and would therefore require leveraging best practices expertise and experience at implementation; as well as effective technology know-how
- Build and implement BI dashboards, analysis using OBIEE
- Build reports using BI publisher