Data Warehouse Architect

Arete Technologies, Inc.; Richmond (VA); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading technology services firm in Virginia seeks a Data Warehouse Developer to support Oracle Data Warehouse for business intelligence reporting. The ideal candidate will develop ETL scripts, analyze data issues, and ensure best practices in data integration. Applicants should have strong SQL and PL/SQL skills along with experience in data warehouse methodologies. This role requires collaboration in delivering BI solutions and maintaining optimal data processes.

Qualifications

• Proven experience with ETL processes and data integration projects.
• Ability to develop ETL scripts and write PL/SQL code from specifications.
• Familiarity with data model and dataflow diagrams.

Responsibilities

• Support development and maintenance of Oracle Data Warehouse.
• Gather business requirements and create technical designs.
• Review, analyze, modify, and create ETLs.
• Document technical needs for ETL processes.
• Deliver large data integration projects utilizing best practices.

Skills

Experienced SQL and PL/SQL development

Deep understanding of data warehouse and star schema

Performance tuning of ETL/SQL code

Ability to analyze and resolve production data issues

Unix shell scripting and job automation

Building BI dashboards using OBIEE

Job description

Arete Technologies, Inc. offers set of innovative Consulting and Outsourcing services, bridging the gap between requirements and outputs of various dexterous and facile companies worldwide. The thrust of providing global deliverables with focus on providing paramount and unsurpassed services combined with cost saving solutions to the clients

We understand the business requirements in the present day corporate scenario and aspire to provide world-class services enabling the organization to burgeon and flourish while keeping the work-life balance intact. The Global delivery mechanism followed at Arete Technologies, Inc. saddles proficient schemas and unconventional channels to provide one-stop solutions for all your workforce needs.

our Team is an exquisite amalgamation of vast experiences of over 30 years in IT Consulting and Staffing industry. Connoisseurs in the field of staff augmentation for IT, we operate on 24 by 7 model with an aim of providing affordable and adept professionals with an assurance of satisfaction for both Consultants and Clients.

We are pre-eminent service providers in the field of staff augmentation, IT Consultancy, Software development, Web Development providing unexcelled services and focusing on both the employers and employees.

Job Description

Support for development and maintenance of Oracle Data Warehouse to support OBIEE and BIP reporting tools for ABC

The applicant is responsible for the successful delivery of business intelligence information to the entire organization and is experienced in Data Warehouse and BI development and implementations. The applicant will be involved in gathering of business requirements and creating technical designs.

It involves 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. The data warehouse developer’s role in an organization includes providing support to the organization’s business requirements in the application and consumption of information from the Data Warehouse.

The applicant will be part of the team to review, analyze, modify, and create ETLs, testing, debugging, integration and implementation processes. Task will also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.

This position involves the 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.

Data Warehouse Developer Role:

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

Build and implement BI dashboards, analysis using OBIEE