ETL Developer

Class Valuation, LLC

Albany, United States of America

yesterday

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Senior

Albany, United States of America

IBM AIX

Data analysis

Unit Testing

Software Documentation

ETL

Data Security

Data Warehousing

IBM InfoSphere DataStage

Software Debugging

IBM Cognos Business Intelligence

Shell

Oracle Applications

PL-SQL

SQL Databases

Data Analytics

Code Migration

72 Months ETL development experience in Oracle environment with IBM DataStage
84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming
84 Months Experience tuning SQL within an Oracle environment to improve timely and efficient execution of queries
84 Months UNIX Shell Scripting experience
60 months experience in program and unit testing.
60 months experience in program code documentation, mentoring and assisting other developers.
60 months experience working with PPI and SSA data security requirements (working with data contained in Employee Records in a State Agency, Federal Agency or Private Organization) for production system error diagnosis, debugging, and code modification
84 Months Experience developing dimensional data models for Cognos data analytics
84 Months Experience developing data analysis and metrics queries for operational oversight.
84 Months DataStage Administrator experience on AIX environments that includes implementing and maintaining business and technical rules; automating ETL code migration process and standards for Stop/start services; monitor logs; setting up security; assigning roles; project permissions; Create/Delete projects; create/modify environmental parameters; Platform Issue resolution; troubleshooting and root cause analysis; Configuration and tuning of production and lower-level environments; and capacity planning.