Location: New York,NY, USA
We have an opportunity for Data Warehouse Developer - New York, NY - Day 1 Onsite and We are looking for a candidate who can join Immediately if you are interested, reply to us with your updated resume or if you could refer someone we would really appreciate it. Position : Data Warehouse Developer Location: 41 Lexington Ave New York, NY - Day 1 Onsite Duration: 6 Months Working Hours : (37.5hrs per week) Need Local candidates only Responsibilities Include (but not limited to): • 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 approaches 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. Qualifications: