Overview
Skills
Job Details
Role: IT Specialist-Expert ( ETL Developer)
Client: State of NewYork
Loc: ALBANY,NY
MOI: F2F
JD:-
IT Specialist - Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
Expert - 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
Requested Qualifications
- 84 Months Experience developing and testing query solutions using Oracle PL/SQL query.
- 84 Months UNIX Shell Scripting experience
- 84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming/ IBM DataStage
- 84 Months Experience tuning SQL within an Oracle environment to ensure timely and efficient execution of queries
- 72 Months ETL development experience in Oracle environment with IBM DataStage
- 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.
- 60 months experience in program and unit testing.
- 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
- 60 months experience in program code documentation, mentoring and assisting other developers
- Bachelor's Degree or Higher