FaceBook

TITLE: Data Warehouse Architect 3

Interview Type: In Person Only

Location : Richmond VA

Rate: 120 K on w2

 

*local candidates strongly preferred

 

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

 

 

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

·         Build reports using BI publisher

 

Skill

Required / Desired

Amount

of Experience

PL/SQL and SQL developer with Oracle expereince

Required

5

Years

Understanding of Start Schema ata warehouses and data warehouse design

Desired

5

Years

ETL script development and execution, including automation in a Linux / Oracle environment

Desired

5

Years

Performance tuning and reconciliation of SQL quey execution

Desired

5

Years

Familiar with Unix Shell Scripting

Desired

5

Years

Experience with OBIEE, BIP and data Repository in Oracle OBIEE reporting platform

Highly desired

5

Years

Experience developing report specifications from business requirements and executing the build to design

Desired

5

Years

Experience with a mature data modelling tool such as ERWIN (preferred)

Nice to have

5

Years

Experience with Oracle 12 enviornments

Highly desired

3

Years

 

NEXT
Previous
AffluentTEK

Professional IT SOLUTION

Services

AffluentTEK developed a comprehensive approach to consulting that moves clients  read more

Solutions

Our business solutions can help you increase sales, better manage cash flow and enable you to spend quality time. We craft a unique solution that help you better run your business.

Copyright © AffluentTEK
Phone # : 585.568.7445
Fax # : 585.568.7209
Twitter
LinkedIN

IT staffing

AffluentTEK staffing practice delivers high-quality staffing services built on industry best practices. We work with our clients to recruit and retain the best information technology talent possible read more