Job Title: IT Specialist - Expert Task ID: HBITS-08-14907 Position Duration: 30 Months Client: State of NY Agency: Department of Labor Please call
(703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at
[email protected] 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.
- Write and test procedures, parameters and other specifications required to implement programs.
- Develop or assist with the development of unit, component and program test plans.
- Implement program changes and provides user support as required.
- Data Warehouse design, development, support and data mining related to new and existing complex Extract, Transform, Load (ETL) routines related to Fraud Detection/Improper Payment algorithms;
- Develop, test and implement program logic for data mining and ETL development;
- Implement ETL technical specifications from development through test, staging and production environments;
- Optimize ETL data load jobs to improve performance and automate;
- Investigating and resolving data loading and/or data integrity issues;
- Create solutions to improve system performance and availability;
- Develop and maintain logical and physical dimensional data models for data warehouse/data mart;
- Write clear documentation of process and data modeling and all associated tasks and documents including unit and quality assurance test plans.
Mandatory Qualifications 1 72 Months ETL development experience in Oracle environment with IBM DataStage 2 84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming 3 84 Months experience tuning SQL within an Oracle environment to improve timely and efficient execution of queries 4 84 Months UNIX Shell Scripting experience 5 60 months experience in programming and unit testing. 6 60 months experience in program code documentation, mentoring and assisting other developers. 7 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 8 84 Months experience developing dimensional data models for Cognos data analytics 9 84 Months experience developing data analysis and metrics queries for operational oversight. 10 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
Required Documentation • Resume
• Copy of Candidate Identification
(i.e., Driver's License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications
(i.e., professional certifications, degrees, etc.) 
