Home

Local to NY Only: Data Warehouse Developer I New York, NY at Lexington, New York, USA
Email: [email protected]
Title:
Data Warehouse Developer

Location: Lexington Ave New York, NY

Duration:
1 Year

Locals Only

Rate Max: $65/hr on C2C

JOB :

Jo
b
Summ
a
ry

N
ew

Y
ork
Sta
te

Ho
m
es and
C
om
m
unity
Ren
ewal is

undergoing a major modernization of their
business applications and is seeking a

Data Warehouse Developer
(Developer)
within their Information Technology department

to play a key role in this effort,
which
will include designing and building an enterprise data warehouse


The Developer
must have
extensive experience in software analysis, design, development,
implementation and maintenance of Data Warehouse/Data Marts.

T
he

Developer
will

w
ork
cl
o
sely
wi
th
proje
ct

ma
na
gers,

IT
s
taf
f,
pr
o
gram
s
taff
a
nd

ot
her
s
takeh
ol
d
ers

to

defi
ne
a
nd

de
ve
l
op

req
uire
ments

f
or

the enterprise data warehouse. The
Developer
will
a
pply
a
ra
nge
of
specia
li
zed

skills
a
nd

t
o
ols

to

c
o
m
ple
te
the f
oll
owing
specific
d
uties
a
nd
r
esponsi
biliti
es:

The

Developer
will

use
t
heir
e
xt
ensi
ve
kn
ow
led
ge

of
b
usi
ness
a
nalysis
best
pract
ices
to
facilit
ate

req
uire
ments

sess
i
o
ns
and

c
o
m
m
unica
te
c
learly
and

ef
fec
ti
vely

with
en
d-
users, a
pplicati
o
ns
d
e
ve
l
o
per
s,
s
eni
or b
usi
ness

ma
na
ge
rs
a
nd

o
t
her

te
am
me
m
bers.

T
he

Developer

will

be
a
cc
o
untab
le
f
or

pr
ovi
di
ng

c
oor
di
nat
i
on

to

e
nsu
re
the
ap
p
r
o
pri
ate

c
oll
ecti
on

of
da
ta;

d
oc
u
mentat
i
on

of
in
f
o
r
mat
i
o
n;
and

pres
e
ntat
i
on

of
fi
ndi
ngs.
T
he

Developer
will p
r
ovi
de

docu
mentat
i
on
and
fl
o
w-ch
arts

of

t
he

or
ga
ni
zati
o
ns

w
orkflow,

as w
ell as
ad-
h
oc

qu
ery
su
p
p
ort
a
nd
r
e
p
ort
c
rea
t
i
o
n.

The

Developer

m
ust

h
a
ve
s
t
r
o
ng

tech
nical
k
n
owled
ge
a
nd
u
nders
ta
ndi
ng

of

IT

s
yst
e
ms
a
nd
ap
plicati
o
ns
as

well
as

t
he
a
bility

to
pl
an
and

t
rack

b
usi
ness
a
nal
yses

acti
v
ities
as
part
of
a

p
r
oje
ct.
The

Developer

also

m
ust

h
a
ve
g
o
od
lis
ten
ing
skills
a
nd i
nt
e
r
vi
ewing
s
kills

to
talk
with
i
ndivid
uals
and
gr
o
ups abo
ut

t
heir
ne
e
ds
and
ask
t
he
ri
ght

que
sti
o
ns
to
su
rface

essential
r
e
quir
e
ments
i
nf
o
r
m
ati
o
n.
The
i
deal
ca
ndi
date
will
a
l
so
p
o
ssess
g
ood

writi
ng

skills
to
ens
ure
effec
t
i
ve
c
om
m
unica
tion

of
i
nf
or
m
ati
on
to
c
us
t
o
mers,
mar
ke
ti
ng,

ma
na
gers,
and
t
ech
nical
staff.

The Developer will report directly to the CIO, and
indirectly to the VP / Application Development Manager, and will play a vital
role in helping HCR fulfil its strategic, analytical and operational reporting
requirements. The ideal candidate will demonstrate critical thinking skills
when solving problems and making recommendations for new solutions.

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.

o

ETL technical architecture.

o

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:

Bac
hel
or
s deg
r
ee;

MBA

or
rele
va
nt

tech
nical deg
r
ee

preferred.

A
str
o
ng

backg
r
o
und
in

technology
,
a
nalysis

a
nd
cr
itically

e
val
uati
ng
i
nf
o
r
mat
i
on

gathe
r
ed
fr
om

m
ulti
ple
s
o
ur
ces.

E
x
perien
ce

deco
m
p
osi
ng

hi
g
h-le
vel
i
n
f
o
r
mat
i
on
i
n
to

d
etails,

disti
nguis
hi
ng

user
req
u
ests
fr
om
t
he

underlying

tr
ue

n
eeds,
and

de
ve
l
o
pi
ng
s
ol
ut
i
on
ide
as
fr
om
r
e
quir
e
me
nt
s.

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

P
r
o
ven
e
x
per
ience
succe
ss
f
ully

w
orki
ng
in a
t
e
am

se
tt
i
ng
and
ab
ility

to

rec
o
nci
le

c
o
nfl
icts.

M
i
ni
m
um

seven 7-10

ye
ars
of
ex
perience
in

rela
ted p
r
o
fess
i
o
nal
busi
nes
s
/
pr
o
ject
a
nal
yst
ca
paci
ty.

Ex
celle
nt

oral
and

wr
it
ten
c
o
m
m
unicat
i
on

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

e
x
per
ience
with
MS
Off
i
ce

2013/2016 and above as well as design tools and flowcharting tools, e.g. Visio.

This j
ob
descri
pt
i
on
is

n
ot

i
nt
e
nded to
be
all inc
lus
i
ve,
a
nd

em
pl
o
y
ee
will
a
lso

pe
rf
orm

rea
s
o
na
ble r
ela
ted b
usi
ness
duties
as a
ssi
gned.

Wha
t
we
off
e
r:

Exciting opportunity to be part of New Yorks resurgence
to greatness;

Extensive benefits package including paid leave,
excellent health, dental, vision and retirement benefits;

Promotional opportunity for dedicated professionals.

Thanks
and Regards

Vinod
Kumar

ST
Global LLC

Fax:
206-319-4579

[email protected]

www.stglobaltech.com

Note: We respect your Online Privacy.
This is not an unsolicited mail. Under Bills.1618 Title III passed by the 105th
U.S. Congress this mail cannot be considered Spam as long as we include Contact
information and a method to be removed from our mailing list. If you are not
interested in receiving our e-mails then please reply with a "REMOVE"
in the subject line at mention all the e-mail addresses to be removed with
any e-mail addresses, which might be diverting the e-mails to you. We are sorry
for the inconvenience.

--

Keywords: cprogramm access management business intelligence active directory rlang information technology container edition logistics execution microsoft procedural language California Connecticut Delaware Florida Georgia Massachusetts Nebraska New York North Dakota Rhode Island Utah Virginia Wisconsin
Local to NY Only: Data Warehouse Developer I New York, NY
[email protected]
[email protected]
View all
Sat May 25 02:21:00 UTC 2024

To remove this job post send "job_kill 1427805" 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: 28

Location: Lexington, New York