IT Specialist

Position Duration: 30 Months
Client: State of NY – Department of Labor

Description

Daily tasks include, but are not limited to:

• Ensuring application documentation is complete, organized, accessible, and follows office standards.
• Writing, testing, debugging new and existing code based on program area knowledge, conceptual and technical design specifications.
• Writing and testing procedures, parameters and other specifications required to implement programs.
• Developing or assisting with the development of unit, component and program test plans.
• Implementing program changes and providing user support as required.
• Data Warehouse design, development, support and data mining related to new and existing complex Extract, Transform, Load (ETL) routines for Fraud Detection/Improper Payment algorithms.
• Developing, testing and implementing program logic for data mining and ETL development.
• Implementing ETL technical specifications from development through test, staging and production environments.
• Optimizing ETL data load jobs to improve performance and automate.
• Investigating and resolving data loading and/or data integrity issues.
• Creating solutions to improve system performance and availability.
• Developing and maintaining logical and physical dimensional data models for data warehouse/data mart.
• Writing clear documentation of process and data modeling and all associated tasks and documents including unit and quality assurance test plans.

Mandatory Qualifications

• 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 programming 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.

Required Documentation

• Résumé
• Copy of Candidate Identification (e.g., Driver’s License, Green Card, Visa, Passport)
• Any documents referenced in the above Requested Qualifications (e.g., professional certifications, degrees)