Job Description

Experience 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 delivery of huge data integration projects and would therefore require leveraging best practices expertise and experience at implementation; as well as effective technology know-how

EXPERIENCE AND SKILLS:

5 years or more of experience of a database developer in a professional environment

5 years or more of experience in a Data Warehouse and Business Intelligence environment

• SQL

• PLSQL

• Data Modeling

• Oracle SQL Developer

• ERWIN

• UNIX

• OBIEE

• Oracle BI Publisher

• MS Office Proficiency  (Word, Excel, PowerPoint, Visio)

PREFERRED QUALIFICATIONS:

• Oracle PL/SQL Developer Certified Associate Preferred

• Strong business acumen and communications skills

• Experience in data warehousing for a retail/store environment

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

REQUIRED SKILLS:

PL/SQL and SQL developer with Oracle experience – Required 5 Years

Understanding of Star Schema data warehouses and data warehouse design – Required 5 Years

ETL script development and execution, including automation in a Linux / Oracle environment – Required 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 Repository modeling in Oracle OBIEE platform – 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 or SQL Developer (preferred) – Nice to have 5 Years

Qualifications null Additional Information

All your information will be kept confidential according to EEO guidelines.