Job ID :
1158
Company :
NTT Data
Location :
salt lake city, UT
Type :
Hire
Duration :
6 Months
Rate :
Open
Status :
Active
Openings :
1
Posted :
5 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

 

The developer role will be to take the source-to-Client mappings (EDW to credit mart tables) from the BA's and write the ETL processes to move the data between the EDW and the credit mart.  The ETL processes will be managed using SAP's Data Service's ETL tool, though the primary development effort will be building push-down SQL processes (procedural SQL) that can be implemented as separate modules through the Data Services toolset.  Must have experience with Data Services, PostgreSQL SQL, scripting, indexing, partitioning, as well as basic DBA skills (indexing, partitioning, creating/dropping/truncating objects, creating temporary tables, user rights management, database tuning and optimization).

 

The client uses Data Services in a very unique way - typically, DS extracts data to a job server, applies necessary transforms and business rules, then pushes the data back into the database.  Because there isn't a

bulk loader connector for their  Greenplum system (and because of the  size of the data sets they work with) they simply use Data Services as a workflow manager and scheduler. Each Data Services workflow consists

of a database connection, a series of SQL-commands packaged as a script, and a schedule module. The actual transformations and processing takes place within the database itself through SQL  statements. Very clever way to get high performance ETL processing but also very unique to them.   In this case, we'll need someone with Data Service experience who was a DBA or SQL developer in a former life, hence the purple squirrel connotation.

 

We have a team on the ground there at present….this role would interact with our team and also the client.    Ideally, the right candidate has excellent communication skills and some history in either the banking or financial services arena.     

 

 

CLIENT WILL PAY FOR TRAVEL BACK TO HOME BI-WEEKLY

CLIENT WILL ALLOW 4/10-hr DAYS (3 DAYS OFF / 4 DAYS ON)