What are the responsibilities and job description for the Data Warehouse Engineer with ETL position at SYSTEM EDGE (USA) L.L.C.?
Hello,
We are urgently hiring for the below role with our Direct client State of New York (NYS) :
Note :
We are the direct and prime vendors with the State Of New York.
JOB TITLE : Data Warehouse Engineer with ETL
Job ID : HBITS-06-13849
Location : 40 North Pearl Street, Albany, NY 12243 (Hybrid)
Duration : 24 months
Client / Dept. : New York State Office of Temporary & Disability Assistance (OTDA)
Rate : $68 / hr on C2C (All incl.)
Required Documents :
Stamped VISA Copy, Passport COPY, DL Copy / State ID, Bachelor Degree copy & 3 Prof. References - MUST FOR SUBMISSION – All Visa HoldersOnly DL – For USC
Job Description :
- 84 Months experience developing and testing query solutions using Oracle PL / SQL query.
- 84 Months experience with UNIX Shell Scripting.
- 84 Months experience with ETL design for Data Warehouse / Data Mart development using SQL and PL / SQL programming / IBM Data Stage.
- 72 Months experience with performance tuning and optimization of sessions, mappings, sources and targets, production support, trouble shooting and solving migration issues, and identifying errors during data loads and transformations for Cognos or OBIEE 10 / 11g environment.
- 72 Months experience using ER Studio for dimensional data modeling for Cognos or OBIEE 10 / 11g environment.
- 84 Months experience mentoring and assisting other developers
- 72 Months ETL development experience in Oracle environment with IBM Datastage.
- 60 Months ETL development experience working with PPI, SSA, or HIPPA data security requirements.
- Bachelor’s Degree in computer science, information science, engineering, or mathematics.
The responsibilities of the IT Specialist include, but are not limited to, participating in a team approach to :
Salary : $68