Lead DW/ETL Developer

TIAA

Contract Charlotte, North Carolina, United States Posted 7 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Lead DW/ETL Developer (Contract)

$60.00 / Hourly

Charlotte, North Carolina, United States

Lead DW/ETL Developer

Contract Charlotte, North Carolina, United States Posted 7 years ago

Description

Siebel OLAP Working knowledge of the Siebel Data Warehouse Key generation, WIDS, Slowly changing dimensions, basic table sources, etc. Concrete familiarity with OLTPtoOLAP. Proven experience with EIM Data Loads.Siebel Data Warehousing Multi Terabyte data warehousing experience. Understanding the design considerations for star schemas and its relationships. Understanding the concept of data rollups/aggregation, capacity planning, data standardization, slowly changing dimensions, and data security.Informatica (version 7.5 and up) or DataStage Multiple project experience with Informatica. Ability to communicate design considerations using this tool. Practical experience in loading data, troubleshooting mappings, tuning mappings, etc. Teradata or Oracle Multiterabyte data experience, demonstrates the basic ability/understanding to design data structures, performance tune data loads and ability to read/write BTEQ, PL/SQL.UNIX Proven experience with reading and writing Shell Scripts (ksh). Ability to navigate, edit/find files, check disk space and transfer files. Knowledge of performance monitoring tools in the UNIX environment. Communication skills Must have the ability to communicate effectively with business and technical users in both an oral and written manner. Must also be able to demonstrate ability to troubleshoot technology and business problems. Provide insight based on previous experience. Must work well independently and in a team environmentExperience with TERADATA a BIG PLUS.Experience with DataStage a BIG PLUS.Map and deploy Informatica mappings from various legacy source systems into SiebelDevelop and execute test and implementation plansPlus Skills/Experience include Siebel EIM Ability to create and modify Siebel EIM IFB files. Knowledge of mapping EIM tables to Siebel base tables. Ability to troubleshoot EIM loads. Knowledge of Siebel visibility and list of value design considerations.Operating Systems Unix AIX 5.1/5.2, Windows 2K, MVS/OS 390, AS400. Ability to navigate in these environments, ability to script technical solutions in each of these environmentsBusiness Demonstrated knowledge in the financial services arena focusing on Annuity Products, Mutual Funds, Brokerage, etcOther Analytics Tools Usage of Cognos, Business Objects, Microstrategy, Brio, Hyperion, Actuate or CrystalOther ETL Tools DecisionStream, ETI, Ab Initio, Data StageOther Databases Teradata, DB2/UDB, ADABAS, MS SQL serverSAS Ability to program in SAS

By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Questions / Comments:

Display Questions / Comments:

No Questions / comments

TIAA Vendors

( Login to see all the 22 vendors)
TEK Systems
Write a Review

971 Corporate Boulevard
Linthicum
Maryland
www.teksystems.com ( 85 vendors)

Capgemini
Write a Review

5 Times Square
New York
New York
www.capgemini.com ( 42 vendors)

NTT DATA Inc
Write a Review

100 City Square
Boston
Massachusetts
https://us.nttdata.com ( 36 vendors)

Job Summary

$60.00 / Hourly

Contract

Charlotte, North Carolina, United States

Experience Required : 8 Year/s

Posted : 7 years ago

Deadline : August 30, 2017 7 years ago

Job ID : Job0000009962

TIAA

8500 Andrew Carnegie

800-842-2252

https://www.tiaa.org