Epicareer Might not Working Properly
Learn More

Data Warehouse Developer

Salary undisclosed

Apply on


Original
Simplified
 Extensive experience in architecting and designing solutions at Enterprise scale in Enterprise Data

warehouse applications.

 Experience in developing Data Warehouse/Data Marts using, as examples, OBIEE, OBI APPS, Cognos,

Business Objects, SPSS, SSIS, SSRS, Informatica Power Center, OWB and ODI.

 Experience on design and development of Data Warehouse Architecture for Enterprise Data

Warehouse (EDW), Operational data Store (ODS), Operational Data Marts and Data Marts.

 Experience in defining metadata standards for the enterprise data warehouse.

 Experience In Design And Development Of

  • ETL processes using Dimensional Modeling for ROLAP and MOLAP.
  • ETL technical architecture.
  • BI load dependency plan, job scheduling and cycle management.

 Experience in developing end-to-end Data warehouse ETL routines.

 Experience In Using SQL In Advanced Analytical Functions.

 Experience in writing complex PL/SQL packages stored Procedures, functions, cursors, triggers,

views, and materialized views.

 Experience in creation of enterprise data Warehouse Test plan, Test script creation and Test Script

Execution for different test environments such as System, Integration and User Acceptance.

 Experience developing optimal approach for obtaining data from diverse source system platforms

and moving it to the Enterprise Data Warehouse.

 Experience in Logical and Physical data Models for enterprise data warehouse and applications.

 Experience developing and configuring Interactive Dashboards with drill-down capabilities,

links/images, HTML objects and folders.

 Proficient in using the time-series functions to support historical time comparison analysis.

 Experience with Calculated Measures and assigned Aggregation levels based on Dimension

Hierarchies.

 Experience in the housing and financial sector is preferred and a major plus, especially around

accounting, bonds, mortgages, underwriting, loans origination and servicing; in addition to,

experience around grants, tax credits, property/buildings asset management and compliance

reporting.