· 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.
· Database design, development, support and data mining related to new and existing complex Extract, Transform, Load (ETL) routines related to Work Protections.
· 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 modelling and all associated tasks and documents including unit and quality assurance test plans.
Mandatory Skills/Experience Responsibilities:
- 72 Months ETL development experience in Oracle environment with IBM DataStage In collaboration with the CISO and IT team develop the agency information security strategy and key initiative
- 84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming Develop budget & resource requirement and execution plans for key cybersecurity initiatives
- 84 Months Experience tuning SQL within an Oracle environment to improve timely and efficient execution of queries Provide technical expertise for security projects
- 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