Data Warehouse Developer

R & T Consulting New York City , NY 10001

Posted 3 months ago

This position can convert to Full Time. H-1's will not be considered.
The candidate will work closely with various development teams and Business managers to further enhance the data warehouse and reporting elements of the platform. Strong core TSQL/PSQL skills are essential along with a solid understanding of data warehousing design principles.
The role would suit a candidate with at least 5 years experience of working within a PLSQL development environment building a data warehouse solution. The main role will be to build out a DataMart and distribution layer for HR data. Experience in HR workday would be plus. The Ideal candidate would have designed and architected HR solutions in the past, with real world experience in organization and department hierarchies.

Key Responsibilities:

Design and develop warehouse enhancements.
Monitor Jira log and support BAU issues and enhancements.
Load and validate dimensions and measures stored procedures
Comply with the standard release cycle and deployment controls
Perform all application unit and system testing
Support the loading and integrity of the data warehouse.
Create data dictionarys and proper documentation on the data warehouse (Oracle DB)
Control M development

Skills and Experience:

Required

Solid Oracle Development skills with 11g or later
Solid SQL Server Development skills with version 2008 R2 or later
Experience in writing ETL Packages using SSIS
Data Warehousing Design Experience and Kimball Methodologies
Understating of the data governance life cycle
Experience working with HR workday
Control M development
Excellent verbal and written communication skills.
Ability to interact professionally with developers, business analysts and managers.
Lite C# development and debugging.

Preference will be given to candidates with experience in the following :

The ability to understand financial products and how they are reported on by Risk, Product Control and Finance departments within an investment bank
Understating of securities ( in the contexts of cusip, isins, tickers)
Banking /Financial Services and Financial transaction experience
Knowledge of Fixed Income and Repos trading systems domain

This position can convert to Full Time. H-1's will not be considered.

Skills:
TSQL/PSQL, Data warehousing design principles with

Kimball Methodologies,Oracle development with 11g or later, ETL Packages using ssis,HR workday
Contract
1 year


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Core Java Developer With Big Data
New!

Mars Solutions Group

Posted Today

VIEW JOBS 12/10/2018 12:00:00 AM 2019-03-10T00:00 <div style="margin: 0px;"><span style="margin: 0px; font-family: "Times New Roman",serif; font-size: 12pt;"><font color="#000000">Seeking a Sr. Consultant for a Core Java Developer role with Big Data and Capital Markets experience.<span style="margin: 0px;">  </span>This is a long term contract role located in NYC.<span style="margin: 0px;">  </span></font></span></div> <div style="margin: 0px;"><span style="margin: 0px; font-family: "Times New Roman",serif; font-size: 12pt;"><font color="#000000"> </font></span></div> <div style="margin: 0px;"><span style="margin: 0px; font-family: "Times New Roman",serif; font-size: 12pt;"><font color="#000000">Ideal candidates will possess the following experience:</font></span></div> <div style="margin: 0px;"><span style="background: yellow; margin: 0px; color: black; font-family: "Times New Roman",serif; font-size: 12pt;"> </span></div> <ul style="margin-top:0in" type="disc"> <li style="margin: 0px 0px 16px; color: black; font-family: "Times New Roman",serif; font-size: 12pt; font-style: normal; font-weight: 400;" style="padding: 0; margin: 0;"><span style="margin: 0px; font-family: "Times New Roman",serif; font-size: 12pt;">Must be a highly skilled senior Java developer with solid object oriented and<span style="margin: 0px;"> DB/JPA experience to work on Big Data pipeline.</span> </span></li> <li style="margin: 0px 0px 16px; color: black; font-family: "Times New Roman",serif; font-size: 12pt; font-style: normal; font-weight: 400;" style="padding: 0; margin: 0;"><span style="margin: 0px; font-family: "Times New Roman",serif; font-size: 12pt;">Must be able and willing to <span style="margin: 0px;">go deep into a codebase to debug problems</span> if needed, and be able to <span style="margin: 0px;">work independently in a fast-paced environment.</span> </span></li> <li style="margin: 0px 0px 16px; color: black; font-family: "Times New Roman",serif; font-size: 12pt; font-style: normal; font-weight: 400;" style="padding: 0; margin: 0;"><span style="margin: 0px; font-family: "Times New Roman",serif; font-size: 12pt;">Must have a mastery of leading java design patterns, stay current on latest technologies, and have <span style="margin: 0px;">experience with high complexity, high velocity systems</span></span></li> <li style="margin: 0px 0px 16px; color: black; font-family: "Times New Roman",serif; font-size: 12pt; font-style: normal; font-weight: 400;" style="padding: 0; margin: 0;"><span style="margin: 0px; font-family: "Times New Roman",serif; font-size: 12pt;">Must have deep <span style="margin: 0px;">experience coding / architecting systems that handle thousands of transactions per second</span> </span></li> <li style="margin: 0px 0px 16px; color: black; font-family: "Times New Roman",serif; font-size: 12pt; font-style: normal; font-weight: 400;" style="padding: 0; margin: 0;"><span style="margin: 0px; font-family: "Times New Roman",serif; font-size: 12pt;">Must know how to <span style="margin: 0px;">parse large JSON files</span> </span></li> <li style="margin: 0px 0px 16px; color: black; font-family: "Times New Roman",serif; font-size: 12pt; font-style: normal; font-weight: 400;" style="padding: 0; margin: 0;"><span style="margin: 0px; font-family: "Times New Roman",serif; font-size: 12pt;">Must understand (minimally<span style="margin: 0px;">) big data concepts like Map Reduce, NoSQL database trade-offs, NoSQL Database configurations.</span> </span></li> </ul> <div style="margin: 0px;"><span style="margin: 0px; color: black; font-family: "Times New Roman",serif; font-size: 12pt;">Nice to haves<br /> • </span><span style="margin: 0px; font-family: "Times New Roman",serif; font-size: 12pt;"><font color="#000000">E</font><span style="margin: 0px; color: black;">xperience working in a Capital Markets firm (Investment Bank/Investment Management)</span><span style="margin: 0px; color: black;"> with basic understanding of financial products <br /> • </span><font color="#000000">Experience wo</font><span style="margin: 0px; color: black;">rking with leading <span style="margin: 0px;">Big Data technologies like Kafka, Cassandra, Spark, Geode, NiFi, and Vertx/NodeJS.</span></span></span></div> Mars Solutions Group New York NY

Data Warehouse Developer

R & T Consulting