Position: ETL DataStage Developer
Location : Albany, NY 12240- Hybrid
Duration: 30 Month
Experiences Required:
· 84 Months DataStage Administrator experience on AIX environments that includes implementing and maintaining business and technical rules; automating ETL code migration process and standards forStop/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.
· 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 developing data analysis and metrics queries for operational oversight.
· 84 Months experience tuning SQL within an Oracle environment to improve timely and efficient execution of queries
· 84 Months experience developing dimensional data models for Cognos data analytics
· 84 Months UNIX Shell Scripting experience
· 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