Home

Job Reference # HCR-91024 Enterprise Data Warehouse Developer - 6 months NYC(Day 1 onsite) at Lexington, New York, USA
Email: [email protected]
Job Reference # HCR-91024 Enterprise Data Warehouse Developer - 6 months NYC(Day 1 onsite)

I hope you're doing well. I wanted to reach out to you and see if you have suitable candidates for

Job Reference # HCR-91024 Enterprise Data Warehouse Developer
with one of our clients in
NYC

Enterprise Data Warehouse Developer

Day 1 onsite in NYC

Pay rate - $75/hr on C2C

Please find the below JD

Job Title: Job Reference # HCR-91024 - Enterprise Data Warehouse Developer

Duration: 6 months(37.5 hrs per week)

Location: 641 Lexington Ave New York, NY 10022(Day 1 onsite)

Responsibilities

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.

Qualifications:

Bachelors degree; MBA or relevant technical degree preferred.

A strong background in technology, analysis and critically evaluating information gathered from multiple sources.

Experience decomposing high-level information into details, distinguishing user requests from the underlying true needs, and developing solution ideas from requirements.

Strong experience writing business requirements documentation (BRDs) and functional requirements documentation (FRDs).

Proven experience successfully working in a team setting and ability to reconcile conflicts.

Minimum seven 7-10 years of experience in related professional business/project analyst capacity.

Excellent oral and written communication skills.

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.

Excellent experience with MS Office 2013/2016 and above as well as design tools and flowcharting tools, e.g. Visio.

Regards

Ranga Reddy, 
Account Manager

1149 Bloomfield Ave. Clifton, NJ 07012

 [email protected]

| sprucetech.com

Spruce Technology Inc |
1149 Bloomfield Ave
Suite G |
Clifton, NJ 07012 US

|

Update Profile
|

Constant Contact Data Notice

Keywords: business intelligence information technology microsoft procedural language New Jersey New York
Job Reference # HCR-91024 Enterprise Data Warehouse Developer - 6 months NYC(Day 1 onsite)
[email protected]
[email protected]
View all
Wed Sep 11 19:57:00 UTC 2024

To remove this job post send "job_kill 1739998" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 21

Location: Lexington, New York